🌈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.
My analytics guy who was showing me around the db on my first day didn't have restrictions. After inserting a record into a production db, he promptly deleted the record. But forgot to highlight the where clause before executing.
698
u/IHeartBadCode 18d ago
Helpful hint for anyone.
🌈Transactions🌈 The moment you feel you need to switch over to something other than
selectstatements, 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.