a curated list of database news from authoritative sources

September 08, 2022

Choosing a Postgres Primary Key

Turns out the question of which identifier to use as a Primary Key is complicated -- we're going to dive into some of the complexity and inherent trade-offs, and figure things out

September 07, 2022

Supabase Beta August 2022

Launch Week Special. See everything we shipped, plus winners of the Hackathon and the extended Community Highlights

September 06, 2022

September 05, 2022

September 01, 2022

August 29, 2022

Zero downtime Laravel migrations

Learn how to run no downtime non-blocking schema migrations in your production Laravel app with PlanetScale.

August 28, 2022

Mining the MySQL Performance Schema for Transactions

The MySQL Performance Schema is a gold mine of valuable data. Among the many nuggets you can extract from it is an historical report of transactions: how long a transaction took to execute, what queries were executed in it (with query metrics), and idle time between queries. Mining this information is not trivial, but it’s fun and this blog post shows how to start.