In the previous posts, we've explored the SQLite file format and built a simple SQL parser. It's time to put these pieces together and implement a query evaluator! In this post, we'll lay the groundwork for evaluating SQL queries and build a query ev...| Geoffrey Copin's Blog
As we saw in the opening post, SQLite stores metadata about tables in a special "schema table" starting on page 1. We've been reading records from this table to list the tables in the current database, but before we can start evaluating SQL queries a...| Geoffrey Copin's Blog
I wanted to learn how databases like SQLite store data under the hood, so Idecided to write some code to inspect the database file. SQLitefamously stores the...| blog.jabid.in
After discovering the SQLite file format and implementing the .tables command in part 1 and part 2 of this series, we're ready to tackle the next big challenge: writing our own SQL parser from scratch. As the SQL dialect supported by SQLite is quite ...| Geoffrey Copin's Blog
