• @pixxelkick@lemmy.world
      27•2 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
        28•2 months ago

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

        • @yopp@infosec.pubEnglish
          2•2 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

        • @pixxelkick@lemmy.world
          1•2 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
          10•2 months ago

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

      • @Maggoty@lemmy.world
        4•2 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
          2•2 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
            2•2 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.

      • @9point6@lemmy.world
        31•2 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
          4•2 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.

    • @Zink@programming.dev
      9•2 months ago

      Now now, he also has LeAdErShIp skills like taking his incorrect understandings and making the ToUgH dEcIsIoNs and being DeCiSiVe and taking RiSkS that will in no way impact his lifestyle but could destroy the careers and lives of thousands to millions of other people.

  • katy ✨
    154•2 months ago

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

    • @quirzle@lemmy.zipEnglish
      39•2 months ago

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

      • @doleo@lemmy.oneEnglish
        13•2 months 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…

  • @Tetragrade@leminal.spaceEnglish
    43•2 months ago

    Sounds like he got confused looking at a view of a join.

    SELECT holder_name, amount
FROM account JOIN transaction ON transaction.account_id=account.id;

-- WTF!! THERE'S DUPLICATES!!!
  • @9point6@lemmy.world
    23•2 months ago

    Seemingly every interaction this man has with a normal person is him finding newer and more interesting ways of declaring himself an absolute moron.

    How the fuck is he the de facto president of the USA?

    • Optional
      2•2 months ago

      A lot of people decided not to vote this time. A lot of other people belived stupid shit their lighted rectangle told them.

  • @Rubanski@lemm.ee
    12•2 months ago

    Ok genuine question, what is the difference between a SQL database and a simple Excel spreadsheet?

  • @SilentKettle@lemmy.wtf
    43•2 months ago

    Musk seems to think Musk is a tech genius, but really he was just born into money and used it to buy a bunch of companies. In fairness he was able to recognise which companies to buy, doesn’t mean he knows anything about databases though.

  • @Randelung@lemmy.world
    28•2 months ago

    Of course. Everyone who’s ever used a DB knows it’s BS. As long as the data is structured - which it a) is because he was able to make assertions about it and b) fucking Excel files are enough - it CAN be imported and SQL’d on. Even Excel has built in support for fuck’s sake, not to mention Python and PowerQuery.

    The dude is a self-certified moron - he probably struggles with the concept of PKI, too.

  • tisktiskEnglish
    4•2 months ago

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