Writing

39 long-form articles on production engineering — how real systems fail, why, and what actually fixed them.

2 articles matching “API Design”

Query OptimizationJul 14, 202613 min read

Page 1 Loads in 8ms, Page 5,000 Takes 4 Seconds — The OFFSET Trap and How Cursors Fix It

Every list endpoint ends in LIMIT 20 OFFSET ?. It has an index, page one returns in 8ms, and it passes review — then one Tuesday page 4,000 takes four seconds and a nightly export job stops finishing.

Load BalancingApr 19, 202615 min read

Load Balancer Explained: L4 vs L7 — What the Door-Person Actually Sees

A simple, ground-up guide: L4 forwards raw TCP/UDP by IP and port, L7 opens the HTTP request and routes by URL, host, headers or cookies.