The SQLite Rewrite In Rust

(plus i make courses for them)

This is also the best way to support me is to support yourself becoming a better backend engineer.

### LINKS

[ThiagoRochaA]

Limbo is not the best place to leave your data

[randomexplosion]

Everything that can be rewritten in rust will eventually be rewritten in rust

[dirkschannel]

SQLite is the one project written in C that I would consider to be one of the most scrutinized open source code and thus put it on the bottom of the list of projects in need of a rewrite in Rust.
However I love Rust and enjoy using it.
Thanks to everyone involved :-)

[YvesBlatti]

Also : Chaos Godzilla is implemented for free by CrowdStrike

[augustdahlkvist]

Everybody is gangsta until their favourite library gets rewritten in rust

[username]

One very nice thing about sqlite is that it will compile on a large number of C compilers. This includes compilers available for older platforms, or embedded or more specialized use. Not everyone is running the latest MacOS / Windows / Linux. Rust is llvm compiler only and is available for far fewer platforms. Maybe that doesn't matter to your project, but it does matter.

[shadergz]

It's faster cause it doesn't have 1/3 of the SQLite features...

[ngideo]

Making Limbo async by default means it's a totally new database. The sync nature of SQLite makes it really attractive for a lot of embedded app use cases. Async and networking means its just another database server.

[BrettW]

Im here so fast I must be written in Rust.

[oflameo]

I am fine with SQLite keeping out posers, it keeps the project from inflating to nonsense.

[loafabread]

Elevator pitch: I am upset there are so many different SQL type syntaxes I've learned to use throughout the years... so lets just make fun of this first world problem with a new syntax called: YASS - "Yet another SQL syntax"

[thtcaribbeanguy]

primeagen is messing with my OCD when he highlights perfectly each time everything except the first letter and last

[seanwoods]

Deterministic Testing is not the same thing as 100 branch testing. The aircraft industry demands that every possible branch in the code is exercised in testing. Sqlite's current test suite does that. Also chaos monkey/gorilla/kaiju isn't really applicable to an embedded database.

[tate_rs]

We should make a page like the js framework one "Days Since Last Rust Rewrite" (I'm a Rust dev myself but this is kinda getting out of hands)

[PakRoc-dev]

I'll take the database protected by the Rule of St. Benedict, thanks.

[mberlinger]

As a business engineer it's hard to hear Squeal. I've only heard SQL or Sequel never Squeal 🐷

[mrpocock]

It will be interesting to see how they do the very core indexing data structures in rust. My understanding is that to make databases work well, they use very unsafe structures!

[ceigey-au]

I saw the thumbnail and thought “I hope they’re working with the Turso/LibSQL team”. And I guess they are!

[reybontje]

I'm thrilled if this can evolve into a maintained project.

There are so many cool embedded databases in Rust, but they also generally don't have a stable file format or become abandoned adter a few versions.

I basically am stuck with RocksDB as the best worst choice.

[roccociccone]

Yeah I've been investigating DST at work. It sounds cool I just gotta get used to testing like that...