you are viewing a single comment's thread
view the rest of the comments
[โ€“] 47 points 3 months ago* (4 children)

This entire thread is giving me flashbacks to my junior dev days and forgetting a where clause when updating/deleting database records

  • source
  • hideshow 4 child 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