News for hackers. Stuff that matters.
Re:Build your own SQLite in Rust, Part 5: Evaluating queries by Animats on Thursday February 20, 2025 @12:10AM (#43111337)
I wish someone would finish a decent database in Rust. At least get it to 1.0 stable and go on from there.

- Limbo: "Limbo is a work-in-progress..."

- Sled [1]. Not sure what's going on there. Last release 3 years ago, but a constant stream of "alpha" versions that never get released.

SQLite with Rust bindings seems to be the go-to system. Depending on C packages is often a headache when cross-compiling, though.

[1] https://crates.io/crates/sled/

Re:Build your own SQLite in Rust, Part 5: Evaluating queries by koakuma-chan on Thursday February 20, 2025 @12:36AM (#43111479)
I recommend `rusqlite` or `heed` (`lmdb` wrapper, key-value database). I think `sled` is abandoned.
Re:Build your own SQLite in Rust, Part 5: Evaluating queries by tyushk on Thursday February 20, 2025 @01:18AM (#43111692)
SurrealDB [1] is a fairly complete database written in Rust. I've used it for fairly small web apps and it felt comfortable to work with coming from MongoDB.

[1] https://github.com/surrealdb/surrealdb?tab=readme-ov-file

Re:Build your own SQLite in Rust, Part 5: Evaluating queries by Tanjreeve on Thursday February 20, 2025 @01:41AM (#43111801)
SurrealDB is still really coy on its performance/what it's good at/not good at to adopt for a major data project. There's lots of features but no real indication as to if I could scale them for a dataset of billions of records. I've had my fingers burnt too many times before by products with a big table of tick box features but none of them are really usable (e.g Geospatial data comes up for me a lot)

Either you need to make it easy and zero friction to adopt like duckDB and let people find out themselves in an hour or two or you need to provide some sort of benchmarks + evidence that it isn't going to die on its arse the moment you put larger than memory amounts of data in.

Nearly all of these projects work fine for in memory size datasets but only finding out after you've put major effort into adoptionv+integration isn't really easy for someone working with data when you have something battle tested like Postgres et Al.

Re:Build your own SQLite in Rust, Part 5: Evaluating queries by mattturck on Friday February 21, 2025 @01:55PM (#43131421)
Re:Build your own SQLite in Rust, Part 5: Evaluating queries by Tanjreeve on Sunday February 23, 2025 @05:46AM (#43148376)
That's great they got some out two weeks ago. This has been a couple of years getting here.
Re:Build your own SQLite in Rust, Part 5: Evaluating queries by fooker on Thursday February 20, 2025 @02:08AM (#43111934)
Starting projects is fun and easy. Finishing is not.
Re:Build your own SQLite in Rust, Part 5: Evaluating queries by n_plus_1_acc on Thursday February 20, 2025 @02:40AM (#43112102)
influxdb is great
Re:Build your own SQLite in Rust, Part 5: Evaluating queries by noirscape on Thursday February 20, 2025 @06:08AM (#43113368)
The problem that Rust runs into is that the community settled on wanting enforced semver extremely quickly, combined with an overall tendency to really not want to do post-1.0 releases if they can help it.

The result is that most Rust crates sit on the 0.x version forever (since anything before 1.0 in semver is pretty much a free-for-all), even though they're probably going to be perfectly usable in most cases with the same library breakage you expect in other languages.

IMO it just shows another dent in thinking that a simple string can confer any information about the API contracts on offer. Semver is a neat indicator, but practically that's all it is.

Re:Build your own SQLite in Rust, Part 5: Evaluating queries by anarki8 on Saturday February 22, 2025 @08:39AM (#43138877)
redb is what are you looking for

https://github.com/cberner/redb