Nov 24, 2024 I wanted to learn how databases like SQLite store data under the hood, so I decided to write some code to inspect the database file. SQLite famously stores the entire database in a single file, and the file format is very well documented. Here is one diagram1 to get started instead of the roughly 13,848 words in that document. While not impossible, it is somewhat tedious to read through the file format documentation and figure out what exactly you need to get started. The above diag...