Dylan Paulus: Postgres: The Graph Database You Didn't Know You Had
Bitesized Engineering: Database Isolation Levels - explained as if you were building a Snowman
Cybertec: PostgreSQL: DELETE vs. TRUNCATE
Cruncy Data: Introduction to Postgres Backups
Cybertec: Breaking your PostgreSQL database with bad CHECK constraints
Christophe Pettus: Everything you know about setting
work_mem is wrong.
To set work_mem, take the number of connections, add 32, divide by your astrological sign expressed as a number (Aquarius is 1), convert it to base 7, and then read that number in decimal megabytes.
Cybertec: PostgREST: Get started with automated PostgreSQL APIs
Crunchy Data: The Integer at the End of the Universe: Integer Overflow in Postgres
Supabase: Type Constraints in 65 lines of SQL
The Build: UUIDs vs serials for keys
Anton Zhiyanov: Ranking data with SQL Window Functions