News for hackers. Stuff that matters.
Re:Cron-based backup for SQLite by amcvitty on Sunday May 15, 2022 @08:39AM (#31387203)
Not an expert but the transaction log is in another file and you’d need both to be in line with each other and backed up, so perhaps that’s a factor
Re:Cron-based backup for SQLite by benbjohnson on Sunday May 15, 2022 @09:36AM (#31387483)
I wrote up a bit longer explanation of the failure modes (which depend on your journaling mode) in this comment: https://news.ycombinator.com/item?id=31387447