Radim Marek from boringSQL talks about tests for SQL - It works on my database - Regression testing of SQL queries

#postgresql #pgconfde #boringsql

Good CTE, Bad CTE

https://boringsql.com/posts/good-cte-bad-cte/

#HackerNews #GoodCTE #BadCTE #SQL #DataAnalysis #BoringSQL #HackerNews

Instant database clones with PostgreSQL 18

https://boringsql.com/posts/instant-database-clones/

#HackerNews #InstantDatabaseClones #PostgreSQL18 #DatabaseManagement #TechNews #BoringSQL

Vacuum Is a Lie: About Your Indexes

https://boringsql.com/posts/vacuum-is-lie/

#HackerNews #VacuumIsALie #Indexes #Database #BoringSQL #HackerNews #SQL

With summer in full swing it's time to take things easy - Gentle Introduction to Window Functions is for those stuck in SQL-92 times :)

https://notso.boringsql.com/posts/window-functions-introduction/

#postgresql #boringsql

Almost no PostgreSQL cluster can run without job scheduler - let's find out when to pick pg_cron and when it's time to power up with pg_timetable

https://notso.boringsql.com/posts/time-keepers-pg-cron-pg-timetable/

#postgresql #boringsql

Now with the PostgREST deep dive completed, you can find it (and hopefully share it) as single guide

https://notso.boringsql.com/guides/postgrest-apis-made-easy/

#postgresql #postgrest #boringSQL

Time for PostgREST - we are closing the series with the authentication and authorization.

https://notso.boringsql.com/posts/postgrest-tutorial-part3/

#PostgreSQL #APIs #boringSQL

It's PostgreSQL extension time! Rust + pgrx = surprisingly magical combo. ✨ All that with sample pg_sysload for smarter batch processing based on the system load

#boringSQL #rust #postgresql

https://notso.boringsql.com/posts/custom-postgresql-extensions-with-rust/