How to Corrupt a SQLite Database File
In another life (2007) I worked for a company that does digital signage. We had about 8000 systems deployed across the US.
The software on them relied heavily on SQLite. At some point we started seeing random corrupted SQLite databases.<p>Trying to figure out what was causing this we realized our pc manufacturer was using the same sku but hardware inside could vary... and in particular the hard drive.
Every system with a corrupt DB had a particular brand hard drive (WD), the ones that didn't fail was another (Seagate).<p>We never really spent much more time on this other than to lock down the hardware config and replace all the hard drives in the failed systems with the "good" brand.<p>Super interesting to see this. I'm assuming it was: Disk drives that do not honor sync requests<p>We were of course using consumer grade equipment, because the company was pretty cheap, but also we had so many to deploy. I wonder how much this cost the company to fully resolve. Between systems not playing, having to send technicians, shipping systems overnight, time troubleshooting, etc.