This and this needs Jepsen testing.

The value of SQLite is how robust it is and that’s because of the rigorous test suite.