Re:Cron-based backup for SQLite
by 1958325146 on Sunday May 15, 2022 @10:38AM
(#31387821)
I ran into the case of needing to back up a write-heavy database without blocking anything, and came up with a solution: Writing a VFS ( https://www.sqlite.org/vfs.html ) that makes the application move the Sqlite journals file to a directory for processing instead of deleting them. Another process reads them to see what pages were touched and can very quickly get the changes to update the backup.
[ Parent
| on HN ]
There are no comments on this comment yet.