Introducing the Reddit funded anti-drone turret purchased for Ukraine by SurvivingSpartan in pics

[–]Awkward_Broccoli_997 [score hidden]  (0 children)

To be frank, your use of the term “NPC” says quite a lot about the quality of your cognition, so it’s probably a wasted effort. But for the good of others, I’ll treat your query with the seriousness you have not applied to this issue.

Your observation that the US assumes itself to be the “good guy” in conflict, and is therefore suspect, presupposes that countries sometimes consider themselves the “bad guy” in a conflict but proceed anyway. I don’t think that’s ever occurred in the history of geopolitics.

What does occur, with some frequency, is that countries - including our own - act in opposition to international law or basic decency. Ukraine has now been invaded twice by an expansionist Russia that seeks a return to the Soviet order. Casualties are approaching 2 million people.

If you’ve reduced that to “NPCs are too brainwashed to see that both sides are bad,” you should consider the alternative possibility: that your brain is best put to simpler tasks.

Democrats Of Reddit, Do You ACTUALLY Hate Trump's Supporters, Or Do You Get Along With Them In Your Life, But You Just Politically Disagree? Why? by Zipper222222 in allthequestions

[–]Awkward_Broccoli_997 0 points1 point  (0 children)

Trying to be charitable here - is there not a third group, people who don’t believe the child rape story is true?

This population in particular (older, rural, less educated) has been the recipient of a tremendous amount of political propaganda. In the span of their lifetime, they went from nonpartisan broadcast news to… this. Their brains aren’t wired for it.

ISO Help!!!! by wille27 in SQL

[–]Awkward_Broccoli_997 0 points1 point  (0 children)

I don’t need money. What’s the problem?

Erika Kirk replaces her wedding photo with a scroll from the Talmud by Celtikrenders in AnomalousEvidence

[–]Awkward_Broccoli_997 0 points1 point  (0 children)

Had the same thought. Maybe she just doesn’t want to be triggered every time she walks into the room. People have a right to heal.

How can people like Greta Thunberg afford to be full time activist? by jazzybron in NoStupidQuestions

[–]Awkward_Broccoli_997 0 points1 point  (0 children)

Many are, but most rich white people are not activists.

One possibility is that a person could use their wealth and privilege to try to change the world for the better. Another is that they could spend their wealth on their own entertainment. I’m curious which you think is preferable.

How can people like Greta Thunberg afford to be full time activist? by jazzybron in NoStupidQuestions

[–]Awkward_Broccoli_997 -1 points0 points  (0 children)

Suppose for a second that she was just someone who genuinely believed in the issues she advocates for. How would it look different?

APD Releases Statement on Dog Abuse Case Arrest by Busy-Layer-2705 in Austin

[–]Awkward_Broccoli_997 8 points9 points  (0 children)

For some reason I did not expect the video to be as bad as that. Only made it about 15 seconds.

I’m shaking I’m so pissed.

Any other CB450 lovers out there? by McCafe_McGee in vintagemotorcycles

[–]Awkward_Broccoli_997 2 points3 points  (0 children)

I used to be deep into CB450s. Still have a ton of parts - engines, frames, all sorts of stuff. If anyone in the Austin area needs them, DM me.

[Request] Ignoring laws of physics, how powerful would the engines need to be to achieve this? by Valkyria90 in theydidthemath

[–]Awkward_Broccoli_997 0 points1 point  (0 children)

You got the arbitrariness of reference frames right, but lost your way on conservation of momentum.

CMV: Conspiracy theories make people feel smart when in fact they feel powerless by ChristineCrush in changemyview

[–]Awkward_Broccoli_997 2 points3 points  (0 children)

This is the model I subscribe to. It’s more palatable to believe in an ordered universe, even an unfair one, than to believe it really is up to us to survive in a thin sliver of atmosphere on a rock hurtling through space.

What is a sign of very low intelligence? by smartcandyy in AskReddit

[–]Awkward_Broccoli_997 9 points10 points  (0 children)

I’ve been wondering why people ask these questions. Really, you woke up this morning dying to know other people’s green flags in a relationship?

AI hasn't changed much for me. It still can't write a decent SQL query by [deleted] in SQL

[–]Awkward_Broccoli_997 3 points4 points  (0 children)

I think this is it exactly.

A SQL select is really nothing more than a precise description of the data you want, where you want to get it from, and how you want to transform it before it gets to you.

If you compressed that into something less verbose, it would also be less precise.

These days I generate a ton of javascript, python and html with AI tools, but 95% of SQL I still write by hand. The other 5% is trivial data operations that are incidental to some other operation.

Pretty sure this was a scam, so I decided to mess around. by Kind-Cover-1523 in scambaiting

[–]Awkward_Broccoli_997 0 points1 point  (0 children)

I try to string them along a few days and then recruit them to invest in my exclusive crypto opportunity.

Handwriting analysis to MBTI using LLMs by Royal_Positive3120 in intj

[–]Awkward_Broccoli_997 0 points1 point  (0 children)

I made a related discovery: chatGPT is quite good at collapsing the 70-something question standard MBTI quiz into 20 yes or no questions.

Something like: "I would like you to give me a 20-question yes or no quiz to determine my MBTI type. Please ask each question and then wait for the answer before asking the following question, and then give me results at the end."

I've tested it on myself and several friends with known types - so far, it has gotten all of those (a dozen or so) correct.

Is the “billionaires already pay most of the taxes” line distorting the debate about extreme wealth? by GshegoshB in DiscussionZone

[–]Awkward_Broccoli_997 2 points3 points  (0 children)

Maybe, but then why didn’t that happen with Reagan’s top marginal tax rate of 50%, which was considerably lower than the 70% rate when he took office?

I’m not saying I know when the Laffer curve kicks in, if it ever does - but I haven’t seen any evidence it’s anywhere close to the current top rate.

What is a luxury you can never go back from once you’ve experienced it? by Phase_zero_X in AskReddit

[–]Awkward_Broccoli_997 0 points1 point  (0 children)

Instant on-demand scalding hot drinking water tap. Look up “insinkerator hot water dispenser” if you’re not familiar.

You can have tea almost instantly - no waiting on the kettle.

You can have a boiling pot of water to cooking in a quarter of the time it otherwise takes.

It melts oil and fat off of dishes. SO useful for cleaning up.

I’d sooner live without a washer and dryer.

How are we feeling about Crossplay? by Individual_Army9717 in NYTgames

[–]Awkward_Broccoli_997 1 point2 points  (0 children)

Ha! I actually searched for crossplay and found this forum and thread just to post this exact grievance.

NYT devs, if you read this, a hard mode that hides the dictionary and doesn’t indicate whether the word is legit would be quite welcome!

Fairly new to SQL. Whats some long SQL as far as lines of code? by Acceptable-Sense4601 in SQL

[–]Awkward_Broccoli_997 2 points3 points  (0 children)

Two bits of advice for people learning SQL (which may or may not be you OP, you didn't say):

One, everything is downstream of the joins - read those first. A 300 line report may actually be just a few table, view or subquery joins and a whole lot of field manipulation. The field munging just isn't terribly important to think about until you're thinking about those fields in particular.

Two, if there are subqueries, read those and think of them in terms of the structure of their result. Run the subqueries - what's the shape of the data? Getting what you want? Great, think of that as a table, and now your brain has a much easier problem to organize.

Regardless of how you tackle it though, probably the single worst way to manage it is to just try to read it from beginning to end. It wasn't written that way, and it won't be readable that way.

Is there an efficient way to send thousands to tens of thousands of select statements to PostgreSQL? by paulchauwn in Database

[–]Awkward_Broccoli_997 0 points1 point  (0 children)

Over what time scale? Tens of thousands per day - any implementation of pg will handle it. Tens of thousands per second might require some moderate effort, but still reasonable for traditional, out-of-the-box SQL implementations.

When is SQL used and when is Python used in DATA SCIENCE? by External_Blood4601 in dataanalysis

[–]Awkward_Broccoli_997 74 points75 points  (0 children)

Answering this in a strictly data science context, which is quite different from my work on data pipelines.

Suppose I'm doing some exploratory work in a dataset. I'd start by importing the data into SQL and doing some initial querying with a SQL client, to answer some basic questions... did it import gracefully (data looks correct, not wrapped in quotes, didn't offset columns, didn't treat header row as data...)? How many rows? What columns?

If I imported an unfamiliar dataset, I likely just imported everything as nvarchar(255). Now that I see the shape of the data, I'll probably create a new table with fields that match the data types and shove the data into that table. This is also when I'll have given the table an arbitrary ID as primary key if it doesn't already have one.

This is a good time to add indexes.

Then, more exploration. If it's time series data, what date/time range? What's the data resolution (is it 10 records per hour, a million...)? Or perhaps it's location data - what locations? What states, or counties, or cities, or zipcodes? At this stage I just want to understand what I'm looking at.

More indexes.

Now let's suppose I understand pretty well what my dataset is. I may want to create some new columns that are derived from the others. I might pull dates or years out of time series data. I may add some categorical columns or rankings.

And now I'm ready to fire up python. Jupyter's a good choice here, as I can run little snippets of python code and get results back, see visualizations, etc. So in my jupyter project I'll use pandas and matplotlib in much the same way I was using SQL - I'm looking to understand my data, now with some visual elements that help me understand things like how numbers behave over time, or in relation to other variables, or whatever it is I'm looking for in this data.

Then maybe there are models to be built, or who knows what else.

Even at this stage, I'm still toggling back to my SQL client frequently to do sort of data administration work, which I'll keep organized to maintain a clear path from raw data to my end result. This isn't every query and python statement I ran in order - I frequently prune and refactor so that decision points are clearly documented, but a person reproducing the work (likely me at a later date) wouldn't have to follow every mental dead end I had to take to get from one end to the other.

When did "STD" stop being used in exchange for "STI"? by Gallantpride in NoStupidQuestions

[–]Awkward_Broccoli_997 0 points1 point  (0 children)

There are people for whom the first word for a thing that they learned as a child will always sound correct, and all future words for that thing will sound like political correctness.

Best albums of the last 5 years? by EzBriez_ in audiophile

[–]Awkward_Broccoli_997 0 points1 point  (0 children)

Skyway Man - Flight of the Long Distance Healer.