Comment by e28eta

The sentence you’ve quoted actually links to a list of ways to corrupt SQLite, which I think is interesting in its own right: https://www.sqlite.org/howtocorrupt.html

I believe your flaky SD card is category 4, Disk Drive and Flash Memory Failures.