You think query execution is the main part? Nope. The real work happens before that. In the previous post, you saw how SQLite executes queries as a bytecode program inside a virtual machine. We walked through how SQL gets compiled, how registers hold values, how joins actually run, and why
When you write: SELECT * FROM users; it doesn’t feel like you’re instructing a machine. It feels descriptive. Almost polite. You state what you want, and SQLite handles the rest. But inside the engine, nothing about that query is polite. There is no magical “SELECT” operation. There is no
Databases live in a pretty messy world: crashes happen, writes tear, and nothing is guaranteed. SQLite deals with all of that quietly in the background, and this post takes a look at how.