Hacker News new | ask | show | jobs
by llagerlof 46 days ago
I used SQLite for a few applications several years ago. One time, the database got corrupted and all the data was lost. That was the day I stopped using SQLite.

Also, the lack of enforced column data types was always a negative for me.

4 comments

No matter the medium, backups are a must.
A hard lesson learned...
I used a hard drive for a few applications several years ago. One time, the drive got corrupted and all the data was lost. That was the day I stopped using hard drives.
This isn't the same and you know it.
For column types there are STRICT tables now
Thank you!
> the database got corrupted

What caused that?

I don't know why that happened, but one fine day I tried to open the file using the vanilla SQLite client, and it didn't open.