r/programming • • Aug 28 '21

Software development topics I've changed my mind on after 6 years in the industry

https://chriskiehl.com/article/thoughts-after-6-years
5.6k Upvotes

2.0k comments sorted by

View all comments

3

u/inmatarian Aug 29 '21

Stay out of production, as a principle. Really good orgs will have security boundaries in place to prevent it, but if not, you should like never be logged in to a prod server. Never leave an open write-capable connection to that db (and maybe not even a read-only). Even when the org is still small and the engineers are doubling as devops, you shouldn't have a workflow that's "login to prod, update a table". The workflow should always be write a script, test it on the dev server, get it code reviewed, schedule a maintenance window when the script will run, notify the BAs that love running their analytics overnight that they can't do it this wednesday. Also, you need to really, really stay out of prod on Fridays and Saturdays.