What if you're the one that was in charge of adding safe guards?

Small companies often allow devs access to prod DBs. It doesn't change the fact that it's a catastrophically stupid decision, but you often can't do anything about it.

And of course, when they inevitably fuck up the blame will be on the IT team for not implementing necessary restrictions.

Frequent snapshots ftmfw.

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

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?

Or at least run it in the test database first.

Or run your updates/deletes as select first.

The P in Prod stands for "It'll be Pfine"

There's that old saying 'everyone has a development environment. Some people are lucky enough to have a separate production environment, too'

Endpoint? Why the fuck is a migration using an endpoint, if you want testability a script will do just fine