-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
-
Bedrock
Rock solid distributed database specializing in active/active automatic failover and WAN replication (by Expensify)
-
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
-
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.
-
"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
-
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.
Related posts
-
Marmot: Multi-writer distributed SQLite based on NATS
-
Rqlite: Lightweight, user-friendly, distributed relational db built on SQLite
-
rqlite: A lightweight, user-friendly, distributed relational db built on SQLite
-
Show HN: Rqlite and Docker and SQLite-vec – highly-available Vector Search
-
The lightweight, easy-to-use, distributed relational database built on SQLite