• @rational_lib@lemmy.world
    link
    fedilink
    372 months ago

    He did the exact same thing after taking over Twitter, talking about “poorly batched RPCs” in the timeline which makes zero sense because that’s obviously not how HTTP works.

    The sad thing is Elon regularly shows how much of a very judgmental, “I’m so smart” idiot* he is, but somehow I keep meeting people who think he’s a genius. I guess the assumption that money=smart still holds true in the US, despite being disproven time and time again.

    *Do we not have a single word for this concept? I come across this kind of person so frequently there really should be one.

  • @dragonlobster@programming.dev
    link
    fedilink
    662 months ago

    It’s hard to figure out what he’s talking about , when he says the “whole social security database”. Like in which tables are they duplicated? Does it mean the entire row is duplicated or just the SSN, it might make sense to be duplicated depending on the schema. Is it an append only db, so there might be updated columns on the same ssn and you need to filter by the latest update timestamp? Who knows.

    But also, saying that there’s a “social security database” and then following that up by the govt “doesn’t use SQL” so… the db is actually just a spreadsheet? A .txt file? The SSNs are just written down in someone’s notebook? Lol

  • Destide
    link
    fedilink
    English
    152 months ago

    You guys are idiots, they use dbeaver and pgadmin not sql… Or maybe its Acess yes they use Acess

      • @9point6@lemmy.world
        link
        fedilink
        312 months ago

        Elon probably thinks

        Not really sure he does, I think he’s clearly paying others to do that for him

        • @suy@programming.devOP
          link
          fedilink
          42 months ago

          My bad, I forgot he doesn’t have time to think.

          Too busy being one of the best players at Path of Exile 2. Despite that he doesn’t identify the valuable loot. Or how to use the map. Or how levels work. But he’s top 50! All very believable.

    • @pixxelkick@lemmy.world
      link
      fedilink
      272 months ago

      They probably do use lots of NoSQL DBs too, which perform better for non relational “data lake” style architectures where you just wanna dump mountains of data as fast as possible into storage, to be perused later.

      When you have cases where you have very very high volume of data in, but very low need to query it (but some potential need, just very low), nosql DBs excel

      Stuff like census data where you just gotta legally store it for historical reasons, and very rarely some person will wanna query it for a study or something.

      Keep in mind when I talk about low need to query, the opposite high need us on the scale of like, "this db gets queried multiple times per minute’

      Stuff like… logins to a website, data that gets queried many times per minute or even second, then sometimes nosql DBs fall off.

      Depends what is queried.

      Super basic “lookup by ID” Stuff that operates as just a big ole KeyValuePair mapping ID -> Value? And thats all you gotta query?

      NoSql is still the right tool for the job.

      The moment any kind of JOIN enters the discussion though, chances are you actually wanna use sql now

      • @Thorry84@feddit.nl
        link
        fedilink
        282 months ago

        So you’re saying Relational DataBase Management Systems do really well as soon as Relations are involved?

        • @pixxelkick@lemmy.world
          link
          fedilink
          12 months ago

          Eyup, it’s intuitive overall but there’s just weirdly some people out there that are all or nothing, and don’t understand “right tool for the job” lol

        • Morphit
          link
          fedilink
          102 months ago

          And Structured Query Language is a handy language for querying structured data?

        • @yopp@infosec.pub
          link
          fedilink
          English
          22 months ago

          What’s funny is that Relational Databases in fact sucks when somewhat complex Relations are involved. Moment you step out the of the realm of Tabular data you’ll have very miserable time. Like good luck modeling and querying simple nested product catalog.

          Graph databases are better choice for truly relational data

      • @Maggoty@lemmy.world
        link
        fedilink
        42 months ago

        Just so you know census data is very heavily queried. Everything from civil engineering to economics wants to look at that dataset every day.

        • @pixxelkick@lemmy.world
          link
          fedilink
          22 months ago

          Like I said, in the scale compared to actual high frequency data though, that’s still be infrequent.

          High frequency DBs are on the scale of many queried per second

          Even with tonnes of data scientists and engineers querying the data, that’s still in the scale of queries per minute, which is low frequency in the data world.

          • @Maggoty@lemmy.world
            link
            fedilink
            22 months ago

            I wouldn’t put it past them to experience numbers in the per second realm, especially as new data posts and everyone is rushing to grab it.

  • @bdonvr@thelemmy.club
    link
    fedilink
    95
    edit-2
    2 months ago

    Everything uses SQL. The world fucking runs on SQL

    (yes I know SQL isn’t something that you can “run” something on yadda yadda…)

    • Optional
      link
      fedilink
      22 months ago

      Too expensive. Just put this sticker of a lolipop on your shirt.

  • @ansiz@lemmy.world
    link
    fedilink
    English
    612 months 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.

  • @bitchkat@lemmy.world
    link
    fedilink
    English
    312 months ago

    I’d bet that the government is probably the largest user of SQL. Unless there are really old systems that predate SQL. I’d imagine they have shitloads of COBOL for example.

  • @bitchkat@lemmy.world
    link
    fedilink
    English
    212 months ago

    This sounds just like a former manager that thought nosql was the end all and that SQL had no place.

    If course they developed their app that required frequent data migrations because they were in fact very dependent on all the records matching the latest schema.