Boring SQL: Time Off Manager (Part 1)
Fabian Zeindl: The API database architecture - Stop writing HTTP-GET endpoints
boringSQL: How not to change PostgreSQL column type
Brandur.org: The Notifier Pattern for Applications That Use Postgres
Robert Haas: Hacking on PostgreSQL is Really Hard
Emil Privér: Announcing DBCaml, Silo, Serde Postgres and a new driver for postgres
Dave Allie: ULIDs and Primary Keys
A curated list of awesome PostgreSQL software, libraries, tools and resources
BonesMoses.org: PG Phriday: Why Postgres is the Best Database Engine
Richard Yen: When Less is More: Database Connection Scaling (2021)
Modern SQL: The ANY_VALUE(…) Aggregate Function
Aiven: SQL query optimization: a comprehensive developer's guide
Emil Privér:
Grant Fritchey: Functions and Procedures
Michael is joined by Markus Winand, creator of use-the-index-luke.com and modern-sql.com, and author of SQL Performance Explained, to discuss Modern SQL — what Markus means by it, why it's important, some benefits, some examples, and at least one phrase that should be on a t-shirt.