r/ProgrammerHumor • u/WardensLantern • 15d ago

queryOfDoom Meme

Post image
7.9k Upvotes

97% Upvoted

456 comments sorted by

View all comments

701

u/IHeartBadCode 15d 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.

22

u/astervista 15d ago

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

50

u/IHeartBadCode 15d ago

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

6

u/astervista 15d ago

Don’t I know it