Episode 169
RegreSQL
Postgres FM · Nikolay Samokhvalov and Michael Christofides
January 16, 202657m 40s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
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:
- 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!
~~~
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
Topics
PostgresPostgreSQLDatabasesSQLtechnology