[mholt]

I don't think sqlite runs very well on S3 file systems. I think it would also be insufferably slow.

I even encountered crashes within sqlite when using ExFAT -- so file system choice is definitely important! (I've since implemented a workaround for this bug by detecting exfat and configuring sqlite to avoid WAL mode, so it's just... much slower.)

[msylvest]

Would https://litestream.io/ perhaps help?

[wizzard0]

Definitely not sqlite-on-s3! Just for the photos and videos, and the periodic db backups

[mholt]

I see... that might make it hard to keep all the data together, which is one of the goals. But I will give it some thought.