On: SQLite-on-the-server is misunderstood: Better at hyper-scale than micro-scale

[jimbokun]

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 → jimbokun]

Enabling WAL mode means you don't have a single file anymore.

[catgirlinspace → timewizard]

You 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 → catgirlinspace]

The WAL has a minimum size. In this context I assumed you would not be using SQLite to serve requests serially.

[pstuart → timewizard]

More work than grabbing a single file but still easy enough to use: https://www.sqlite.org/backup.html