The input to the front-end is a SQL query. sqlite architecture ()Ī query goes through a chain of components in order to retrieve or modify data. There’s lots of documentation of sqlite internals on their website, plus I’ve got a copy of SQLite Database System: Design and Implementation. The entire database is stored in a single file! Sqlite It’s modeled off sqlite because it is designed to be small with fewer features than MySQL or PostgreSQL, so I have a better hope of understanding it. To figure things out, I’m writing a database from scratch. In other words, how does a database work? What format is a prepared statement saved in?.When and how does a full table scan happen?.
Part 2 - World's Simplest SQL Compiler and Virtual MachineĪs a web developer, I use relational databases every day at my job, but they’re a black box to me. View on GitHub (pull requests welcome) Part 1 - Introduction and Setting up the REPL
