Not OP, but I remember reading an interesting article about issues that simple write() might face: https://danluu.com/deconstruct-files/ https://danluu.com/deco

Not OP, but I remember reading an interesting article about issues that simple write() might face: https://danluu.com/deconstruct-files/ https://danluu.com/deconstruct-files/ And here's what SQLite does to ensure that in case of application or computer crash database contains either new or old data, but not their mix or some other garbage: https://sqlite.org/atomiccommit.html https://sqlite.org/atomiccommit.html