Writing
tags
Long-form notes on backend architecture, database performance, and the parts of shipping software nobody puts on a slide.
Databases
The N+1 Query You Ship Every Sprint
featured
Nine out of ten performance regressions I have diagnosed in production were the same bug wearing different clothes: an unloaded relation inside a loop that nobody noticed because the staging database has 40 rows.
Databases
Stop Using Publish Timestamps as Ordering Keys
Sorting by published_at looks correct until two posts share a timestamp, and then pagination starts silently duplicating and dropping rows.