4 ms·

Came over this article as I was looking for interesting resources in the SQLite ecosystem. I'm building mvsqlite (https://github.com/losfair/mvsqlite https://gi

Came over this article as I was looking for interesting resources in the SQLite ecosystem. I'm building mvsqlite (https://github.com/losfair/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!

WaxProlix 4y ago
Why ?
- mythz 4y ago
  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.
- losfair 4y ago
  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.
  - WaxProlix 4y ago
    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.
deleted 4y ago
[deleted]
benhoyt 4y ago
I presume you're familiar with https://github.com/canonical/dqlite https://github.com/canonical/dqlite (made by my employer) and https://github.com/rqlite/rqlite https://github.com/rqlite/rqlite (unrelated)? How will mvsqlite compare to those?
- losfair 4y ago
  There's a page in the wiki doing the comparison: https://github.com/losfair/mvsqlite/wiki/Comparison-with-dqlite-and-rqlite https://github.com/losfair/mvsqlite/wiki/Comparison-with-dql...
- mldbk 4y ago
  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.

WaxProlix 4y ago

Why ?

mythz 4y ago
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.
losfair 4y ago
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.
- WaxProlix 4y ago
  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.

deleted 4y ago

[deleted]

benhoyt 4y ago

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

losfair 4y ago
There's a page in the wiki doing the comparison: https://github.com/losfair/mvsqlite/wiki/Comparison-with-dqlite-and-rqlite https://github.com/losfair/mvsqlite/wiki/Comparison-with-dql...
mldbk 4y ago
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.