Could you elaborate more on those things abstracted by SQLite? or point to furth...

Lex-2008 · on July 27, 2022

Not OP, but I remember reading an interesting article about issues that simple write() might face: 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