Blog
Tutorials, guides, and insights to help you become a better developer.
A measured tour of B-tree indexes on PostgreSQL 17, with real query plans for index-only scans, the visibility map, HOT updates, and the selectivity point where the planner abandons your index.
AdminAugust 7, 202610 min read
Shopify replaced Redis with MySQL SKIP LOCKED for inventory reservations. DoorDash replaced Redis Cluster with stateless Kvrocks. The lesson isn't "Redis is bad" — it's about matching infrastructure to access patterns.
AdminAugust 5, 202612 min read
PostgreSQL and MySQL look similar on the surface. Choose the wrong one and you'll spend months fighting your database instead of building your product.
AdminFebruary 2, 202610 min read