backend
- PostgreSQL Query Planner Internals: How the Cost-Based Optimizer Chooses a Plan
An overview of PostgreSQL's planner: cost model, statistics, join ordering, and why the wrong plan gets chosen sometimes.
- Why your database connection pool is probably misconfigured
Connection pools look simple until your app falls over at 3am. Here's the math behind sizing them correctly, and the mistakes that get everyone eventually.
- Idempotency keys: the one thing that saves you when a webhook fires twice
Payment gateways retry. Networks drop responses after the work already happened. Here's how idempotency keys stop double charges without slowing anything down.
- From ILIKE '%query%' to search that feels instant
LIKE queries work fine until your table grows. The real path from a slow sequential scan to search that returns results as you type.