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: https://www.youtube.com/watch?v=Jib2AmRb_rk
– 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 https://discord.gg/YNtU8Yw7yT