I used SQLite in an embedded life safety system for years. It was storing settings and history events on an industrial MicroSD card. Failure happens for the most common reasons it happens across all other products.

1) MicroSD card started producing bad sectors. 2) Power failure during write. 3) Fraudulent MicroSD being used.

Settings section of the database where written so few times that they could be recovered. It was the journaling of events for analysis that where the ones to be lost. Most of the time it was a page or two that was corrupted and the database worked just fine until detailed reporters where created.

Settings where also mirrored to a backup location. Unless the client wanted to pay more for history backup it was only retained locally.