Re:I Accidentally Deleted All Our Data
by joevandyk on Friday November 18, 2011 @03:25PM
(#3253260)
It depends, if you're working with a smaller database with a smaller team with a smaller client base, there's not as much harm. There could possibly be more harm in having more ceremony for doing simple things.
[ Parent
| on HN ]
I disagree with this. Making a script and testing it against a copy of the database is a good idea in 100% of cases. The only reason you don't do that is because you're lazy and stupid. (I've done this because I'm lazy and stupid.)
When you defeat a safety interlock system, expect to be injured.
There is no efficient safety interlock system when modifying data.
Even if confident your test passed, what happens when you later realize it hadn't, and at what cost?
No one said it'll work 100% of the time. But it most likely would have saved the OP a lot of pain. Just because something isn't a perfect solution, it doesn't mean it's not worth doing.