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

The time keepers: pg_cron and pg_timetable
https://notso.boringsql.com/posts/time-keepers-pg-cron-pg-timetable/
#ycombinator #boringsql #sql #postgresql

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/

Ready to level up your SQL and PostgREST skills? 🚀 In the second installment of my PostgREST guide, you'll create a near-real-world example of business logic while exploring the security differences between VIEWs and FUNCTIONs. 📊🔒 #SQL #PostgreSQL #APIs #boringSQL

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

With first part of the Deep Dive into PostgREST trying to open tutorials/guides to create more with just PostgreSQL + SQL

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

#postgresql #sql #boringsql

How not to change PostgreSQL column type
https://notso.boringsql.com/posts/how-not-to-change-postgresql-column-type/
#ycombinator #boringsql #sql #postgresql

A small remark in The Bloat Busters article regarding ALTER COLUMN name TYPE new_type has sparked a number of questions. Here, then, is the answer:

How Not to Change a PostgreSQL Column Type - https://notso.boringsql.com/posts/how-not-to-change-postgresql-column-type/

#sql #boringsql #postgresql

Honestly, I'm surprised by the amount of interest and overall response. Despite my anti-social network behavior decided to give it a try. Here comes the #boringsql