News for hackers. Stuff that matters.
Re:Consider SQLite by rhn_mk1 on Wednesday December 29, 2021 @03:05PM (#29729328)
> machine level backups

I presume that's block level backups? Or some snapshotting?

As far as I know, block level filesystem copies can get inconsistent (so we have journalling file systems). But assuming it works well, like a filesystem aware snapshot, can sqlite deal with files snapshotted in the middle of an operation?

Re:Consider SQLite by greatjack613 on Wednesday December 29, 2021 @07:08PM (#29731809)
That's a really interesting questions, I have not even considered that. Just using my providers automated backup system. Never had to restore yet
Re:Consider SQLite by rhn_mk1 on Wednesday December 29, 2021 @07:12PM (#29731848)
They say a backup becomes a backup after it's successfully restored :)