Offset pagination is the first thing everyone learns and the first thing that falls over in production. The product manager
Continue readingBeyond OFFSET: Keyset Pagination in PostgreSQL That Actually Scales
A few years ago, “supply chain security” meant checking your Docker base images for critical CVEs and hoping your dependency
Every major AI lab now ships a coding agent that lives in your terminal. What started as a niche experiment
Continue readingThe Terminal Wars: Comparing the Major CLI AI Coding Agents
Every schema migration is easy the first time, when the table is empty and the only user is your test
Continue readingZero-Downtime PostgreSQL Migrations: Locks, Rewrites, and Expand-and-Contract
Most Go services run for months without anyone touching a single GC knob, and that is exactly how the runtime
Continue readingThe Go Garbage Collector in Production: GOGC, GOMEMLIMIT, and Allocation Discipline
One Tuesday your API’s most popular endpoint works fine. Two Tuesdays later, a mobile app that has been calling it
Your microservice takes eleven seconds to answer a request that used to take two hundred milliseconds. The on-call engineer opens
Ask someone to sketch a transformer on a whiteboard and they’ll draw the 2017 version: softmax attention over every pair
Continue readingMHA, MQA, GQA, MLA: The KV-Cache Trade-offs Behind Every Modern Transformer
Every production rate limiter has two layers. The first layer is the algorithm: token bucket, leaky bucket, fixed window, sliding
# POST 2: Reading EXPLAIN A query that ran in 20 milliseconds yesterday takes 40 seconds today. Nothing in the
Continue readingReading EXPLAIN Like a Planner: Debugging Slow Queries in PostgreSQL