Programmer Humor

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”

it is, in the select event that your platter bearing fails, in which case it would be very, very obvious.

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

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".

Have you ever heard of case of overheating hard drives within the last decade?

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.

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.

We must make better memes

I'm not even joking, the world runs on memes now. It's fucking stupid, but we must shitpost to save ourselves

I've been told violence isn't the answer and we shouldn't just shoot nazis and nazi enablers dead.

The way most people change their mind isn't based on facts or figures, but emotions. Specifically, in-group belonging. For most people, and this certainly includes me and you some of the time, what our in-group believes is more compelling than an out-groups supposed facts.

They see that guy as someone in their group so they believe him. They see you as a bad outside bad bad bad liar, so nothing you say is likely to get through. (This comic is worth reading on this topic: https://theoatmeal.com/comics/believe )

If you want to change someone's mind, they have to see you as in-group. Not necessarily the same group as what you're arguing with. We all belong to many groups. American, new yorker, white guy, middle aged, yankees fan, etc etc there are many such slices. Like how you can't get a republican to recycle by appealing to environmental concerns (because environmentalists are out-group, so fuck them), but you might be able to get them to recycle via something like "only american ingenuity can turn trash into bridges and tanks!"

This takes a lot of time and effort, and if you don't get them to stop hanging out with the other group, you won't make any lasting changes.

So I think you'd need a multi prong approach:

• Get them off bad media. Facebook, fox news, etc. This is reinforcing their bad beliefs. Because they see this stuff as trustworthy in-group, it goes right into the worldview.
• Get them to stop hanging out with their shitty maga-hat friends. This is the social in-group that's reinforcing bad beliefs.
• Get them to trust you.
• Gently introduce the idea that maybe the extreme right doesn't have their interests at heart, etc

All of which takes a lot of time and effort, and your opposite number is basically trying to do the same thing. Except they have fox news, trump, and such in their corner.

And, again, I'm told we definitely shouldn't just shoot extreme right wingers and other nazi sympathizers dead. Nor should we burn their houses down. If we're an emergency responder, we definitely shouldn't let them die while thinking to ourselves "they would let so many die. without a thought, their passing deserves no mourning" or similar.

You should definitely nullify if you're on a jury and someone allegedly did violence to a shitty ceo or red-hat, though, bu that's getting off topic.

60k is laughably, embarrassingly small. It's still sqlite-sized.

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.

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.

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.

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.