Deep dive into Turso, the "SQLite rewrite in Rust"
41 points
1 hour ago
| 4 comments
| kerkour.com
| HN
sauercrowd
2 minutes ago
[-]
> ... most of which can be fixed by a rewrite in Rust

huh? That is clearly not the case. memory bugs - sure. Not having a public test suite, not accepting public contributions, weakly typed columns and lack of concurrency has nothing to do with the language. They're governance decisions, that's it.

>I see this situation trhough the prism of the innovator's dilemma: the incumbent is not willing to sacrifice a part of its market to evolve, so we need a new player to come and innovate.

I don't think the innovators dilemma quite applies in the open source world. Projects are tools, that's it. Preserving a project for the sake of preserving it isn't a good idea.

If people need to run a sqlite db in these exotic places, shedding it means someone else has to build their own tool now that can do it. Sqlite has decided that they care about that, so they support it, so they can't use rust. Seems sound.

Projects coming and going is a good thing in open source, not a bug.

reply
tln
15 minutes ago
[-]
Where is the "networked mode" in Turso? Turso's readme and docs do not mention anything like this
reply
gcr
7 minutes ago
[-]
There's no such thing as "networked mode" in SQLite to my knowledge. SQLite only supports one writer from one machine at a time; other writers will fail to acquire a write lock.

In WAL mode, SQLite may use shared memory to coordinate multiple writers from multiple processes on the same machine. Is this what you mean?

reply
yunohn
26 minutes ago
[-]
What a breath of fresh air to read a blog not written by AI, with actual human learnings and opinions. Thanks for the write up!
reply
9rx
34 minutes ago
[-]
> A database that can scale from in-process to networked is badly needed

Why not Postgres? https://pglite.dev

reply
rudedogg
13 minutes ago
[-]
From what I’ve read there’s a pretty sizable performance gap between SQLite and pglite (with SQLite being much faster).

I’m excited to see things improve though. Having a more traditional database, with more features and less historical weirdness on the client would be really cool.

Edit: https://pglite.dev/benchmarks actually not looking too bad.. I might have something new to try!

reply
causalscience
31 minutes ago
[-]
> Why not Postgres?

Because I don't want another server/service.

Is this a good enough justification in your opinion, or did you just want to say the meme?

reply
avhception
27 minutes ago
[-]
Did you actually click the link? pglite aims to be embeddable just like sqlite.
reply
roywiggins
26 minutes ago
[-]
pglite runs in wasm so it should be possible to embed it where you want, like sqlite?
reply