Re:How to Corrupt an SQLite Database File
by ceejayoz on Sunday October 06, 2013 @08:30AM
(#6503877)
The D is "durable", not "will survive the apocalypse along with the cockroaches". I've got plenty of things I'd describe as durable while being capable of breaking.
Re:How to Corrupt an SQLite Database File
by asveikau on Sunday October 06, 2013 @11:47AM
(#6504397)
Right. I guess I was just trying to point out that most instances of an sqlite corruption are probably not going to be the drive lying about a flush, or an interrupted write. It's going to be a disk that gives you back different bits than you (successfully) put in.
So, if the drives didn't lie about a flush that problem is solved. But if it's on disk at time t, that's no guarantee that you can read it back at time t+1. The drives can physically fail. These "days of old" are before my time, but I really doubt they had magic disks that never physically degraded.