Live Read Replicas for SQLite

github.com

27 pointspw4 comments

Couldn't you just put a safety on the footgun and let users decide if it's worth the risk to forgo safety checks.

Now only cloudflare workers and fly.io will have zero-effort distributed sqlite.

Litestream author here. Yes, I could release the replication in Litestream with caveats but it’s mostly a matter of focus. I don’t think I’d feel right trying to support two implementations of replication when only one is recommended.

The new replication tooling will not be fly.io specific. It’ll be Apache 2 licensed just like Litestream. You can run it on any VM-like server. We are also working on making it work on pure serverless platforms like Vercel & Deno in the future.

Dang. Read replicas would have been awesome but I respect the reasoning. Looking forward to what's to come.

A dream feature would be litestream functionality in C for a native lib that could work with redbean.

Thanks. We are looking at making a VFS version in the future that’s mainly meant to work on serverless but I could see integration with redbean being interesting too.

Reply on news.ycombinator.com