2 ms·
Enabling WAL mode means you don't have a single file anymore.
by timewizard 2y ago
Enabling 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