rqlite 6.0: the evolution of a distributed database design

• rqlite

  112 14,835 9.9 Go

  The lightweight, distributed relational database built on SQLite.

  

I'm not sure how folks use it, but I think the sweet spot is for simple-to-run relational storage for a smallish set of data.

Some people don't use it for the distribution, but just like a HTTP API in front of SQLite.

https://github.com/rqlite/rqlite/blob/master/DOC/FAQ.md#why-...

• kine

  12 1,403 8.2 Go

  Run Kubernetes on MySQL, Postgres, sqlite, dqlite, not etcd.

  

Not to be mistaken for high-availability Dqlite[1], which is one of the options one can run the k3s kubernetes distribution on (instead of etcd), via the Kine etcd shim[2]. Ultimately though the K3s team replaced Dqlite with an embedded etcd to get high-availability[3].

[1] https://dqlite.io/

[2] https://github.com/k3s-io/kine

[3] https://rancher.com/docs/k3s/latest/en/installation/ha-embed...

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• dqlite

  33 3,713 8.7 C

  Embeddable, replicated and fault-tolerant SQL engine.

  

Not to be mistaken for high-availability Dqlite[1], which is one of the options one can run the k3s kubernetes distribution on (instead of etcd), via the Kine etcd shim[2]. Ultimately though the K3s team replaced Dqlite with an embedded etcd to get high-availability[3].

[1] https://dqlite.io/

[2] https://github.com/k3s-io/kine

[3] https://rancher.com/docs/k3s/latest/en/installation/ha-embed...

• Olric

  28 3,005 6.1 Go

  Distributed in-memory object store. It can be used as an embedded Go library and a language-independent service.

Have you considered using olric[0]?

Just asking so that I can piggyback on your research :)

[0] https://github.com/buraksezer/olric

• litestream

  165 9,933 7.5 Go

  Streaming replication for SQLite.

Interesting! An old colleague of mine, Ben Johnson, also does the same thing for litestream, his latest SQLite replication project. I thought it was just him.

Now that I know two folks do it, I'll have to give it serious thought. Thanks for the blog post ref

https://github.com/benbjohnson/litestream

• sql.js

  43 12,191 6.5 JavaScript

  A javascript library to run SQLite on the web.

  

It wouldn't make too much sense to run a distributed raft-based SQLite system in its entirety in a browser (via WASM). However, you can run an individual SQLite instance in the browser (via WASM) using this: https://sql.js.org/#/

Suggest a related project