13 min read/0 views
A 47-second Postgres query took 120ms on ClickHouse. Columnar storage, vectorized execution, and why your analytics belong in OLAP.
13 min read/0 views
One trillion SQLite databases exist right now. Turso, Litestream, and D1 fixed every limitation. Stop defaulting to Postgres.
14 min read/1 views
Redis is not just a cache. Sorted sets, streams, pub/sub, and HyperLogLog changed how I architect everything.
16 min read/9 views
Most teams don't need Pinecone. pgvector benchmarks, decision framework, and when dedicated vector DBs actually make sense.