Re:SQLRite – SQLite clone from scratch in Rust
by efficax on Friday April 09, 2021 @05:12PM
(#26756246)
This is interesting. I think you'll soon find that the in-memory data structures provided by Rust's std::collections aren't going to work for you when you start thinking about on-disk storage of data.
One resource that is invaluable for learning about databases is the code to the original Berkeley DB
Re:SQLRite – SQLite clone from scratch in Rust
by joaoh82 on Saturday April 17, 2021 @05:32PM
(#26847619)
thanks for the tip man. I think you are right. Rust data structures might do the job at first, specially for in-memory operations. But on-disk storage if definitely going to be a problem.
Re:SQLRite – SQLite clone from scratch in Rust
by alexvoda on Friday April 09, 2021 @08:13PM
(#26757719)
This should be a great learning project. SQLite is very high quality and simpler than other SQL servers so it is probably a good project to clone.
There is obviously no need for it and it will take a very long time to get to where SQLite is now. But that is not the point.
Re:SQLRite – SQLite clone from scratch in Rust
by sneak on Friday April 09, 2021 @09:51PM
(#26758251)
> Rust-SQLite, aka SQLRite , is a simple embedded database modeled off SQLite, but developed with Rust. The goal is get a better understanding of database internals by building one.
Re:SQLRite – SQLite clone from scratch in Rust
by hajile on Friday April 09, 2021 @09:29PM
(#26758142)
I might agree in principle, but the results are objectively worse for developers and users.
They should have taken the time to make a new generation of SQL with improved syntax and ergonomics. Instead, we got something that requires complex boilerplate to do simple things with gaping flaws and almost completely devoid of features (all of this while still being built on top of sqlite).
One resource that is invaluable for learning about databases is the code to the original Berkeley DB
https://github.com/386bsd/386bsd/tree/9eaf3b3359255f461055b8...
On a tagentially related note SQLite has a great page on CVEs https://www.sqlite.org/cves.html
That's not what I think of when I read "clone".
You can run SQLite in the browser now using Wasm.
They should have taken the time to make a new generation of SQL with improved syntax and ergonomics. Instead, we got something that requires complex boilerplate to do simple things with gaping flaws and almost completely devoid of features (all of this while still being built on top of sqlite).
Who does the work?