Choosing an ID
Integers, UUIDs, ULIDs, or something with meaning. The decision is permanent and it leaks into everything.
#databases
12 pieces tagged databases,
from June 13, 2025 to September 18, 2026.
The annual Postgres upgrade you keep deferring
A new major version every autumn, a five-year support window, and a migration that gets worse the longer you leave it.
Connection pooling, explained properly
Why your database has 400 connections, why that is bad, and how to size a pool without guessing.
Migrations that don't wake anyone up
Data migrations at scale, done in a way that is reversible at every step and boring in the middle.
The database you should have chosen
Postgres. That's the article. Here's the longer version, including the cases where it's wrong.
Schema design is the only design that lasts
Your code will be rewritten. Your API will be versioned. Your data model will outlive both and every mistake in it is permanent.
SQLite in the browser and the end of the API round trip
A real relational database in WebAssembly with durable storage. What it makes possible and what it breaks.
Local-first is finally practical
CRDTs got good, sync engines got boring, and the offline-capable app stopped being a research project.
Postgres 18's async I/O, four months in
The biggest storage-layer change in years is in production now. Here's what it actually did to real workloads.
SQLite in production, seriously
It is not a toy database. For a large class of applications it is a better choice than the thing you're using.
Linux 6.16 and the steady grind of filesystem work
Faster ext4 writes, more Rust bindings, and a release with no headline feature. That's a good sign.
Meta buys half of Scale AI and most of its leadership
$14.3 billion for 49%, and Alexandr Wang moves to run a new superintelligence lab. The data layer just got picked.