this post was submitted on 06 Nov 2023
1303 points (98.8% liked)
Programmer Humor
32410 readers
361 users here now
Post funny things about programming here! (Or just rant about your favourite programming language.)
Rules:
- Posts must be relevant to programming, programmers, or computer science.
- No NSFW content.
- Jokes must be in good taste. No hate speech, bigotry, etc.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Transactions are your friend here
Then
Double/triple check the messages/console for results. Look good?
Worried?
Just be sure to mind your transaction logs for long running queries and by all things holy be sure you’re not doing this to a live db with a ton of transactions since you’re basically pausing any updates until the commit or rollback on the affected tables
This makes it safer but like... don't run queries on production outside emergencies ever.
That transaction frame, depending on your specific DB, may cause severe performance side effects.
Look, the safe approach is to write it into something, PR it, get it reviewed, and then run it as part of a structured deployment process.
Absolutely. It should have been tested and verified.
Me: "Ok. What's the big deal."
Also me: "Less than a million affected. That's nothing."
Still me: "Rule 1: Never let pesky details get in the way of a funny meme."
Ultimately me: 😱😂 "That guy is in for a rough Monday!"