🐿️
14

My first SQL database crashed and I lost a whole weekend of work

Honestly, I spent like 12 hours on Saturday building out this little inventory tracker for my vinyl collection in SQLite. Then on Sunday, I ran some random script I found on Stack Overflow and it wiped the whole table. I didn't even have a backup, rookie mistake. Anybody else lose data because they trusted some random online code without testing it first?
2 comments

Log in to join the discussion

Log In
2 Comments
eric_carr
eric_carr1d ago
Trust me, that script probably didn't wipe your data, just dropped the table and it's still in the database file if you stop writing to it.
2
parkerb75
parkerb751d ago
still in the database file if you stop writing to it" is way too optimistic for most people. They'll panic and keep using the app which just overwrites everything.
1