RegreSQL: Regression Testing for PostgreSQL Queries
Table of Contents Introduction Basic regression testing Performance regression testing ORM enters the room Test Data Management RegreSQL future TL;DR – RegreSQL brings PostgreSQL’s regression testing methodology to your application queries, catching both correctness bugs and performance regressions before production. As puzzling as it might seem, the common problem with production changes is the ever-present “AHA” moment when things start slowing down or crashing straight away. Testing isn’t easy as it is, but there’s a widespread practice gap when it comes to testing SQL queries. Some might pretend to “fix it” by using ORMs to abstract away the problem. Others treat SQL as “just glue code” that doesn’t deserve systematic testing. Most settle for integration tests…
