mikyopii comments on Developer stages of grief

[–] mikyopii@programming.dev 85 points 2 years ago (4 children)

I always run my queries in a script that will automatically rollback if the number of rows changed isn't one. If I have to change multiple rows I should probably ask myself what am I doing.

permalink

fedilink

source

hideshow 4 child comments

[–] assembly@lemmy.world 84 points 2 years ago

Damn that’s a good idea. Going to write that down, put it in the to do list, and regret not dosing it.

permalink

fedilink

source

parent

[–] takeda@lemmy.world 36 points 2 years ago* (1 child)

I always start a session with disabling auto commit (note, I could add it to my settings, but then it would backfire that one time my settings don't execute, so I'm making it a habit to type it out every time, first thing I connect)

BTW: what kind of genius decides that auto commit should be enabled by default?

permalink

fedilink

source

parent

hideshow 1 child comment

[–] mikyopii@programming.dev 10 points 2 years ago

That's a good idea too. I'll have to look into that.

permalink

fedilink

source

parent

[–] SorryQuick@lemmy.ca 1 point 2 years ago*

Or at least run it in the test database first.

Or run your updates/deletes as select first.

permalink

fedilink

source

parent