Comment by wizzard0
6 days ago
Wow that's great! Interesting if it's possible to use not just a folder but like a s3-compatible backend for photos and for db backups as well
(I don't think all my photo/video archives would fit on my laptop, though the thumbnails definitely would, while minio or something replicated between my desktop plus a backup machine at Hetzner or something would definitely do the thing)
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.