Build your own SQLite, Part 1: Listing tables

by upmindon 8/17/24, 11:13 PMwith 12 comments
by bluejekyllon 8/18/24, 3:09 AM

An interesting idea just struck me. If this is all in native Rust then you could do something interesting with macro defined SQL queries, where at compile time, you could output direct bindings from the SQL to the internal DB api. This would skip parsing and building query plans at compile time (for static queries).

Anyway, cool project.

by mo_42on 8/18/24, 10:45 AM

I came across this blog as well because I got interested in writing a compiler that converts SQL into source code of a type-checked language.

Are there any blog series about the details of query planning, optimization etc?