Comment by mholt
6 days ago
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.)
Would https://litestream.io/ perhaps help?
Definitely not sqlite-on-s3! Just for the photos and videos, and the periodic db backups
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.