Get the latest tech news
SQLite's documentation about its durability properties is unclear
Is SQLite durable by default? What settings guarantee durability? The documentation and even comments from its creator give conflicting answers.
Some applications can tolerate losing the last several seconds of commits in the event of a power failure, as long as the database doesn't end up corrupted. This is fine, but it's essential that the database clearly documents what its default durability properties are, and what each configuration setting guarantees. "If you switch to WAL mode, the default behavior is that transactions ... are not necessarily durable across OS crashes or power failures"
Or read this on Hacker News