• ilinamorato@lemmy.world
      link
      fedilink
      arrow-up
      8
      ·
      edit-2
      3 months ago

      Relational database. He’s got children, which joins to naughty and nice on childid and both record their status each year so that he can monitor trends.

  • taiyang@lemmy.world
    link
    fedilink
    arrow-up
    64
    ·
    3 months ago

    It’s a lot of individual tables because Santa’s excel struggles with anything past a few hundred thousand rows. It’s not just names, but addresses, lists of desires, and so on.

    There are around 2 billion children. If you wonder why he skips so many children, it’s not religion or poverty, it’s because Santa’s files got corrupted.

    • rtxn@lemmy.world
      link
      fedilink
      arrow-up
      34
      ·
      3 months ago

      15000 rows. 120 columns. One sheet. Creation date: 2011. A dedicated computer. Working at a multinational company is bad for mental health.

      • towerful@programming.dev
        link
        fedilink
        arrow-up
        16
        ·
        3 months ago

        And then OneDrive comes along, someone accidentally saved “to the cloud” (IE the default windows location of OneDrive). And of course someone (you) has to fix all the desync bullshit.
        Fuck excel, fuck Microsoft, fuck OneDrive!

        Thank god my company is transitioning to a decent no code solution (nocobase plus literally anything that can interact with postgres - currently n8n but not yet limited to that. It’s a transition from excel, literally anything is better! (Tho, nocobase is awesome, non has it’s perks)).
        Many parentheses, soz.
        Fuck excel, use a database!

    • jjjalljs@ttrpg.network
      link
      fedilink
      arrow-up
      9
      ·
      3 months ago

      I’ve seen at a very large company a workflow that involved manually updating an excel workbook and (I think) saving it on confluence, so a python script could download it and parse it later. It wasn’t even doing formulas. It was just like less than a hundred lines of text in a half dozen sheets.

  • vrek@programming.dev
    link
    fedilink
    English
    arrow-up
    7
    ·
    3 months ago

    Last year during the Christmas shutdown at work I actually made a crud application to track naughty vs nice children for santa, yes it was sql based(entity framework) with >90%test coverage (tests based off a in memory database) and with a winforms ui(what I had to use at work).

    I might revisit and refactor it this year come to think of it.

  • SnarkoPolo@lemmy.world
    link
    fedilink
    arrow-up
    7
    ·
    3 months ago

    After I retire, the college website will be switched from Drupal, which uses MySQL in a civilized fashion, to Modern Campus, which uses Excel. I don’t envy the person who will take over from me.

    • rooster_butt@lemmy.world
      link
      fedilink
      arrow-up
      1
      ·
      3 months ago

      The joke in the screnshot itself isn’t. just the title of the post uses the name Timmy Tables, but at that point it’s just a reference.