Regression Testing
Explore regression testing techniques for SQL queries in PostgreSQL to prevent bugs during code changes. Understand how to use psql, regression test suites, and tools like pgTap and RegreSQL. Learn to automate tests, capture results, and diagnose issues effectively to maintain reliable database applications.
We'll cover the following...
We'll cover the following...
Regression testing protects against introducing bugs when refactoring code. In SQL, we refactor queries, either because the calling application code is changed and the query must change too, or because we’re hitting problems in production and a new optimized version of the query is being checked in to ...