SQLIte database file format diagrams
During my CodeCrafters SQLite project, I’ve found the SQLite database file format document to be rather complete, but nonetheless, for a variety of reasons, hard to use.
In this article I present easy to read diagrams, that one can refer to while developing the exercises.
The fields described in the diagrams are a subset of the full specification - they’re only those required to solve the problems of the CodeCrafters project; some concepts are therefore skipped, e.g. overflow.
The green background color indicates fields that are shared across different page types; if fields of a child are highlighted, but not the parent, it means that the child itself is optional, but when present, its highlighted fields are mandatory.
If you find any error, please contact me, or add a comment (below)!
Index interior page
Index leaf page
Table interior page
Table leaf page