I’m a tech interested guy. I’ve touched SQL once or twice, but wasn’t able to really make sense of it. That combined with not having a practical use leaves SQL as largely a black box in my mind (though I am somewhat familiar with technical concepts in databasing).

With that, I keep seeing [pic related] as proof that Elon Musk doesn’t understand SQL.

Can someone give me a technical explanation for how one would come to that conclusion? I’d love if you could pass technical documentation for that.

  • DahGangalang@infosec.pubOP
    link
    fedilink
    arrow-up
    7
    ·
    7 days ago

    Just so I’m clear, you’re implying that a given SSN could appear associated to multiple “keys” because the key-value pair in a NoSQL database could have complex data.

    An example I can imagine is a widow collecting her dead husband’s Social Security. Her SSN could appear in her own entry and also in her dead husband’s as a payee of that benefit, thus appearing as a “duplicate” SSN.

    Is that in line with what you’re saying?

    • knightly the Sneptaur@pawb.social
      link
      fedilink
      arrow-up
      7
      ·
      edit-2
      7 days ago

      Indeed, that’s a possibility, but I’m not privy to the structure of the social security administration’s databases so I couldn’t say if it was indeed the case.

      The deeper point being, if the government has any databases at all, then some form of Structured Query Language is being used to read and write it.

      • DahGangalang@infosec.pubOP
        link
        fedilink
        arrow-up
        5
        ·
        7 days ago

        Thats how I feel too.

        Lol, I’d love to see the data hes trying to speak about (not that that’d be any kind of concerning for privacy /s). I don’t think he’s outright lying, but it definitely feels like a misrepresentation / wrong conclusion from the data.

        But thanks for your part in helping me understand all this!