Embed Notice

@eniko oh hello and welcome to the sqlite3 fan club

edit: OK, no, sorry, I can be helpful instead of flippant. Beg your pardon there.

Sqlite3 does offer ACID compliance, but its key value proposition is that it does so with minimal additional complexity. The use case it tries to fill is making it easier to be ACID-compliant than to not be: https://www.sqlite.org/whentouse.html#:~:text=Sqlite%20does%20not,fopen%28%29

And by golly it has succeeded wildly, cf.:

https://danluu.com/file-consistency/

https://danluu.com/deconstruct-files/#:~:text=except%20for%20sqlite,at%20least%20one%20bug

1/2