Programmer Humor

32050 readers

1418 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

[email protected]

1309

Whoops (thumbsnap.com)

submitted 10 months ago by [email protected] to c/[email protected]

81 comments fedilink hide all child comments

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 13 points 10 months ago* (last edited 10 months ago) (2 children)

Transactions are your friend here

Begin transaction;

Then

Your sql here

Double/triple check the messages/console for results. Look good?

Commit;

Worried?

Rollback;

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

[–] [email protected] 16 points 10 months ago* (last edited 10 months ago) (1 children)

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.

[–] [email protected] 2 points 10 months ago

Absolutely. It should have been tested and verified.

[–] [email protected] 5 points 10 months ago

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!"