Akshat Jaimini: Making pgweb rock-solid: Using the Testing Harness to ensure the quality of pgweb

Join Akshat Jaimini as he demonstrates the Testing Harness, a crucial tool for ensuring the quality of pgweb, using Selenium and Lighthouse for functional and accessibility testing, and how it's integrated with GitHub Actions.

Key takeaways
  • The testing harness is a crucial tool for ensuring the quality of PgWeb, a codebase for the official PostgreSQL website.
  • The harness uses Selenium for functional testing and Lighthouse for accessibility testing.
  • The team is working on testing the authentication portion of the website and plans to extend it to other PostgreSQL websites.
  • The testing process involves crawling the website, testing forms, and checking for broken URLs.
  • The team is using an automated script to load the entire documentation and test it.
  • The testing harness is integrated with GitHub Actions, which makes it easier to run tests.
  • The team is planning to add security tests and archive bugs.
  • The harness uses the Palm API to sanitize reports and suggest improvements.
  • The team is working on making the testing process more efficient and reducing the time it takes to run tests.
  • The testing harness is open-source and can be contributed to.
  • The team is planning to extend the testing harness to other PostgreSQL websites.
  • The harness uses Django ORM to test the database.
  • The team is working on testing the documentation loading pipeline and reporting dead URLs.
  • The testing harness is used to monitor the activities on the website and send complaints to the concerned authorities.
  • The team is planning to add a permanent storage solution for the testing harness.
  • The testing harness is a crucial tool for ensuring the quality of PgWeb and making it more accessible to users.