How does SQLite work? Part 1: pages! by Julia Evans.
From the post:
This evening the fantastic Kamal and I sat down to learn a little more about databases than we did before.
I wanted to hack on SQLite, because I’ve used it before, it requires no configuration or separate server process, I’d been told that its source code is well-written and approachable, and all the data is stored in one file. Perfect!
…
Following Julia down a rabbit hole to program internals encourages you to venture out on your own!
I can’t say why her posts have that quality, but they do.
Enjoy!
I first saw this in a tweet by FoundationDB.