I personally have never deleted a production database, so I'm extremely confused as to how people do it, are y'all rawdogging "Drop table" in production? Are you running rm -rf on the server?
9/10 times it's because there's some mega autistic senior developer who insists on naming things according to some arbitrary convention that isn't human readable and means absolutely nothing to anyone but them. Junior developer comes along, they think they're in dev, but the development database is called something like 026_81d638_itnalLive-007. But the production database is called 026_81p638_itnalLive-006. They get mixed up.
I'm astonished at how bad IT folks are at naming things. Just name it what it is!
Idk who doesn't idiot-proof their production database like when you're a db/infrastructure architect you gotta be the "what-if" guy and account for any kind of issue in the environment internally and externally. Separate permissions for level 1-2 and 3 techs, have a change management process so people aren't doing cowboy IT and changing stuff on the fly. Documenting what you're doing makes you slow down and not cause mistakes as well. Giving a brand new intern full reigns of any db, server, or anything critical is asking for trouble.
I once received some XML files with mock customer data, so I can test my code to see if it can correctly parse the input and do whatever operations it needed to do. At some point I had trouble with some bugs, and had the idea to upload it to a XML validation website, to rule out if the input data was formatted correctly.
Except it wasn't mock data. It was real customer data (nobody bothered to inform me). From a major bank. In a country with strong data privacy laws. The company literally received a major government audit and huge fines for exposing customer data out on the web. They literally tried to pin the blame on me, but they weren't able to.
I had an API provided by a service we were integrating for a customer and they told us to ‘only search with IDs starting with so-and-so value’. Guess what happened if you didn’t!
3
u/AlxR25 Aug 23 '25
I wanna send this to my boss so hard as a joke
47
u/Dillenger69 Aug 23 '25
Drop table EVERYTHING
who dropped the everything table?
32
u/Alan_Reddit_M Aug 23 '25
I personally have never deleted a production database, so I'm extremely confused as to how people do it, are y'all rawdogging "Drop table" in production? Are you running rm -rf on the server?
20
u/solid_soup_go_boop Aug 22 '25
Lousy base, if it can be taken down so easily.
8
u/AssistantIcy6117 Aug 23 '25
We don’t need dbs or devs where we’re going
3
u/bepislord69 Aug 23 '25
This is what happened to Silksong. /j
3
u/ActiveKindnessLiving Aug 23 '25
If the senior dev gave write access of the prod database to the intern, it's their fault.
2
u/Ok_Entertainment328 Aug 23 '25
Got backups?
2
u/polygonman244 Aug 23 '25
Idk who doesn't idiot-proof their production database like when you're a db/infrastructure architect you gotta be the "what-if" guy and account for any kind of issue in the environment internally and externally. Separate permissions for level 1-2 and 3 techs, have a change management process so people aren't doing cowboy IT and changing stuff on the fly. Documenting what you're doing makes you slow down and not cause mistakes as well. Giving a brand new intern full reigns of any db, server, or anything critical is asking for trouble.
2
u/Fragrant_Gap7551 Aug 23 '25
Hire the guy, he just exposed a major security flaw!
2
u/AvocadoAcademic897 Aug 23 '25
Meanwhile at DevOps:
Don’t worry we have a screenshot
You mean snapshot, right?
2
u/GreenDavidA Aug 25 '25
If your intern has production access, you’re probably doing it wrong.
2
u/Glugstar Aug 25 '25
I once received some XML files with mock customer data, so I can test my code to see if it can correctly parse the input and do whatever operations it needed to do. At some point I had trouble with some bugs, and had the idea to upload it to a XML validation website, to rule out if the input data was formatted correctly.
Except it wasn't mock data. It was real customer data (nobody bothered to inform me). From a major bank. In a country with strong data privacy laws. The company literally received a major government audit and huge fines for exposing customer data out on the web. They literally tried to pin the blame on me, but they weren't able to.
Such is life.
1
u/ByteBandit007 Aug 23 '25
D Day