Store SQLite in Cloudflare Durable Objects

Re:Store SQLite in Cloudflare Durable Objects by quadrature on Tuesday January 25, 2022 @11:06AM (#30073410)

A long these lines if you're looking for a way to sync your SQLite DB to an S3 like object store there is https://litestream.io/. It creates a snapshot of your DB on s3 and then handles checkpointing of the WAL.

[ Parent | on HN ]

Re:Store SQLite in Cloudflare Durable Objects by Glench on Tuesday January 25, 2022 @11:19AM (#30073627)

Yes, love Litestream! It felt like the missing piece for replacing Postgres or MySQL with SQLite.

[ Parent | on HN ]

Re:Store SQLite in Cloudflare Durable Objects by wirelesspotat on Tuesday January 25, 2022 @12:57PM (#30075296)

Does anyone know if it's possible to use Litestream with SQLite running on Cloudflare Durable Objects?

I suppose you'd have to compile Litestream to WASM or have Litestream running on a different machine and reading SQLite from the Durable Object?

[ Parent | on HN ]

Re:Store SQLite in Cloudflare Durable Objects by benbjohnson on Tuesday January 25, 2022 @01:18PM (#30075650)

Litestream author here. I haven’t looked at Durable Objects yet so I don’t think Litestream would currently work with it. I may add support in the future but I’m adding separate serverless functionality to be released later this year. That’ll allow Litestream to run on Cloudflare Workers or GCR or other ephemeral platforms like those.

[ Parent | on HN ]

Re:Store SQLite in Cloudflare Durable Objects by Glench on Tuesday January 25, 2022 @01:31PM (#30075884)

Haha check the original post, my friend

[ Parent | on HN ]

Re:Store SQLite in Cloudflare Durable Objects by WrtCdEvrydy on Tuesday January 25, 2022 @12:14PM (#30074517)

That is something I was looking for.

[ Parent | on HN ]