• @Blackmist
    link
    English
    207 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.

    • @finestnothing@lemmy.world
      link
      fedilink
      9
      edit-2
      7 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

    • @Ultraviolet@lemmy.world
      link
      fedilink
      English
      37 months ago

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