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 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
# POST 1: Transactional Outbox (Slot 10 backend) You update a row in your database, then publish an event to
Continue readingThe Transactional Outbox Pattern in Go: Reliable Events Without Dual Writes