11–16 of 16 posts
One could probably go quite a ways in bare python with lists of dataclasses and pickles, never mind the performance.
That's your backend.
Then you might find some prior art in the way of a SQL parser for a front end.
Then there's also some projects who have tried to port or re-create SQLite in Rust.
They publish their latest course videos every year, during the year. Andy Pavlo is highly knowledgeable about the field.
I know you mentioned about RDBMS, but may I introduce you to a structured path for building a KV Store, which can be a foundation for a RDBMS? My project is in TDD fashion with the tests. So, you start with simple functions, pass the tests, and the difficulty level goes up. When all the tests pass, you will have written a persistent key-value store.
You may check https://cstack.github.io/db_tutorial which teaches writing an SQLite compatible database from scratch in C. I know you mentioned about RDBMS, but may I introduce you to a structured path for building a KV Store, which can be a foundation for a RDBMS? My project is in TDD fashion with the tests. So, you start with simple functions, pass the tests, and the difficulty level goes up. When all the tests pass…
https://15445.courses.cs.cmu.edu
Lectures start next month. Or you can watch previous years. Learn to walk before you run.