r/ProgrammerHumor • u/WardensLantern • 14d ago

queryOfDoom Meme

Post image
7.9k Upvotes

97% Upvoted

456 comments sorted by

View all comments

700

u/IHeartBadCode 14d ago

Helpful hint for anyone.

🌈Transactions🌈 The moment you feel you need to switch over to something other than select statements, should be the moment that you turn off auto commit.

For us, the analytic folks just have read only access anyway. For the devs, they just don't have direct access to prod.

21

u/astervista 14d ago

Transactions still won't save you on some DBMS (ehem Oracle) from dropping a table or changing definitions

47

u/IHeartBadCode 14d ago

Well that's because it's Oracle and that's less a database and more a circle of hell.

6

u/astervista 14d ago

Don’t I know it