471
you are viewing a single comment's thread
view the rest of the comments
[-] bitjunkie@lemmy.world 50 points 3 days ago* (last edited 3 days ago)

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

[-] EpicFailGuy@lemmy.world 30 points 3 days ago

ah! yes ... little bobby tables we call him.

[-] FauxLiving@lemmy.world 16 points 3 days ago
[-] Hupf@feddit.org 3 points 2 days ago

There are ten thousand of them after all

[-] Buckshot@programming.dev 16 points 3 days ago

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 11 points 3 days ago* (last edited 3 days 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.

this post was submitted on 24 Jul 2026
471 points (99.6% liked)

Programmer Humor

32490 readers
1265 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 3 years ago
MODERATORS