I'm All-In on Server-Side SQLite

• dqlite

  33 3,741 9.4 C

  Embeddable, replicated and fault-tolerant SQL engine.

  

• rqlite

  112 15,071 9.9 Go

  The lightweight, distributed relational database built on SQLite.

  

• InfluxDB

  www.influxdata.com featured

  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,063 9.4 C

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

  

• cr-sqlite

  28 2,503 9.4 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 923 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 47 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 607 9.3 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.

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

Suggest a related project