4 ms·

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 -

by mholt 1y 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.)

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