Hacker News Reader

Comment by losfair | Hacker News Reader

Came over this article as I was looking for interesting resources in the SQLite ecosystem. I'm building mvsqlite (https://github.com/losfair/mvsqlite), as an attempt to turn SQLite into a proper distributed (not just replicated) database. Check it out if you are looking for this kind of stuff!

View on HN

I presume you're familiar with https://github.com/canonical/dqlite (made by my employer) and https://github.com/rqlite/rqlite (unrelated)? How will mvsqlite compare to those?

There's a page in the wiki doing the comparison: https://github.com/losfair/mvsqlite/wiki/Comparison-with-dql...

Anything done by Canonical shouldn't be used at all or you gonna regret it, when Canonical decides to abandon it.

It's already happened to:

- Juju

- Upstart

- Unity

- Mir

- Quickly

- Ubiquity

- Landscape (barely maintained)

- Ubuntu One

- Ubuntu Phone

- you_name_it

I think it's due to Canonical thinks that they have their own very special dedicated way and vision. But always ends up screwed.

Why ?

Why not, looks like a great project for people building on SQLite who may want to migrate to a distributed solution who determine it's a better solution than replication for their use-case.

SQLite is a powerful SQL query engine. When combined with a rock-solid distributed storage layer, we get a distributed SQL database, just like what systems like Aurora and Neon have managed to build on MySQL and PostgreSQL.

Seems reasonable. I wonder how it compares to existing things in the space? It'd be cool to bring the test suite into the distributed world as well, I guess.

Reply on news.ycombinator.com