I decided to spend some time digging into SQLite. I highly recommend the overviews of their architecture and the details about each part of the puzzle.

It's really understandable, very straight forward, even if a lot of it refers to SQLite v2, it still seems very relevant.

http://www.sqlite.org/arch.html