RegreSQL
Nik and Michael are joined by Radim Marek from boringSQL to talk about RegreSQL, a regression testing tool for SQL queries they forked and improved recently.
Here are some links to things they mentioned:
Here are some links to things they mentioned:
- Radim Marek https://postgres.fm/people/radim-marek
- boringSQL https://boringsql.com
- RegreSQL: Regression Testing for PostgreSQL Queries (blog post by Radim) https://boringsql.com/posts/regresql-testing-queries
- Discussion on Hacker News https://news.ycombinator.com/item?id=45924619
- Radim’s fork of RegreSQL on GitHub https://github.com/boringSQL/regresql
- Original RegreSQL on GitHub (by Dimitri Fontaine) https://github.com/dimitri/regresql
- The Art of PostgreSQL (book) https://theartofpostgresql.com
- How to make the non-production Postgres planner behave like in production (how-to post by Nik) https://postgres.ai/docs/postgres-howtos/performance-optimization/query-tuning/how-to-imitate-production-planner
- Just because you’re getting an index scan, doesn't mean you can’t do better! (Blog post by Michael) https://www.pgmustard.com/blog/index-scan-doesnt-mean-its-fast
- boringSQL Labs https://labs.boringsql.com
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is produced by:
- Michael Christofides, founder of pgMustard
- Nikolay Samokhvalov, founder of Postgres.ai
With credit to:
- Jessie Draws for the elephant artwork