• @lunaticneko@lemmy.ml
    link
    fedilink
    37
    edit-2
    1 year ago

    They let the intern access the production db. The company is one of the biggest hosting and internet service companies in the country. The db was SQL but had no primary key.

    I was the intern. I normalized it to 3NF as part of my internship project.

      • @lunaticneko@lemmy.ml
        link
        fedilink
        41 year ago

        My first internal question in my head was “how the fuck have they been living with this???” Of course the first thing I did was to inform the boss that I have to take a snapshot backup, and that working directly on prod is ill-advised.

        He said “sure kid, you know better than me.” WAIT WHAT?!

        When I came back to the university and submitted my report, my lab advisor was also like what the fuck.

        Everyone was perplexed all the way to the department chair.

        • @Myrhial
          link
          41 year ago

          When I started my career and I worked at small companies, I figured they just didn’t know any better. Now I’m further along in my career I have come to realize that really big companies (as well as government agencies) have the exact same problems except on a much larger scale.