Writing
tags
Long-form notes on backend architecture, database performance, and the parts of shipping software nobody puts on a slide.
Databases
Indexes Are Not Free and Your Write Path Knows It
Adding an index makes one read faster and every write slower. Most teams only ever measure the first half of that trade.
Databases
Reading Your Own Query Plans
Stop guessing which query is slow. EXPLAIN ANALYZE with BUFFERS tells you what actually happened, and the answer is usually not what you assumed.