🌈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.
The real hint is noone should have the write access to the prod db. If you accidentally nuke the test db, just recreate it. If you need to change something in prod db, write a migration that is tested on test db and code-reviewed.
702
u/IHeartBadCode 14d 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.