Thoughts, ideas, and things I find interesting.
How B-trees use fixed-size pages, page splits, WALs, and latches to keep database indexes fast and recoverable
How SSTables, memtables, compaction, and Bloom filters make LSM-trees fast for writes and range queries
How append-only logs, indexes, compaction, and storage-engine trade-offs shape database performance
Graph databases, Cypher, triple stores, and choosing the right model for connected data
Takeaways on SQL, query optimizers, MapReduce, and why declarative queries make systems easier to evolve
My takeaways on choosing between SQL, document databases, and other data models as systems grow.
Building systems that survive failure, scale with real workloads, and remain easy to evolve
How Discord cut Gateway traffic 40% with Zstandard and deltas