Week 11–12, PostgreSQL @ GSoC’23 — The Final Leg

Week 11–12, PostgreSQL @ GSoC’23 — The Final Leg

Hello Everyone!


Week 11–12, PostgreSQL @ GSoC’23 — The Final Leg

Hello Everyone!

This is the final installment in my Google Summer of Code 2023 Devlogs as we approach the end of this season. It has been an amazing journey so far, the mentors have been amazing and helped me whenever I got stuck on a problem.

Quick Recap

Last week, work was done on enhancing the URL tests and submitted the patch which is yet to be reviewed by the community members. Work was also done on validation of multiple URL & markdown fields.

Accessibility Testing

As we discussed in the last blog, accessibility tests were added to the testing suite. For this we are using a simple to use tool —Unlighthouse. This tool using Google Lighthouse to crawl the entire development build to check for accessibility issues. Currently we are generating a csv report but soon we’ll be shifting to a report format which will be able to host itself on the internet for easier accessibility.

Error Reporting Using Email

As discussed in the last blog, there was no error reporting mechanism as such. So we added a new script which uses smtplib library available in python. The email template generated consists of all the reports attached and a link to the action run that generated the email. Whenever any tests fail, the script is run. The script is as follows:

Conclusion

With this the base of the testing suite has been completed!

Now the project is open for contributions and we hope that this tool helps the amazing PostgerSQL-www community in their effort to maintain the official PostgreSQL website.

To checkout the project and raise issues and provide suggestions kindly check it here.

Thanks for following our journey!

By Akshat Jaimini on August 22, 2023.

Canonical link

Exported from Medium on March 25, 2025.


<
Previous Post
Week 9 10 Postgresql Gsoc 23
>
Next Post
Automating Log Analysis And Troubleshooting With Palm Api