Live Read Replicas for SQLite (opens in new tab)

(github.com)

27 pointspw3y ago4 comments

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

pstuart3y ago

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.

benbjohnson3y ago

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.

j / k navigate · click thread line to collapse

4 comments

unraveller3y ago

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.

benbjohnson3y ago

pstuart3y ago

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.

benbjohnson3y ago

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.

j / k navigate · click thread line to collapse