• Buckshot@programming.dev
    link
    fedilink
    arrow-up
    16
    ·
    před 14 dny

    We’ve all done that at some point.

    That sinking feeling when your quick update doesn’t return immediately.

    Good to get into the habit of wrapping your queries in a begin transaction/rollback until you verify the result 😁

    • bitjunkie@lemmy.world
      link
      fedilink
      arrow-up
      11
      ·
      před 14 dny

      I was never able to fully form the habit with transactions. The guardrails I use are writing the where clause first and keeping my query tool in read-only mode for prod connections and only disabling it once I’m sure I need to make a change.