Databases — BitByteStack

topics all databases systems design backend devops networking security

~/databases/b-tree-vs-lsm-tree.md

$ cat b-tree-vs-lsm-tree.md

B-Tree vs LSM-Tree: The Index Trade-off

databases 7 min read

PostgreSQL uses B-Trees. Cassandra and RocksDB use LSM-Trees. Why? The answer comes down to whether your workload is…

~/databases/sql-query-optimisation-basics.md

$ cat sql-query-optimisation-basics.md

SQL Query Optimisation: The Basics That Actually Matter

databases 6 min read

EXPLAIN ANALYZE, index selectivity, avoiding full-table scans, the N+1 problem — the practical optimisation moves that…