mini-sqldb-rs This is a personal learning project where I'm diving into the world of SQL databases by building one from scratch using Rust. The primary goal here is to solidify my understanding of Rust while exploring the inner workings of a database system. (ΰΉβ’Μγ β’Μ)Ωβ§
Yes, the real goal is to write more Rust, explore database internals, wrestle with async & ownership, and maybeβjust maybeβmake peace with lifetimes. π§ββοΈ)
To better understand how this database engine works, here are two architecture diagrams:
This diagram gives an overview of how the SQL execution pipeline is structured.
Detailed Architecture βοΈ (Click to expand)
Still at the beginning of the journey! π± This project is my attempt to build a SQL database from scratch, and so far, Iβve only scratched the surface. There's a lot more to come!
- Database Core
- β Database architecture
- β
Basic SQL execution (
SELECT,CREATE TABLE,INSERT) - β In-memory and basic disk-based storage
- β Transactions ACID properties and MVCC
- Next Focus: Refinement Basic sql
- π add update, delete, order by
- π limit, offset
- π projection