Hacker News new | past | comments | ask | show | jobs | submit login

> modulo write ahead journal and whatnot

That's like saying immortality is trivial modulo death and whatnot. If you don't integrate with sqlite's locking system, you can easily "backup" a file mid-write, corrupted and unusable.

That's why sqlite has a built-in backup command.




Litestream does streaming backups using a separate process: https://litestream.io/


I guess my secret is having almost no writes (the couple things I deployed with SQLite would see a dozen writes per month).




Join us for AI Startup School this June 16-17 in San Francisco!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: