• @wise_pancake@lemmy.ca
    link
    fedilink
    36
    edit-2
    17 days ago

    Maybe Musk needs to learn about data normalization and natural keys.

    I’m curious what the actual data looks like. I’ve spent quite a bit of time auditing large data systems.

    I would expect these databases to be largely denormalized with very wide tables, I would expect them to favour natural keys like a SSNs, and built around per department use cases.

    I would not expect them to be highly normalized because then when you need something from another department you need them to ensure consistency.

    These systems probably have like 50 years of legacy code or more in them too.

  • @Whirlybird@aussie.zone
    link
    fedilink
    -616 days ago

    See the post on BlueSky

    No thanks, that alone says you’re not going to get an honest unbiased discussion. Also when your evidence is “according to many comments” from a app filled with people that hate Musk with all their being as if it’s their entire identity, it’s not good evidence.

    Being a developer who has done work for many governments in my country, you cannot just say “the government DOES use SQL” because they have many, many, MANY different systems that have all been built in different technologies over different decades by different people with different design philosophies and preferences. Will there be ones that use SQL? Absolutely. Will there be ones that don’t? Absolutely.

  • @i_stole_ur_taco@lemmy.ca
    link
    fedilink
    34817 days ago

    Elon’s shock and fury about the database key sounds like he got a report from an out-of-breath 20 year old DOGE kid who thinks they’re hot shit and discovered some massive flaw.

    Elon also seems like the kind of person that believes a database schema is all that’s needed to govern a population.

  • tisktisk
    link
    fedilink
    English
    417 days ago

    He is the embodiment of big-money trolling in politics, right?

      • magic_lobster_party
        link
        fedilink
        1217 days ago

        Nah, that’s too fancy. It’s all held together by some arcane Visual Basic macro someone wrote 25 years ago right before going to retirement and no one has dared to touch it ever since.

        • justOnePersistentKbinPlease
          link
          fedilink
          117 days ago

          Qbasic, if that.

          Biden is a blue dog and never cared about infrastructure. Trump cant spell the word. Obama did, but for overpriced drones and oil. Bush only did for oil and deregulated to make things worse. Clinton cut thing Bush Sr cut things. Reagan fucked everything up with “trickle down”

          Meaning the last president that did major infrastructure spending is at best Carter, Ford or Nixon.

          • @Maggoty@lemmy.world
            link
            fedilink
            517 days ago

            I laughed but really I know when the last good database and systems people left government to be replaced by contractors. It was Bush’s first term. Since then everything has been just putting a new front end on the back end government programmers created in the 1990’s.

  • @dan1101@lemm.ee
    link
    fedilink
    39917 days ago

    That’s weird, I thought I used SQL databases from government agencies regularly. Guess I was mistaken.

    • @Susaga@sh.itjust.works
      link
      fedilink
      English
      34517 days ago

      If you and Elon disagree about something, just assume he’s wrong about it. If you both agree on something, THEN you might be mistaken.

      • @cm0002@lemmy.world
        link
        fedilink
        5117 days ago

        If it’s tech he doesn’t know shit about it, I learned that years ago during the Twitter acquisition days

        He sounds like a CEO who “knows enough to fuck shit up, not enough to know how to fix it, but thinks they do” AKA the worst executive known to IT

          • Laurel Raven
            link
            fedilink
            English
            817 days ago

            How about the submarine he was going to build to save kids in a cave that obviously would have drowned long before he could have even really started work? But it’s okay, he could just accuse the guy who actually saved their lives of being a pedo

        • Optional
          link
          fedilink
          1017 days ago

          Hey you’re looking for a new truck aren’t ya? Well do we have a deal for you!

        • @oo1@lemmings.world
          link
          fedilink
          English
          1117 days ago

          I hope the screenshot dude is also going to stop this unquestioning belief in the things people say or claim without evidence.

          Those first two paragraphs look like a tendency to prefer hero-worship to critical thought; that seems to be a fairly widespread problem in humans from long before this latest batch of demagogues.

          There’s also a hint of “I’m not an ‘expert’ in it so I can’t (be bothered) to understand anything about it” also a very depressingly common attitude.

          • @frezik@midwest.social
            link
            fedilink
            3117 days ago

            We all have to rely on somebody to be an expert in fields outside our own. Years ago, if Elon said “Falcon 9 launch yesterday failed due to xyz”, I assumed he had the actual experts giving him notes. The Xhitter debacle showed how much he doesn’t listen to those people.

            • @oo1@lemmings.world
              link
              fedilink
              English
              -317 days ago

              I just dont get why you have to assume that though?

              Maybe I’m a pessimist, but I’ve met and worked with enough humans that I think the best assumtion is that they’re all full of shit until they prove otherwise.

              It’s fine to rely on experts for some things, but if those experts aren’t subject to independent scrutiny or directly independent of the claim or sunjecy under test, or can’t give clear testable /replicable evidence, I’d just not put much weight on their testimony as a source of evidence.

            • @jballs@sh.itjust.works
              link
              fedilink
              English
              1917 days ago

              It’s kind of funny, but we all do this to some extent. I used to think most people on Reddit were super smart. If someone says stuff with authority, then it’s easy to believe what they’re saying and assume they know what they’re talking about.

              But then every once in a while, I’d come across a topic that I know deeply about - and the comment would just be blatantly wrong, but still have tons of up votes. It really made me start second guessing all the other comments I had read and thought were smart, but it’s an easy trap to fall into.

              I guess what I’m really saying, is that you all are a bunch of morons, probably.

  • @ansiz@lemmy.world
    link
    fedilink
    English
    6116 days ago

    If SSN based fraud is the program then let’s establish an actual federal identification number. Even the Social Services bureau tried to get everyone to not use it as the end all source of truth. They only created it for social security benefits, literally only that purpose.

  • katy ✨
    link
    fedilink
    15317 days ago

    Elon is basically what a dumb kid thinks smart people sound like

    • @quirzle@lemmy.zip
      link
      fedilink
      English
      3917 days ago

      Replace “dumb kid” with half dozen of my boomer relatives, and you’re spot-on.

      • @doleo@lemmy.one
        link
        fedilink
        English
        1316 days ago

        and the dumb kids, unfortunately. I did a spot with some non-US teenagers, in a class recently. The topic was “name a person you admire and why”. Guess whose filthy name came up…