Welcome to Programmer Humor!
This is a place where you can post jokes, memes, humor, etc. related to programming!
For sharing awful code theres also Programming Horror.
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?
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?
Edit: found the thread with a more in-depth explanation elsewhere in the thread: https://xcancel.com/DataRepublican/status/1900593377370087648#m
So yeah, she's apparently toting around an external hard drive with a copy of the "multiple terabytes" large US spending database, running queries against it, then dumping the 60k-row result set to CSV for further processing.
I'm still confused at what point the external drive overheats, even if she is doing all this in a "hot humid" hotel room that she can't run any fans I guess because her kids were asleep?
But like, all of that just adds more questions, and doesn't really answer the first one - why?
The trick is to take the hard drive out of the EVA foam.
Instructions unclear, dick stuck in GPU.
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??
Substring searches in unindexed large string columns or cartesian explosion caused by shitty joins would be my initial guess.
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!
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.
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.
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?
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.
No, its an external drive, appearently.
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.
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.
He probably mining crypto on top of running his SQL queries.
What? You don't run your hard drives in the oven while baking brownies? It makes them zesty.
There must be more join statements than column names
I'd do that if I was given so much stupid access
They even doubled down: https://xcancel.com/DataRepublican/status/1900565922831618202#m
heh
“YOU’RE JUST JEALOUS” is such a fucking pussy-ass response, too.
Molly White is very bright, and she makes them feel inadequate so they "have to" attack her. It's truly pathetic.
But her last name is White so it's a real dilemma for them.
Literally every time someone dismisses Wikipedia, it's because they believe something crazy that Wikipedia told them is wrong.
“I read a book with a typo once. Libraries are a scam.”
Libraries are a scam if they weren't they'd still have VHS rentals.
I checked conservapedia once, and its actually unhinged. If someone tells you to look at that, or reccommends it, they're crazy.
Did they ever finish their own bible translation? The one they started because King James was too woke.
This shit sounds like when your mom tells you that the Facebook printed out her bank statement on the fax 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?
A laptop should easily handle a database of 60,000 rows. I run much bigger databases on my own laptop for development purposes.
Not if it is filled to the brim with 3 TB of porn
I can personally vouch for that not causing a problem either.
Delete Ass Master volume 7 to make room - that one wasn't any good anyways.
Really went downhill after volume 3. You hope that they'll get back on course by volume 6 at least, but alas.
lol guys I think this is a shit post
As in, a dumb piece of shit is posting dumb shit.
Good lord.