Database Design & Internals
Indexes, query planning, transactions and how databases are built.
Advanced
Once the basics are comfortable.
Document
Advanced
↗ External site
Architecture of SQLite
A short tour of how a real database is put together: the tokenizer, parser, code generator, virtual machine, B-tree and pager.
Sign up to see the source
Document
Advanced
↗ External site
Let's Build a Simple Database
Build a small SQLite-style database in C, one step at a time: a REPL, a B-tree on disk, and how rows are stored and found.
Sign up to see the source