The Blog
Notes on databases, distributed systems, and the engineering habits that keep software dependable in production.
## Introduction Your application writes a row. PostgreSQL says "committed." The server loses power one millisecond later. When it comes back, is your row there? The answer is y...
## Introduction Your application has one user. Concurrency is not a problem. That user reads data, writes data, nothing conflicts with anything. Then you have ten thousand users...
## Introduction Your single database server handled your first 100,000 users just fine. Then you hit a million. Queries slowed down. Disk filled up. You threw more RAM at it. It ...
## Why B+ Trees Exist Your database has 50 million rows. You query by user ID. Without an index, the database reads every row until it finds yours. That's a full table scan. It g...
## Why Single-Database Transactions Don't Scale A transaction in a single database is simple. You start a transaction, make changes, commit. Either everything commits or nothing ...
## Why Replication Exists Your database will crash. Not maybe. It will. Hard drives fail, memory corrupts, someone runs the wrong command, power goes out. When that happens, you ...
## Introduction Most developers understand SQL. Fewer understand what happens after the query planner finishes — how rows are physically laid out on disk, why certain writes cost...
## Introduction At some point you ship something that works perfectly in staging. The code is clean. The tests pass. You deploy it and feel good about it. Six months later you'r...
## Why This Matters in Production Every backend engineer has a story about a production incident that made ACID properties real. Maybe it was a race condition in a payment system...
## The Real Cost - What happens when you don't have idempotency Every backend engineer has experienced this: a user clicks a button, the request times out, they panic and click i...
## Introduction Your database has 50 million users. Someone searches by email. Without an index, the database reads every single row until it finds a match. That's a full table s...