4 ms·
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 ha
by joevandyk 15y ago
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.
- jrockway 15y agoI 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.
- matc 15y agoThere 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?
- kelnos 15y agoNo 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.