I'm All-In on Server-Side SQLite

• dqlite

  33 3,902 9.5 C

  Embeddable, replicated and fault-tolerant SQL engine.

  

• SaaSHub

  www.saashub.com featured

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

  

• rqlite

  121 15,863 9.9 Go

  The lightweight, user-friendly, distributed relational database built on SQLite.

  

• Bedrock

  25 1,120 9.8 C

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

  

• cr-sqlite

  30 2,892 6.5 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

  19 1,149 8.5 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 63 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

  6 752 9.1 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.

Suggest a related project