News for hackers. Stuff that matters.
Re:How to Corrupt an SQLite Database File by asveikau on Saturday October 05, 2013 @11:51PM (#6503031)
> when you wrote to disk, it was on disk.

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.

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.