Hacker News new | ask | show | jobs
by wizzard0 256 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)
1 comments
mholt 256 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.)

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