I'm All-In on Server-Side SQLite

• dqlite

  33 3,716 9.5 C

  Embeddable, replicated and fault-tolerant SQL engine.

  

• rqlite

  112 14,862 9.9 Go

  The lightweight, distributed relational database built on SQLite.

  

• 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.

  

• Bedrock

  23 1,044 9.4 C

  Rock solid distributed database specializing in active/active automatic failover and WAN replication (by Expensify)

  

• cr-sqlite

  28 2,418 9.7 Rust

  Convergent, Replicated SQLite. Multi-writer and CRDT support for SQLite

  

If you need multiple writers and can handle eventual correctness, you should really be using cr-sqlite[1]. It'll allow you to have any number of workers/clients that can write locally within the same process (so no network overhead) but still guarantee converge to the same state.

[1] https://github.com/vlcn-io/cr-sqlite

• litestack

  16 877 8.9 Ruby

Related: I wrote a piece last week on deploying Rails apps to production on Fly.io at https://fly.io/ruby-dispatch/sqlite-and-rails-in-production/

The work that’s made this possible is:

1. Litestack - https://github.com/oldmoe/litestack

2. Fly.io’s work on the dockerfile-rails generator detecting Sqlite and Litestack in a Rails project, then setting up sane defaults for where that data is stored and persisted in production. This is all done behind the scenes with no intervention required from the person deploying.

3. Servers are overall faster and more powerful

I hope more Rails hosts make it easier and safer to deploy Sqlite to production. It will lower costs and reduce complexity for folks deploying apps.

• sqlite-migrate

  2 43 6.8 Python

  A simple database migration system for SQLite, based on sqlite-utils

"unless you have a bunch of logic centralized somewhere to keep track of last know schemas per user client database"

I've been building exactly that here: https://github.com/simonw/sqlite-migrate

• corrosion

  5 586 9.4 Rust

  Gossip-based service discovery (and more) for large distributed systems. (by superfly)

  

We’re using cr-sqlite as part of our distributed state propagation system. It is indeed easy to bundle in the app!

https://github.com/superfly/corrosion

It would be possible to distribute cr-sqlite changes in many different ways (like you said, http or torrents, etc.) since any change can be applied out of order.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

Suggest a related project