Hacker News new | ask | show | jobs
by quickthrower2 2733 days ago
What is the source of the corruption. Unlikely to be disks nowadays but people should take backups of things. Very unlikely to be a SQLite buggy write but again a backup could save you. Worse case I’m sure there are tools to recover a corrupted file.
1 comments
darkpuma 2733 days ago
There are plenty of things that can cause it: https://www.sqlite.org/howtocorrupt.html
link
ineedasername 2733 days ago
Nice of them to publish a guide for those who enjoy corrupted data :)

I particularly liked Fake capacity USB sticks. I didn't even realize that was a think. I can't even...

link
JoeAltmaier 2733 days ago
Oh this goes way back. The first SSD drives from Hong Kong advertised double or quadruple their capacity - you didn't find out until you tried to write the N+1th block and it overwrote the 0th block. Back in the 90's?
link