Jul 5, 2026 · 25 min read
Database Migrations at Scale: Zero-Downtime Schema Changes and What Companies Actually Do
## Why Migrations Break A migration that runs in 200ms on your local machine takes 30 minutes on the production table ...
Engineering Notes
I explore how modern systems behave under pressure, document design tradeoffs, and share field notes from building dependable software.
Consistency models and how they surface in real-world systems.
Storage engines and the tradeoffs inside modern databases.
Reliability patterns for resilient services under failure.
## Why Migrations Break A migration that runs in 200ms on your local machine takes 30 minutes on the production table ...
## Why Caching Exists A single database query takes 5ms. A cache lookup takes 1ms. The difference seems small — but at...
## 1. What TCP Actually Is, and Why It Exists Start with the network underneath TCP, because that's the whole reason T...