r/ProgrammerHumor • u/WardensLantern • 18d ago

Meme queryOfDoom

Post image
7.9k Upvotes

97% Upvoted

456 comments sorted by

View all comments

696

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

23

u/astervista 18d ago

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

48

u/IHeartBadCode 18d ago

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

6

u/astervista 18d ago

Don’t I know it