Post #4067251
2026-07-24 16:16 UTC
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 😁
Replies (1)
-
@bitjunkie@lemmy.world 2026-07-24 16:42
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 when I’m sure I need to make a change.