I was wondering if there was a good way of backing up an SQLite database
if you do *not* have access to the SQLite command line tool (which I
know has .backup - https://stackoverflow.com/a/25684912).
The new VACUUM INTO (https://www.sqlite.org/lang_vacuum.html#vacuuminto)
is not an option either because I'm using this via PHP on a remote host
I have no control over, and its version of SQLite will definitely be
older than 3.27.0.
I've considered simply running "PRAGMA wal_checkpointer;" and then
copying the file immediately after that, but that still seems prone to
sqlite-users mailing list