The regresql tool implement a regression testing facility for SQL queries, and supports the PostgreSQL database system. A regression test allows to ensure known results when the code is edited. To enable that we need:

- some code to test, here SQL queries
- a known result set for each SQL query
- a way to set up test data in a consistent state
- a regression driver that runs queries again and check their result against the known expected result set

The RegreSQL tool is that regression driver. It helps with creating the expected result set for each query and then running query files again to check that the results are still the same. It also provides declarative fixture system for managing test data, making it easy to set up complex database states with generated or static data.

Of course, for the results the be comparable the queries need to be run against a known PostgreSQL database content.

pg_timetable is an advanced standalone job scheduler for PostgreSQL, offering many advantages over traditional schedulers such as cron and others. It is completely database driven and provides a couple of advanced concepts.

Free, open source and self-hosted solution for automated PostgreSQL backups. With multiple storage options and notifications

At Reddit, we have four Core Models that power pretty much all use cases: Comments, Accounts, Posts and Subreddits. These four models were being served out of a legacy Python service, with ownership split across different teams. By 2024, the legacy Python service had a history of reliability and performance issues. Ownership and maintenance of this service had become more cumbersome for all involved teams. Due to this, we decided to move forward into modern and domain-specific Go microservices.

In the second half of 2024, we moved forward with fully migrating the comment model first. Redditors love to share their opinions in comments, so naturally the comment model is our largest and highest write throughput model, making it a compelling candidate for our first migration.