|
|
|
|
|
|
by Cthulhu_
478 days ago
|
|
|
> What I’d really like is an easy way to sync the SQLite database state to a cloud service. Don't do this, but an application I used to work on (to replace it) copied the sqlite file to a folder then used rsync to sync it with a backup node. Apparently it worked and was good enough for that use case (inefficient php backend application with at most a dozen concurrent users). 100.000 rows is only a few megabytes at most, right? Should be fine. |
|
|
What's wrong with that? Of course it will work fine; SQLite, with or without WAL, has a ton of protections against corruption from writes-in-progress, which is what makes hot backups work.