3 ms·
> I'm hoping to use it for nightly backups of a webapp I'm building that uses sqlite exclusively The easiest recipe for this is to use sqlite3 $SRC "vacuu
by ralferoo 2y ago
> I'm hoping to use it for nightly backups of a webapp I'm building that uses sqlite exclusively
The easiest recipe for this is to use
sqlite3 $SRC "vacuum into '$DEST'"
$DEST must not already exist, personally I prefer to put the timestamp into the filename and keep the last n copies.
- gary_0 2y agoI'm aware of the existing backup methods, but AFAIK they don't do a delta of only the changed pages (unless I use separate software), and "vacuum into" doesn't work over SSH. I have no need to store a backup on the same physical server. Also, the backup server will keep snapshots, and with sqlite3-rsync I can just update a previous snapshot with the changed pages rather than redundantly transferring the whole database over every time.
- simonw 2y agoYeah, the unique benefit of sqlite-rsync looks to be efficiently backing up medium to large databases that don’t change enormously (so deltas are worthwhile) over an SSH connection. I particularly like that you don’t need double the disk space to create the temporary backup copy before downloading it.