SQLite: Let's read the code
We take a look at the SQLite source code. SQLite is everywhere and it has a reputation as being an amazing piece of software. We focus here on the most basic elements: mainly the b-tree data structures and how SQLite lays out files. But we also dip our toes into query planning, especially at the end of the episode.
SQLite has great technical documentation. Check out their site below to read some of it.
Useful links:
Site: https://sqlite.org/index.html
Code: https://www.sqlite.org/src
GitHub Mirror: https://github.com/sqlite/sqlite
A technical talk by Richard Hipp, the SQLite author: • SQLite: The Database at the Edge of t...
A fork called libSQL with a more community-driven development model: https://libsql.org/
Thanks for watching :)
Join the Ants Are Everywhere Discord channel at / discord