Programmer Humor

32410 readers

262 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]

1313

Whoops (thumbsnap.com)

submitted 1 year 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] 20 points 1 year ago (2 children)

I don't understand environments that don't wrap things in transactions by default.

Especially since an update or delete without a where clause is considered valid.

[–] [email protected] 9 points 1 year ago* (last edited 1 year ago)

I'm a data engineer that occasionally has to work in sql server, I use dbeaver and have our prod servers default to auto-wrap in transactions and I have to push a button and confirm I know it's prod before it commits changes there, it's great and has saved me when I accidentally had a script switch servers. For the sandbox server I don't have that on because the changes there don't matter except for testing, and we can always remake the thing from scratch in a few hours. I haven't had an oppsie yet and I hope to keep that streak

[–] [email protected] 3 points 1 year ago

SQL Server technically does behind the scenes, but automatically commits, which kind of defeats the purpose.