3 ms·
Isn't the simplest way to "sync" to just replace the remote database file with the local database file? One of the nice things about each database being encaps
by jimbokun 2y ago
Isn't the simplest way to "sync" to just replace the remote database file with the local database file? One of the nice things about each database being encapsulated as a single file.
- timewizard 2y agoEnabling WAL mode means you don't have a single file anymore.
- catgirlinspace 2y agoYou could do a checkpoint first though I believe? And if the database is only being updated on your local client I don’t think WAL mode would have much benefit since it’s probably not getting many concurrent writes.
- timewizard 2y agoThe WAL has a minimum size. In this context I assumed you would not be using SQLite to serve requests serially.
- pstuart 2y agoMore work than grabbing a single file but still easy enough to use: https://www.sqlite.org/backup.html https://www.sqlite.org/backup.html