Building a B+Tree in Rust: What I Got Wrong Before Getting It Right
A walkthrough of design mistakes I made implementing a B+Tree in Rust — from treating all nodes as in-memory …
#Database
Stop Blaming Your Database — It's Your Pagination That's Slow
Database queries getting slower as users scroll deeper? OFFSET pagination is the culprit more often than not. …
PostgreSQL 18 Asynchronous IO Revolution: Why This Is the Biggest Database Update in 5 Years
PostgreSQL 18's asynchronous IO with io_uring delivers 3.4x faster sequential scans, 2.1x faster index scans. …
Go + sqlc + Postgres: The Zero-ORM Stack Behind Cloudflare's 99.99% Uptime
Cloudflare runs Go + sqlc + Postgres in production, bypassing GORM's N+1 queries and reflection overhead. 85K …
PostgreSQL 18 Benchmark Data: I Said You Could Kill Your Redis Cache Layer. You Didn't Believe Me.
Real benchmark data for PostgreSQL 18: async IO + skip scan deliver a massive database performance leap. …
PostgreSQL Query Parsing Too Slow? PgDog Ditched Protobuf and Got 5x Faster
PgDog is a Rust-based PostgreSQL proxy. They discovered Protobuf serialization was the real bottleneck in SQL …
PostgreSQL 18 vs Redis: The Day I Realized Our Cache Layer Was Optional
PostgreSQL 18's async IO and skip scan made our database so fast that Redis caching became optional. Three …