This project is meant to be a two pronged approach at learning Rust with an actual project, practicing actual CS by having to learn how to manipulate low level logic and applying some algorithms that my frontend carreer haven't really require me to do. Thanks to codecrafters Sqlite track for the guidance.
[DEPRECATED] - Turned it into a REPL
- .dbinfo
- .tables
- .schemas
- base select queries
- index search
- Improve searching speeds
- AND statements
- Pretty printing of tables
- Turn into simple REPL
- Introduce table joins
- Introduce alter tables
- Add transactions
If for some reason you are curious about this project, you can just try to play with it locally
cargo run
> load sample.db
> sql select * from apples
> sql select id, name from oranges
> .tables // Will show all the tables declared in your db first page
> .dbinfo // Will show you (incomplete) db info
> .schemas // Will print a debug of the tables columns