• zalgotext@sh.itjust.works
    link
    fedilink
    arrow-up
    20
    arrow-down
    1
    ·
    58 minutes ago

    my hard drive overheated

    So, this means they either have a local copy on disk of whatever database they’re querying, or they’re dumping a remote db to disk at some point before/during/after their query, right?

    Either way, I have just one question - why?

      • Dave.@aussie.zone
        link
        fedilink
        arrow-up
        1
        ·
        5 minutes ago

        You’ve got it all wrong, in traditional computer terminology the “hard drive” is the box that sits under the desk that collects cat fluff and cigarette tar.

        /s …?

      • spooky2092@lemmy.blahaj.zone
        link
        fedilink
        English
        arrow-up
        1
        ·
        6 minutes ago

        Plus, 60k is nothing. One of our customers had a database that was over 3M records before it got some maintenance. No issue with overheating lol

    • _stranger_@lemmy.world
      link
      fedilink
      arrow-up
      8
      ·
      edit-2
      51 minutes ago

      They make nothing. They’re compensated for destroying things, and considering it’s musk, they’re likely given relatively little money in return for their time.

      Even if the only thing you do all day is sit on the toilet and yell at the Internet, you’re already a bigger net positive on society.

  • madeinthebackseat@lemmy.world
    link
    fedilink
    arrow-up
    8
    ·
    55 minutes ago

    As a reasonably experienced “data guy,” this seems obviously laughable, but the discussion on X is scary. This guy is a savior in the MAGA world.

    We can criticize and poke fun all day, but it doesn’t matter much if our message isn’t challenging the mindset of those with other opinions.

    How do we make better use of our time to impact outside opinion?

  • vga@sopuli.xyz
    link
    fedilink
    arrow-up
    3
    ·
    43 minutes ago

    I’ve used local hard drives from like 1992 and I have never ever gotten them to overheat.

  • Psaldorn@lemmy.world
    link
    fedilink
    arrow-up
    85
    ·
    3 hours ago

    From the same group that doesn’t understand joins and thinks nobody uses SQL this is hardly surprising .

    Probably got an LLM running locally and asking it to get data which is then running 10 level deep sub queries to achieve what 2 inner joins would in a fraction of the time.

    • _stranger_@lemmy.world
      link
      fedilink
      arrow-up
      10
      ·
      edit-2
      47 minutes ago

      You’re giving this person a lot of credit. It’s probably all in the same table and this idiot is probably doing something like a for-loop over an integer range (the length of the table) where it pulls the entire table down every iteration of the loop, dumps it to a local file, and then uses plain text search or some really bad regex’s to find the data they’re looking for.

      • morbidcactus@lemmy.ca
        link
        fedilink
        arrow-up
        3
        ·
        15 minutes ago

        Considering that is nearly exactly some of the answers I’ve received during the technical part of interviews for jr data eng, you’re probably not far off.

        Shit I’ve seen solutions done up that look like that, fighting the optimiser every step (amongst other things)

  • Tiefling IRL@lemmy.blahaj.zone
    link
    fedilink
    arrow-up
    93
    ·
    3 hours ago

    60k isn’t that much, I frequently run scripts against multiple hundreds of thousands at work. Wtf is he doing? Did he duplicate the government database onto his 2015 MacBook Air?

    • 4am@lemm.ee
      link
      fedilink
      arrow-up
      45
      ·
      3 hours ago

      A TI-86 can query 60k rows without breaking a sweat.

      If his hard drive overheated from that, he is doing something very wrong, very unhygienic, or both.

    • arotrios@lemmy.world
      link
      fedilink
      English
      arrow-up
      2
      ·
      58 minutes ago

      Seriously - I can parse multiple tables of 5+ million row each… in EXCEL… on a 10 year old desktop and not have the fan even speed up. Even the legacy Access database I work with handles multiple million+ row tables better than that.

      Sounds like the kid was running his AI hamsters too hard and they died of exhaustion.

    • vga@sopuli.xyz
      link
      fedilink
      arrow-up
      1
      ·
      edit-2
      41 minutes ago

      I mean if we were to sort of steelman this thing, there sure can be database relations and queries that hit only 60k rows but are still hteavy as fuck.

    • IsoKiero@sopuli.xyz
      link
      fedilink
      English
      arrow-up
      7
      arrow-down
      1
      ·
      edit-2
      2 hours ago

      Don’t know what Elmos minions are doing, but I’ve written code at least equally unefficient. It was quite a few years ago (the code was in written in perl) and I at least want to think that I’m better now (but I’m not paid to code anymore). The task was to pull in data from a CSV (or something like that, as I mentioned, it’s been a while) and it needed conversion to XML (or something similar).

      The idea behind my code was that you could just configure which fields you want from arbitary source data and on where to place them on the whatever supported destination format. I still think that the basic idea behind that project is pretty neat, just throw in whatever you happen to have and have something completely else out of the other end. And it worked as it should. It was just stupidly hungry for memory. 20k entries would eat up several gigabytes of memory from a workstation (and back then it was premium to have even 16G around) and it was also freaking slow to run (like 0.2 - 0.5 seconds per entry).

      But even then I didn’t need to tweet that my hard drive is overheating. I well understood that my code is just bad and I even improved it a bit here and there, but it was still so very slow and used ridiculous amounts of RAM. The project was pretty neat and when you had few hundred items to process at a time it was even pretty good, there was companies who relied on that code and paid for support. It just totally broke down with even a slightly bigger datasets.

      But, as I already mentioned, my hard drive didn’t overheat on that load.

  • golden_zealot@lemmy.ml
    link
    fedilink
    English
    arrow-up
    22
    ·
    edit-2
    3 hours ago

    I used to perform data analysis of robotics firmware logs which would generate several million log lines per hour and that was my second job out of college.

    I don’t know how you fuck up 60k lines that bad. Is he nesting 150 for loops and loading a copy of the data set in each one while mining crypto??

    • ButtDrugs@lemm.ee
      link
      fedilink
      arrow-up
      6
      ·
      1 hour ago

      Substring searches in unindexed large string columns or cartesian explosion caused by shitty joins would be my initial guess.

  • kryptonianCodeMonkey@lemmy.world
    link
    fedilink
    arrow-up
    57
    ·
    edit-2
    3 hours ago

    This shit sounds like when you’re mom tells you that the Facebook printed out her bank statement on the tax machine. I’m not smart enough to even guess how you did something dumb enough to make that happen.

    How bad are you at writing queries? How does your hard drive overheat even under 100% load? Do you have it smothered under a blanket? Did you crack it up and expose it to cheeto dust? What does running a query on your, presumably, remote database even have to do with your harddrive in the first place? Are you trying to copy the entire database locally to a laptop? Do you know how to tie your shoes yet, or are you still on the velcro?

    • 4am@lemm.ee
      link
      fedilink
      arrow-up
      30
      ·
      3 hours ago

      Well thanks for trying to keep us from catching it I guess

  • MTK@lemmy.world
    link
    fedilink
    arrow-up
    6
    ·
    3 hours ago

    Technically they could have had been using a computer without any temperature sensors or fans and each row was actually a 1GB file.

    And also they had a hairdryer pointed the the drive.

    It’s possible!

  • Onno (VK6FLAB)@lemmy.radio
    link
    fedilink
    arrow-up
    236
    ·
    6 hours ago

    Wow.

    I’ve been processing a couple of billion rows of data on my machine, the fans didn’t even come on. WTF are they teaching “experts” these days, or has Elmo only hired people who claim that they can “wrangle data” and say “yes” ?

    • MajorHavoc@programming.dev
      link
      fedilink
      arrow-up
      31
      ·
      4 hours ago

      has Elmo only hired people who claim that they can “wrangle data” and say “yes” ?

      There’s two issues going on:

      1. Elmo’s sociopathic approach to laying people off is public knowledge, and top experts have the luxury of not even applying for his jobs.
      2. Elmo’s ability to judge engineering talent has likely been wildly exaggerated thanks to how he has successfully bought organizations full of talented people, in the past.
    • bleistift2@sopuli.xyz
      link
      fedilink
      English
      arrow-up
      135
      ·
      6 hours ago

      Even if querying data was processing-heavy and even if somehow the ‘hard drive’ got warm during this, then there still would need to be a hardware defect in order for the drive to overheat.

      • TwanHE@lemmy.world
        link
        fedilink
        arrow-up
        1
        ·
        2 hours ago

        If it was an nvme ssd i could almost believe it. Some come with totally underspecced heatsinks

      • IrateAnteater@sh.itjust.works
        link
        fedilink
        arrow-up
        50
        ·
        6 hours ago

        Yes, but this may be a symptom of an issue I’ve been seeing with younger programmers; they’ve siloed themselves so specifically into whatever programming they “specialize” in, that they become absolutely useless at dealing with absolutely anything else related to their job. And exasperating this issue is the fact that they’ve grown up with systems that “just work”. Windows, iOS, and android are all at the point where fucking around with hardware issues is very uncommon for the average person.

        Asking this guy to solve a hardware problem is like asking hime to tune a carburetor. He likely has not the slightest clue how to start.

        • Snot Flickerman@lemmy.blahaj.zone
          link
          fedilink
          English
          arrow-up
          29
          ·
          edit-2
          5 hours ago

          In my experience, a lot of software dev degree paths basically don’t even have relevant classes on hardware at all. Classes on hardware are all in IT Helpdesk and Network Admin degree paths whereas the software dev students are dumped straight into Visual Studio right off the bat with no relevant understanding of the underlying hardware or OS.

          • atomicbocks@sh.itjust.works
            link
            fedilink
            English
            arrow-up
            23
            ·
            4 hours ago

            My experience does not reflect yours. Computer Architecture, Discrete Math (logic gate math), and Operating System Concepts were all required classes in my CS degree from just a few years ago.

          • kryptonianCodeMonkey@lemmy.world
            link
            fedilink
            arrow-up
            7
            ·
            edit-2
            3 hours ago

            My CS degree had a hardware/IT support class, but A) it was entirely simulation based. We never touched any actual hardware. We “built” PC’s or identified physical issues in 3d sim software, set up RAID arrays in software, etc. B) it was super hand holdy and you only ever go over a problem once, so nothing on the class has stuck. I know much more from having built, troubleshot and maintained my own computers and network than I ever learned from that class, then learned more by doing in an actual IT support position before becoming an engineer.

          • bleistift2@sopuli.xyz
            link
            fedilink
            English
            arrow-up
            3
            arrow-down
            18
            ·
            5 hours ago

            You don’t teach a farmer how an internal combustion engine works. Computers are tools to software engineers. What they need to know is how to operate them, not how to maintain them.

            • KnitWit@lemmy.world
              link
              fedilink
              arrow-up
              25
              ·
              4 hours ago

              I’m not sure how well that analogy holds up. Farmers are usually pretty well versed in mechanical systems. To the point that now that John Deere has been screwing them over on right to repair that some farmers are even becoming versed in computer programming so they can flash the firmware on their tractors.

                • KnitWit@lemmy.world
                  link
                  fedilink
                  arrow-up
                  4
                  ·
                  4 hours ago

                  No, but if a farmer’s tractor is overheating (as in the gard drive conparison), I’m sure they could diagnose it.

              • bleistift2@sopuli.xyz
                link
                fedilink
                English
                arrow-up
                2
                arrow-down
                3
                ·
                4 hours ago

                I never said that it was impossible for a farmer to learn things outside their immediate field. Just like computer programmers often have knowledge of hardware and the general technology stack.

                My point, to make it explicit to a few of the illiterates who’ve replied to my comment so far, is that it is not necessary to teach a web developer how a goddamn CPU works. They can gain nothing from that knowledge because there are at least 3 levels of abstraction between JavaScript and assembly.

                • KnitWit@lemmy.world
                  link
                  fedilink
                  arrow-up
                  7
                  ·
                  edit-2
                  4 hours ago

                  And my point is that the example you used does not make the point you are trying to make, but rather the opposite. I get what you’re saying, it just doesn’t apply to farmers and mechanics.

                • bane_killgrind@slrpnk.net
                  link
                  fedilink
                  English
                  arrow-up
                  6
                  ·
                  4 hours ago

                  Operating your tools and being able to maintain and repair your tools are the unequivocally essential skills for everyone in every single industry.

                  If you can’t, you are not a professional.

                  The concepts of machine logic, registers/lookups/etc are essential for every programmer. If you don’t have a clear idea about how the simplest CPU functions, you don’t have any basis of understanding the abstractions in front of you, scripting in JS. Not a professional.

            • kryptonianCodeMonkey@lemmy.world
              link
              fedilink
              arrow-up
              6
              ·
              3 hours ago

              Horseshit. Computers aren’t tools for a software engineer. Computers are tools to an administrator, an accountant. Computers are the sandbox you are building castles in as a software engineer. If you don’t understand the system upon which you build, its abilities and features, its limitations, it’s dependencies, you are going to make some stupid mistakes.

              You need to understand discrete mathematics as a consequence of computer computation. You need to understand parallel processing and threading for muli-core processors. You need to understand networking, package management, security vulnerabilities, etc. from different architectures and protocols. And it ALWAYS helps to understand the very basics of a computer’s functioning, from hardware, CPU architecture, machine code, assembly/low level programming, memory management, etc.

              print('Hello, World!) is day one shit for a reason. Programming language and logic is the basics. The real expertise comes from your 3rd and 4th year materials. Databases, architecture, theory of computation, discrete mathematics, networking, operating systems, compilers, etc.

            • hayalci@fstab.sh
              link
              fedilink
              English
              arrow-up
              13
              ·
              5 hours ago

              No, not really. Programming requires understanding of the underlying hardware, at least to a certain extent. Otherwise performance issues will look like dark magic and optimizing anything would be impossible.

              Where do you start debugging if something goes wrong with the software and your information level is this low/ do you look at network stats? CPU utilization, paging/swapping? Is the hard disk bandwidth the bottleneck? Without at least some passable understanding of a computer architecture people like this just throw up their hands, or throw whatever tricks they know at the wall and see what sticks.

            • bane_killgrind@slrpnk.net
              link
              fedilink
              English
              arrow-up
              5
              ·
              4 hours ago

              What the fuck

              How is he going to fix his tractor? Wait days for John Deere to send somebody? Let the crop rot on the vine?

            • chickenf622@sh.itjust.works
              link
              fedilink
              arrow-up
              7
              ·
              4 hours ago

              A lot of farmers are learning how they work cause the companies that sell them the equipment keep fucking them over. I would argue that farmers nowadays needs to know how that works along with basic programming to get past the anti-consumer bullshit companies put in to make it nigh impossible to fix things yourself.

            • sepi@piefed.social
              link
              fedilink
              English
              arrow-up
              4
              ·
              4 hours ago

              CS departments were doing poorly, but now they’re putting out farmers? No wonder all these new graduates can’t find a job.

        • bleistift2@sopuli.xyz
          link
          fedilink
          English
          arrow-up
          12
          arrow-down
          8
          ·
          6 hours ago

          That’s the price of specialization. Don’t ask a software engineer to troubleshoot hardware. Don’t ask a backend dev to write a frontend. Don’t ask a proctologist to look at your cough.

          You simply cannot be proficient at every sub-sub-specialty. That’s why we collaborate and hand the ‘my computer gets hot’ problems to the hardware people. The alternative would be only moderately useful generalist.

          • IrateAnteater@sh.itjust.works
            link
            fedilink
            arrow-up
            19
            arrow-down
            1
            ·
            5 hours ago

            I’m not asking everyone to be able to become a hardware specialist, but if you can’t even figure out “my computer gets hot” I’m not going to be able to trust anything you do. Identifying a heat issue does not take a rocket surgeon.

      • Kane@femboys.biz
        link
        fedilink
        arrow-up
        57
        arrow-down
        3
        ·
        6 hours ago

        Hey! Thats offensive to 19-25 year olds, there are many who just finished college/university and are more than aware.

        They’re just role playing like in movies, with no idea of the consequences.

        • entropicdrift@lemmy.sdf.org
          link
          fedilink
          arrow-up
          25
          arrow-down
          7
          ·
          edit-2
          6 hours ago

          How on earth is it offensive to say they’re “not experts”? They’re not prodigies with PhDs. These specific young men are just technical enough and ideologically aligned.

          • Kane@femboys.biz
            link
            fedilink
            arrow-up
            19
            arrow-down
            1
            ·
            6 hours ago

            Except they’re not, as you will know their tweet would be false after your first year of any technical (IT oriented) education.

            • Zorsith@lemmy.blahaj.zone
              link
              fedilink
              English
              arrow-up
              11
              ·
              edit-2
              6 hours ago

              First year? That shit is like A+ cert level knowledge or below, and A+ is damn near worthless. They would know that in the first few hours of a study guide

              • Kane@femboys.biz
                link
                fedilink
                arrow-up
                2
                ·
                6 hours ago

                I was being generous when you consider the people in school who somehow pass, even when they don’t know a thing 🥲

              • Kane@femboys.biz
                link
                fedilink
                arrow-up
                6
                ·
                6 hours ago

                Apologies, if I came over as hostile. I did not get your meaning through text.

              • grue@lemmy.world
                link
                fedilink
                arrow-up
                7
                arrow-down
                2
                ·
                6 hours ago

                Even then, no. These were all obviously nepotism hires who would not have otherwise qualified.

                • entropicdrift@lemmy.sdf.org
                  link
                  fedilink
                  arrow-up
                  6
                  arrow-down
                  1
                  ·
                  6 hours ago

                  Meh, some of them won some hackathons and scholarships, it’s pretty clear they’re otherwise at least somewhat bright but they don’t have any relevant domain knowledge.

                  In other words, the type of person most likely to be prone to hubris and catastrophic failures.

          • Windex007@lemmy.world
            link
            fedilink
            arrow-up
            4
            arrow-down
            2
            ·
            6 hours ago

            Your original comment was ambiguous as to if being an “expert” and “being 19-25” are mutually exclusive.

      • Jo Miran@lemmy.ml
        link
        fedilink
        arrow-up
        20
        ·
        6 hours ago

        There is nothing wrong with being 19-25. There’s something wrong with being wholly incompetent.

        • ploot@lemmy.blahaj.zone
          link
          fedilink
          English
          arrow-up
          10
          ·
          5 hours ago

          There’s not really anything wrong with being incompetent, so long as you have the humility to admit it and learn from people who know better, and try not to cause harm. That’s not Musk’s minions though.

          • Jo Miran@lemmy.ml
            link
            fedilink
            arrow-up
            7
            ·
            5 hours ago

            I think it’s important to differentiate incompetence from ignorance. Ignorance is not knowing. Incompetence is not being able to fulfill the requirements for your assigned task. If you cannot fulfill the requirements for your given task, then you should not be given said task.

      • snooggums@lemmy.world
        link
        fedilink
        English
        arrow-up
        13
        ·
        6 hours ago

        Bunch of 1337 hax0rs script kiddies who don’t understand anything but they suck elon’s balls or something idk.

    • rtxn@lemmy.world
      link
      fedilink
      arrow-up
      25
      ·
      6 hours ago

      I’ve read a story on the forbidden website where a “database” was a single table with a single column holding a single row that contained the actual data as a CSV blob. I’m willing to bet the muskies are not beyond such acts of genius.

    • Jax@sh.itjust.works
      link
      fedilink
      arrow-up
      11
      ·
      6 hours ago

      You have to understand that the average Trump voter probably knows everything they know about computers from watching the ‘wacky-zaney hacker with personality issues/quirks’ “hack” into things by tippity tapping their fingies on a keyboard in your average copaganda performance.

      This is something those types of people will believe.

      • Sanctus@lemmy.world
        link
        fedilink
        English
        arrow-up
        1
        ·
        1 hour ago

        You’re on the mark. I’m like Help Desk Level 2, I wouldnt even consider myself an actual wizard. The average person in my office thinks I’m Gandalf. Its scary how much these people dont know. And each one of them is out there on the internet.