Comment on How does this pic show that Elon Musk doesnt know SQL?

TehWorld@lemmy.world ⁨2⁩ ⁨weeks⁩ ago

• valkyre09@lemmy.world ⁨2⁩ ⁨weeks⁩ ago

  In our company I’m friends with one of the lead devs. He once told me “no matter what way you look at it, excel is never the answer” lll I’m sure he was a bit biased, but I’ve seen my fair share of macro-ridden abominations over the years

  source

  • spark947@lemm.ee ⁨2⁩ ⁨weeks⁩ ago

    Excel is accounting workbook software, it is not suitable for data storage. Although people certainly use it that way.

    source
  • TehWorld@lemmy.world ⁨2⁩ ⁨weeks⁩ ago

    It makes a pretty good calculator. 🧮

    source
  • arotrios@lemmy.world ⁨2⁩ ⁨weeks⁩ ago

    It’s an amazing tool if only one person is updating / maintaining the file. The moment collaboration starts, you’re all fucked. I’m currently maintaining one that I inherited that is at least 10 years old and comes with a 50 page instruction manual on how to run it every month… that then gets posted to a shared drive where anyone can edit.

    And then the rest of the month is spent explaining to the end users how they fucked it up this time.

    On the flip side, I’ve also built sheets that could parse data between Nav, MySQL, and SQL ERP systems with tables of over 5million rows each on a single button refresh that ran flawlessly for years… because I was the only maintainer and the sheets were locked from accepting changes from other users.

    source