you are viewing a single comment's thread
view the rest of the comments
[โ€“] 15 points 3 months ago (1 child)

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 ๐Ÿ˜

  • source
  • parent
  • hideshow 1 child comment
  • [โ€“] 10 points 3 months ago*

    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.

  • source
  • parent