As I said in a comment you responded to. > Programs can deal with the issue by performing atomic full writes by performing renames, but most programs don't bot

As I said in a comment you responded to. > Programs can deal with the issue by performing atomic full writes by performing renames, but most programs don't bother to. SQLite cannot do that, because it cannot afford doing full writes as databases tend to store a lot of data. I'm aware you can do that, but most programs aren't. If you pick any random program, chances are it won't do that.