• KillingTimeItself@lemmy.dbzer0.com
    link
    fedilink
    English
    arrow-up
    0
    ·
    edit-2
    1 month ago

    i mean…

    If you’re running a pcie nvme ssd, one of the modern ones, and you’re doing a SHIT ton of reads, like threadripper level amount of reads, i guess “overheating” isn’t unexpected? Shouldn’t do much other than slow down the SSD though?

    dumbass probably loaded them into memory, and OOM’d, and thought it was the drive.

    • lefaucet@slrpnk.net
      link
      fedilink
      arrow-up
      0
      ·
      1 month ago

      NVMEs will throttle if they are inadequately cooled. Pretty much only folks who are new at buiding computers and don’t adequately cool their NVMEs experience this.

      Either way it shows what a clown show this is. I’m pretty sure they’re doing some babuki theatre to distract us and then if the scheme being done here is found, they’ll point fingers at the dipshit kid and he’ll be punished for whatever the con is.

      Either way the billionaires will be better off for it, barring judicial, congressional, or military revolt; which is looking less likely by the day.

      Bunch of traitors forgot their oath is to the constitution. The constitution IS the soul of the country and is to be respected. The country was founded by the constitution and it defines the system to be decentralized power giving control to the populace through three different branches of government. Not some false idol king or an evil oligarchy propped up by foreign and domestic robber barrons

    • T156@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      1 month ago

      Out of memory/overheating in 60k rows? I’ve had a few multi-million row databases that could fit into a few gigs of memory, and most modern machines have that much in RAM. A 60k query that overheats the machine might only happen if you’re doing something weird with joins.

      Plus a lot of reads is nothing really, for basically all databases, unless you’re doing an unsmart thing with how you’re reading it (like scanning the whole database over and over). If you’re not processing the data, it’d be I/O bottlenecked.

      • KillingTimeItself@lemmy.dbzer0.com
        link
        fedilink
        English
        arrow-up
        0
        ·
        1 month ago

        if they wrote good code yeah, evidently they didn’t write good code if they’re struggling to process 60k lines of a database lmao.

        They must either be O(n^10) complexity or something retarded like that for this to be the case. I wouldn’t put it past them.

        Plus a lot of reads is nothing really, for basically all databases, unless you’re doing an unsmart thing with how you’re reading it (like scanning the whole database over and over). If you’re not processing the data, it’d be I/O bottlenecked.

        again, i’m assuming they aren’t very smart, since this is an issue in the first place.

  • BenLeMan@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    1 month ago

    You’re not supposed to place your laptop directly in the lap of your fur suit. Always leave an air gap for ventilation, smh.

  • nick@midwest.social
    link
    fedilink
    arrow-up
    0
    ·
    1 month ago

    60k lol.

    I regularly work with data in the 16tb range and weirdly my computer is fine. Git gud, doge scrubs.

  • zalgotext@sh.itjust.works
    link
    fedilink
    arrow-up
    0
    ·
    1 month 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?

    • Adalast@lemmy.world
      link
      fedilink
      arrow-up
      0
      ·
      1 month ago

      Why? Because they feel the need to have local copies of sensitive financial information because… You know… They are computer security experts.

    • GoodEye8@lemm.ee
      link
      fedilink
      English
      arrow-up
      0
      ·
      1 month ago

      My one question would be “How?”

      What the hell are you doing that your hard drives are overheating? How do you even know it’s overheating as I’m like 90% certain hard drives (except NVMe if we’re being liberal with the meaning of hard drive) don’t even have temperature sensors?

      The only conclusion I can come to is that everything he’s saying is just bullshit.

          • Mniot@programming.dev
            link
            fedilink
            English
            arrow-up
            0
            ·
            1 month ago

            Can we think of any device someone might have that would struggle with 60k? Certainly an ESP32 chip could handle it fine, so most IoT devices would work…

            • T156@lemmy.world
              link
              fedilink
              English
              arrow-up
              0
              ·
              1 month ago

              Unless the database was designed by someone who only knows of data as that robot from Star Trek, most would be absolutely fine with 60k rows. I wouldn’t be surprised if the machine they’re using caches that much in RAM alone.

            • zenpocalypse@lemm.ee
              link
              fedilink
              English
              arrow-up
              0
              ·
              1 month ago

              Right? There’s no part of that xeet that makes any real sense coming from a “data engineer.”

              Terrifying, really.

        • xthexder@l.sw0.com
          link
          fedilink
          arrow-up
          0
          ·
          edit-2
          1 month ago

          Imo if they can’t max out their harddrive for at least 24 hours without it breaking, their computer was already broken. They just didn’t know it yet.

          Any reasonable SSD would just throttle if it was getting too hot, and I’ve never heard of a HDD overheating on its own, only if there’s some external heat sources, like running it in a 60°C room

      • Auli@lemmy.ca
        link
        fedilink
        English
        arrow-up
        0
        ·
        1 month ago

        They have temp sensors. But have never heard of a overheating drive.

      • baldingpudenda@lemmy.world
        link
        fedilink
        arrow-up
        0
        ·
        1 month ago

        Reminds me of those 90s ads about hackers making your pc explode.

        Musk gonna roll up in a wheelchair, “the attempt on my life has left me ketamine addicted and all knowing and powerful.”

      • Dave.@aussie.zone
        link
        fedilink
        arrow-up
        0
        ·
        1 month 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
        0
        ·
        1 month 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

        • Korhaka@sopuli.xyz
          link
          fedilink
          English
          arrow-up
          0
          ·
          edit-2
          1 month ago

          Pretty sure I run updates or inserts that count over 60k fairly often. No overheats. Select queries sometimes way higher.

        • surph_ninja@lemmy.world
          link
          fedilink
          arrow-up
          0
          ·
          edit-2
          1 month ago

          I run queries throughout the day that can return 8 million+ rows easily. Granted, it takes few minutes to run, but it has never caused a single issue with overheating even on slim pc’s.

          This makes no fucking sense. 60k rows would return in a flash even on shitty hardware. And if it taxes anything, it’s gonna be the ram or cpu- not the hard drive.

          • T156@lemmy.world
            link
            fedilink
            English
            arrow-up
            0
            ·
            edit-2
            1 month ago

            In my experience, the only time that I’ve taxed a drive when doing a database query is either when dumping it, or with SQLite’s vacuum, which copies the whole thing.

            For a pretty simple search like OP seems to be doing, the indices should have taken care of basically all the heavy lifting.

        • AThing4String@sh.itjust.works
          link
          fedilink
          arrow-up
          0
          ·
          1 month ago

          I literally work with ~750,000 line exports on the daily on my little Lenovo workbook. It gets a little cranky, especially if I have a few of those big ones open, but I have yet to witness my hard drive melting down over it. I’m not doing anything special, and I have the exact same business-economy tier setup 95% of our business uses. While I’m doing this, that little champion is also driving 4 large monitors because I’m actual scum like that. Still no hardware meltdowns after 3 years, but I’ll admit the cat likes how warm it gets.

          750k lines is just for the branch specific item preferences table for one of our smaller business streams, too - FORGET what our sales record tables would look like, let alone the whole database! And when we’re talking about the entirety of the social security database, which should contain at least one line each in a table somewhere for most of the hundreds of millions of people currently living in the US, PLUS any historical records for dead people??

          Your hard drive melting after 60k lines, plus the attitude that 60k lines is a lot for a major database, speaks to GLARING IT incompetence.

      • Fuck spez@sh.itjust.works
        link
        fedilink
        English
        arrow-up
        0
        ·
        1 month ago

        I don’t think I’ve seen a brand new computer in the past decade that even had a mechanical hard drive at all unless it was purpose-built for storing multiple terabytes, and 60K rows wouldn’t even take multiple gigabytes.

    • Bosht@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      1 month ago

      I’d much sooner assume that they’re just fucking stupid and talking out of their ass tbh.

      • kautau@lemmy.world
        link
        fedilink
        arrow-up
        0
        ·
        1 month ago

        Same as Elon when he confidently told off engineers during his takeover of Twitter or gestures broadly at the Mr, Dunning Kruger himself

        Wonder if it’s an SQL DB

        Elon probably hired confident right wingers whose parents bought and paid their way through prestigious schools rather. If he hired anyone truly skilled and knowledgeable, they’d call him out on his bullshit. So the people gutting government programs and passing around private data like candy are just confidently incorrect

    • zenpocalypse@lemm.ee
      link
      fedilink
      English
      arrow-up
      0
      ·
      edit-2
      1 month ago

      Even if it was local, a raspberry pi can handle a query that size.

      Edit - honestly, it reeks of a knowledge level that calls the entire PC a “hard drive”.

      • T156@lemmy.world
        link
        fedilink
        English
        arrow-up
        0
        ·
        edit-2
        1 month ago

        Unless they actually mean the hard drive, and not the computer. I’ve definitely had a cheap enclosure overheat and drop out on me before when trying to seek the drive a bunch, although it’s more likely the enclosure’s own electronics overheating. Unless their query was rubbish, a simple database scan/search like that should be fast, and not demanding in the slightest. Doubly so if it’s dedicated, and not using some embedded thing like SQLite. A few dozen thousand queries should be basically nothing.

        • zenpocalypse@lemm.ee
          link
          fedilink
          English
          arrow-up
          0
          ·
          1 month ago

          Yeah, no matter what way you disorganize 60,000 rows, the data is still going to read into memory once.

  • MystikIncarnate@lemmy.ca
    link
    fedilink
    English
    arrow-up
    0
    ·
    1 month ago

    IT guy checking in.

    The only time I’ve even seen drive temp sensor alarms is on server raid arrays and other similar hard drives/SSDs… Never in my life have I seen one available on a consumer device, nor have I seen any alarm for and drive temp, go off. Out just doesn’t happen.

    IMO, this is one of those language barriers where people call their computer chassis (and everything in it) the “hard drive”.

    Applying that assumption, their updated statement is: His computer over heated.

    Idk what kind of shit system he’s running on that 60k rows would cause overheating, but ok.

    • theparadox@lemmy.world
      link
      fedilink
      English
      arrow-up
      0
      ·
      edit-2
      1 month ago

      As another IT guy here, it could also be a shitty method of analysis that he got from ChaptGPT. As an amateur coder/script writer, the kinds of code I’ve seen people use from these bots is disturbing. One of my coworkers asked me for help after trying to cobble together something from bots. There were variables declared and never used, variables that were never assigned values but that were used in expressions… it was like it attempted to do that ransom note made from magazine letters but they couldn’t spell coherently.

    • wise_pancake@lemmy.ca
      link
      fedilink
      arrow-up
      0
      ·
      1 month ago

      Are you telling me there’s a difference between an inner and a cross join?

      Cross join is obviously faster, I don’t even have to write “on”

  • LillyPip@lemmy.ca
    link
    fedilink
    arrow-up
    0
    ·
    1 month ago

    This cannot be real, wtf. This is cartoon levels of ineptitude.

    Or sabotage by someone heading out? Please let this be resistance sabotage they haven’t noticed yet.

  • RussianBot8453@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    1 month ago

    I’m a data engineer that processes 2 billion row 3000 column datasets every day, and I open shit in Excel with more than 60k rows. What the hell is this chick talking about?

    • zenpocalypse@lemm.ee
      link
      fedilink
      English
      arrow-up
      0
      ·
      1 month ago

      Seems like a good excuse to someone who doesn’t know what they’re doing and needs an excuse because why they haven’t completed it yet?

      The whole post is complete bs in multiple ways. So weird.

      • psivchaz@reddthat.com
        link
        fedilink
        arrow-up
        0
        ·
        1 month ago

        It sounds like Hollywood tech lingo. Like when you’re watching a movie or a TV show and the designated techy character starts just saying computer words that make no actual sense in the real world, but I guess in CSI: Idiottown the hard drives have severe overheating issues.

      • Akasazh@feddit.nl
        link
        fedilink
        arrow-up
        0
        ·
        1 month ago

        If you work for a boss that fundamentally misunderstands what you are doing, then misleading them into thinking you’re ‘hard at work, making decisions with consequences’ is the theatre you put up to keep the cash flowing.

        It’s one of the fundamental flows of autocracy, people try and represent what you want them to

    • person420@lemmynsfw.com
      link
      fedilink
      arrow-up
      0
      ·
      1 month ago

      Some interesting facts about excel I learned the hard way.

      1. It only supports about a million or so rows
      2. It completely screws up numbers if the column is a number and the number is over 15 digits long.

      Not really related to what you said, but I’m still sore about the bad data import that caused me days of work to clean up.

      • driving_crooner@lemmy.eco.br
        link
        fedilink
        arrow-up
        0
        ·
        edit-2
        1 month ago

        It completely screws up numbers if the column is a number and the number is over 15 digits long.

        I work in insurance in Brazil, by standards of our regulatory body, claims numbers must be a string of 20 numbers (zfill(20) if needed). You can’t imagine the amount of times excel had fucked me up rounding down the claim numbers, this is one of the first things I teach to my interns and juniors when they’re working with the claims databases.

      • Mniot@programming.dev
        link
        fedilink
        English
        arrow-up
        0
        ·
        1 month ago

        The row limitation seems, to me, like an actually-good thing. Excel is for data where you might conceivably scroll up and down looking at it and 1M is definitely beyond the ability of a human even to just skim looking for something different.

        An older version of Excel could only handle 64k rows and I had a client who wanted large amounts of data in Excel format. “Oh sorry, it’s a Microsoft limitation,” I was thrilled to say. “I have no choice but to give you a useful summarization of the data instead of 800k rows (each 1000 columns wide) of raw data.”

        • frezik@midwest.social
          link
          fedilink
          arrow-up
          0
          ·
          edit-2
          1 month ago

          Some time ago, I heard a story of CS and Econ professors having lunch together. The Econ professor was excited that Excel was going to release a version that blew out the 64k row limit. The CS professor nearly choked on his lunch.

          Dependence on Excel has definitely caused bad papers to be published in the Econ space, and has had real world consequences. There was a paper years ago that stated that once a country’s debt gets above 120% of GDP, its economy goes into a death spiral. It was passed around as established fact by the sorts of politicians who justify austerity. Problem was, nobody could reproduce the results. Then an Econ undergrad asked the original author for their Excel spreadsheet, and they found a coding error in the formulas. Once corrected, the conclusion disappeared.

  • Onno (VK6FLAB)@lemmy.radio
    link
    fedilink
    arrow-up
    0
    ·
    1 month 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” ?

    • Jax@sh.itjust.works
      link
      fedilink
      arrow-up
      0
      ·
      1 month 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
        0
        ·
        1 month 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.

    • rtxn@lemmy.world
      link
      fedilink
      arrow-up
      0
      ·
      1 month 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.

    • MajorHavoc@programming.dev
      link
      fedilink
      arrow-up
      0
      ·
      1 month 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.
    • wise_pancake@lemmy.ca
      link
      fedilink
      arrow-up
      0
      ·
      1 month ago

      60k rows is generally very usable with even wide tables in row formats.

      I’ve had pandas work with 1M plus rows with 100 columns in memory just fine.

      After 1M rows move on to something better like Dask, polars, spark, or literally any DB.

      The first thing I’d do with whatever data they’re running into issues with is rewrite it as partitioned and sorted parquet.

      • Onno (VK6FLAB)@lemmy.radio
        link
        fedilink
        arrow-up
        0
        ·
        1 month ago

        My go-to tool of late is duckdb, comes with binaries for most platforms, works out of the box, loads any number of database formats and is FAST.

      • snooggums@lemmy.world
        link
        fedilink
        English
        arrow-up
        0
        ·
        1 month ago

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

      • Jo Miran@lemmy.ml
        link
        fedilink
        arrow-up
        0
        ·
        1 month 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
          0
          ·
          1 month 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
            0
            ·
            1 month 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.

      • Kane@femboys.biz
        link
        fedilink
        arrow-up
        0
        ·
        1 month 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.

          • T156@lemmy.world
            link
            fedilink
            English
            arrow-up
            0
            ·
            1 month ago

            If they went into uni straight out of high school, they could. A lot of Bachelor holders would be around that age, since they start at 18.

        • entropicdrift@lemmy.sdf.org
          link
          fedilink
          arrow-up
          0
          ·
          edit-2
          1 month 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.

          • Windex007@lemmy.world
            link
            fedilink
            arrow-up
            0
            ·
            1 month ago

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

          • Kane@femboys.biz
            link
            fedilink
            arrow-up
            0
            ·
            1 month 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
              0
              ·
              edit-2
              1 month 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
                0
                ·
                1 month 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
                0
                ·
                1 month ago

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

              • grue@lemmy.world
                link
                fedilink
                arrow-up
                0
                ·
                1 month ago

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

                • entropicdrift@lemmy.sdf.org
                  link
                  fedilink
                  arrow-up
                  0
                  ·
                  1 month 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.

    • bleistift2@sopuli.xyz
      link
      fedilink
      English
      arrow-up
      0
      ·
      1 month 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.

      • IrateAnteater@sh.itjust.works
        link
        fedilink
        arrow-up
        0
        ·
        1 month 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
          0
          ·
          1 month 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 bad with no relevant understanding of the underlying hardware or OS.

          • kryptonianCodeMonkey@lemmy.world
            link
            fedilink
            arrow-up
            0
            ·
            1 month 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 issues in 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.

            • applebusch@lemmy.blahaj.zone
              link
              fedilink
              English
              arrow-up
              0
              ·
              1 month ago

              I mean to be fair the sheer amount of material most university engineering programs require these days makes spending significant time on specific problems almost impossible. They try to shove so much theory into your head they lose track of practical implementation. Basically everyone I went to school with complained about the lack of practical application relative to theory, and I studied mechanical engineering which is theoretically and literally chiefly concerned with hardware.

          • bleistift2@sopuli.xyz
            link
            fedilink
            English
            arrow-up
            0
            ·
            1 month 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.

            • hayalci@fstab.sh
              link
              fedilink
              English
              arrow-up
              0
              ·
              1 month 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.

            • chickenf622@sh.itjust.works
              link
              fedilink
              arrow-up
              0
              ·
              1 month 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.

              • KillingTimeItself@lemmy.dbzer0.com
                link
                fedilink
                English
                arrow-up
                0
                ·
                1 month ago

                doesnt matter if you know how to program, john deere is just going to put some autistic encryption and ID locking on their shit, what needs to happen is for john deere to stop fucking doing this.

                Most tractors are walking computers anyway, farmers are genuinely the most multi talented people you will ever meet in your life.

            • KnitWit@lemmy.world
              link
              fedilink
              arrow-up
              0
              ·
              1 month 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.

              • bleistift2@sopuli.xyz
                link
                fedilink
                English
                arrow-up
                0
                ·
                1 month 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
                  0
                  ·
                  edit-2
                  1 month 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.

                • KillingTimeItself@lemmy.dbzer0.com
                  link
                  fedilink
                  English
                  arrow-up
                  0
                  ·
                  edit-2
                  1 month ago

                  no but a web dev should have some knowledge basis on what the ever living fuck their AIDs code fuelled by nothing but the cheapest source of caffeine and brain damage they have even does.

                  This is the entire reason why half of the internet is just broken, stupid developers who don’t know how anything works, but know how to code, making dogshit implementations of anything and everything they can get their hands on.

                  It doesn’t matter that the learning is segmented, you should STILL be learning about computer hardware and it’s architectural choices, it’s literally the reason why programming languages work the way that they do.

                • bane_killgrind@slrpnk.net
                  link
                  fedilink
                  English
                  arrow-up
                  0
                  ·
                  1 month 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.

                • KnitWit@lemmy.world
                  link
                  fedilink
                  arrow-up
                  0
                  ·
                  1 month ago

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

            • kryptonianCodeMonkey@lemmy.world
              link
              fedilink
              arrow-up
              0
              ·
              1 month 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.

              • KillingTimeItself@lemmy.dbzer0.com
                link
                fedilink
                English
                arrow-up
                0
                ·
                1 month ago

                computers are a tool to anybody who uses them?

                If you’re using a tool, it goes without saying, you should probably have at the very least, a cursory understanding of it’s function. Lest you injure yourself gravely.

            • KillingTimeItself@lemmy.dbzer0.com
              link
              fedilink
              English
              arrow-up
              0
              ·
              1 month ago

              the only reason farmers are afloat financially is BECAUSE they can rebuild an engine if needed.

              Just look at the john deere right to repair shit. It’s literally a huge problem.

            • bane_killgrind@slrpnk.net
              link
              fedilink
              English
              arrow-up
              0
              ·
              1 month 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?

            • sepi@piefed.social
              link
              fedilink
              English
              arrow-up
              0
              ·
              1 month ago

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

              • Trainguyrom@reddthat.com
                link
                fedilink
                English
                arrow-up
                0
                ·
                1 month ago

                I mean every programmer says they intend to quit and pick up farming. Might as well give them the knowledge to be successful at their late career while they’re at it

          • atomicbocks@sh.itjust.works
            link
            fedilink
            English
            arrow-up
            0
            ·
            1 month 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.

        • bleistift2@sopuli.xyz
          link
          fedilink
          English
          arrow-up
          0
          ·
          1 month 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
            0
            ·
            1 month 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.

      • TwanHE@lemmy.world
        link
        fedilink
        arrow-up
        0
        ·
        1 month ago

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

  • darkpanda@lemmy.ca
    link
    fedilink
    arrow-up
    0
    ·
    1 month ago

    What is this, a table for ants? Because that’s the average number of ants in an ant colony and it’s nowhere near an impressive amount of rows to be doing any sort of processing on. It wouldn’t be an impressive amount of rows if your rig was an i386DX-33 running off a 5” floppy.

    • 1rre@discuss.tchncs.de
      link
      fedilink
      arrow-up
      0
      ·
      1 month ago

      Exactly, 60k rows is negligible enough in most cases that you can just treat it as free unless you’re doing a cross join on it or something, unless he’s doing something like using an unordered text file as his database with no ram or cache

      • darkpanda@lemmy.ca
        link
        fedilink
        arrow-up
        0
        ·
        1 month ago

        Buddy’s probably running code he got from GitHub Copilot that is used to do a visualization of a bubble sort for learning purposes.