Get the latest tech news

Big Endian's Guide to SQLite Storage

I wanted to learn how databases like SQLite store data under the hood, so Idecided to write some code to inspect the database file. SQLitefamously stores the...

We create a tiny test database and dump all its internal state with hexdump and a small program I wrote called rsqlite. Hexdump is smart enough to avoid duplicate null rows with a single* and make the output readable, so we can share the whole contents inline right here. The blog briefly covers the various types of btree pages in the “Growing a tree” section, but my favorite is when Ben asks “OK, But Why?” and follows up with some simple answers.

Get the Android app