Why Databases Have Indexes (And What They Actually Are)
#indexes#b-tree#lsm-tree#wal
Most engineers use databases like black boxes. But the moment your data grows — or your queries slow down — you need to know what's inside. How does a B-Tree actually find your row? Why does a `LIKE '%foo'` query kill your performance? What does "ACID" mean in practice, not in marketing? Start here to stop guessing.