News for hackers. Stuff that matters.
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.

There are no comments on this comment yet.