1306

Whoops (thumbsnap.com)

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

80 comments fedilink hide all child comments

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

[-] [email protected] 20 points 8 months ago

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 8 months ago* (last edited 8 months 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 8 months ago

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

this post was submitted on 06 Nov 2023

1306 points (98.7% liked)

Programmer Humor

31331 readers

14 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 4 years ago

MODERATORS

[email protected]