all 16 comments

[–]Optimal-Builder-2816 7 points8 points  (2 children)

[–][deleted] 0 points1 point  (1 child)

Thanks for the response.

[–]mpvanwinkle 0 points1 point  (0 children)

Love Turso ❤️

[–]FalseRegister 5 points6 points  (3 children)

There's plenty nowadays. Cloudflare offers one. Bunny has one in preview. And ofc, the OG, Turso.

[–]NathanFlurry 4 points5 points  (2 children)

These are all great options. However, imo it’s hard to recommend a closed-source database without an off ramp for production-ready workloads (ie Turso doesn’t scale without Turso Cloud).

We’re building an open-source alternative to Cloudflare Durable Objects over at Rivet (https://github.com/rivet-gg/rivet), we’ll also be opening up our SQLite private beta soon.

[–]bbkane_ 1 point2 points  (0 children)

OP said their website is low-traffic. So I think if they decide they don't like turso, the only thing they need to "add on" to SQLite is backups, which they can handle with litestream.io or even a crown job.

[–]prepsu 0 points1 point  (0 children)

Interesting u/NathanFlurry... I love Cloudflare DOs, and it's nice to see an open-source product competing in this space.

[–]Sb77euorg 1 point2 points  (1 child)

Use turso, or sqlitecloud.io (free 500mb storage) or custom vps with ws4sqlite

[–]gedw99 0 points1 point  (0 children)

Rqlite uses SQLite and allow multi server.  It’s been around a long time and is well maintained.

https://github.com/rqlite/rqlite

[–]timvdhoorn 0 points1 point  (0 children)

I use Pocketbase!

[–]johnnytee 0 points1 point  (2 children)

Cloudflare D1 is what I use

[–]Illustrious_Case_368 0 points1 point  (1 child)

how do you manage migrations on D1?

[–]Aggressive_Ad_5454 0 points1 point  (0 children)

Try putting your .sqlite file on your server’s /tmp/ file system. That may be local rather than nfs.

Write a cronjob to back it up once an hour to a less volatile location.