I've been using SQLite in production with a few dozen kiosk-style systems (mostly OSX Mac Minis w HDDs) for a few years and while it's generally been great to work with, with unexpected power loss, I've intermittently gotten corruption w partial/total table losses.

I looked into switching to Redis AOF or some other append-only system, but adding UPSs and switching to Linux-based systems w power loss protected SSDs seemed solve the problems.