• lunaticneko@lemmy.ml
    link
    fedilink
    arrow-up
    0
    ·
    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
        arrow-up
        1
        ·
        1 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@discuss.online
          link
          fedilink
          arrow-up
          2
          ·
          1 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.