Build your own SQLite in Rust, Part 5: Evaluating queries

1. turso

   1 12 12,980 10.0 Rust

   Turso Database is a project to build the next evolution of SQLite.

   

   SQLites successor in rust is a thing though

   https://github.com/tursodatabase/limbo

2. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

3. surrealdb

   2 109 29,947 9.7 Rust

   A scalable, distributed, collaborative, document-graph database, for the realtime web

   

   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

4. SpacetimeDB

   3 27 17,363 9.9 Rust

   Multiplayer at the speed of light

   

   > without years of hardwork on test you can't say you are correct

   Before, I have the myth in my head that RDBMS development is like cryptography/kernels: Something not mean for humans to do.

   Now working as part of a [team](http://spacetimedb.com) I see now that is hard, but doable.

   Certainly MORE EASY than working in ERPs that is the thing that I have done for more than 20 years (now THAT is what is insane). Literally doing RDBMS is more relaxing than doing ERPs.

   But what I have learned is that what make RDBMS truly hard is not the usual suspect: ACID.

   You don't need 'years of hardwork' to reach it and to prove them is right (only some insanity when you need to target very weird os/arcs and deal with faulty hardware).

   What is truly hard and will eat your time is sql. SQL is hard. Is *bad*. Is *very hard* to optimize, and is so anemic that your time is expended more in the query optimizer (that has hard time because sql more than anything else) and because sql is bad, I tell you, it leads to insane stuff like having a single query with 1000 joins, and people have not means to good, optimal designs (and what you have like CTE and all that is poor bandaids) so now you get a bad input and have fun.

   But if the RDBMS stay in the relational part and you could make a better lang to interface it then is far more easy. Still query optimizer is big part of your time, but if you have control of the input language you can do your live easy.

5. redb

   4 25 3,932 9.5 Rust

   An embedded key-value database in pure Rust

   

   redb is what are you looking for

   https://github.com/cberner/redb

Suggest a related project