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
PostgreSQL 18 UUIDv7: Your Indexes Can Finally Breathe
PostgreSQL 18 brings native UUIDv7 support with 50% index performance improvement. Say goodbye to UUIDv4 …
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 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 …
pgvector 0.8.0 Is Here: Do You Still Need a Dedicated Vector Database?
Your CTO approved a $50k Pinecone contract. An intern added vector search to your existing PostgreSQL for free …