HNHacker News
TopNewBestAskShowJobs

throwaway23597

462 karma · joined October 5, 2022

submissionscomments
throwaway23597··on SQL should be the default choice for data transformation logic
IMO there's a big difference between university level SQL and the ability to competently write SQL in a professional setting. In university, at least at my school, you are getting maybe at most 3 tables overall, with 3-5 columns each. Professionally, you're dealing with hundreds, maybe thousands of tables, each with between 10-1000 columns, and usually not even in 1NF either. It really takes a lot of practice writing queries professionally to get to a level of competence here.
throwaway23597··on Big Tech Layoffs Are Hitting Diversity and Inclusion Jobs Hard
I mean honestly, you can't possibly think that just adding people of other gender / skin colors just magically improves profitability. There's clearly some lurking variables here that McKinsey purposefully ignored in order to draw this specific conclusion.
throwaway23597··on Google’s Fuchsia OS was one of the hardest hit by last week’s layoffs
To play devil's advocate, in the case of a company like Google, it's unclear whether or not execution actually gets much slower. From what I hear the amount of people coasting or even distracting teammates with negativity is pretty high, cutting such people might even speed up execution in the net.

As for Fuchsia as a product I'm not really sure what exactly it is so if possible I'd love a 411 from any HNers with know-how.

throwaway23597··on If you find this world bad, you should see some of the others (1977) [pdf]
Well, how does that explain the result of 7.304 for the q-hypothesis?
throwaway23597··on How Kurzgesagt Cooks Propaganda for Billionaires
People seem all outraged, but I really don't care. Kurzgesagt is just a youtube channel of explaining cool science topics with very high quality animations. It's really not so different from Cosmos, or Into the Universe, or Mythbusters, or any of these other shows that were also financed by multinational corporations. Nobody cared that billionaires financed those other shows, why's it such a big deal for Kurzgesagt?
throwaway23597··on Weird things about SpaceX's Starlink internet satellites
In all honesty, the fact that this laser based communication exists makes me a lot more likely to believe that SDI was actually a success in the classified world.
throwaway23597··on Google datacenters use 'a quarter of all water' in one US city
I'm pretty sure that a municipality needs a population of 50K to be considered a city. This is more of a small town.
throwaway23597··on AI Drew This Gorgeous Comics Series. You'd Never Know It
Welcome to the future. As these tools improve, expect a massive explosion of content, in increasingly complex forms. Today it's comics, tomorrow videos and music, next week video games. I for one cannot wait until any old schmuck has the power to create a full-featured 3D video game.
throwaway23597··on Ask HN: Are there valuable insights from the Twitter files?
Uh, extremely high? It just wouldn't be Musk doing the evidence releasing, instead it would be leaks from other employees.
throwaway23597··on Which? tells Nintendo what is causing its Nintendo Switch drift issue
I mean, isn't it kind of obvious that this design "flaw" was engineered on purpose in order to force people to buy more JoyCons? Every company does this sort of thing.

On a side note, does anyone have any recommendations for a legitimate premium controller for PC that won't break? I've tried so many controllers and they all turn out to be cheap bullshit... the best I've been able to find is the official Xbox remote. But I'd gladly shell out big bucks for a high quality controller that won't break, like a mechanical keyboard but for gaming controllers.

throwaway23597··on Automotive chip shortages to continue throughout 2023, industry says
Great, another excuse for the automakers to keep prices high. But the truth is that they're shooting themselves in the foot. I simply refuse to buy a new vehicle until we see significant deflation in the auto markets. And I'm not the only one. Nobody wants to play this stupid game with these greedy bastards, especially not when wages haven't budged an inch to keep up with inflation.
throwaway23597··on Taking over subreddit with a small GPT-3 army turns out to be surprisingly easy
Scary stuff, and it makes me think that the days of anonymous online forums are coming to a close. Even HN, unfortunately. I'm not sure how you stop this from happening without increasingly invasive KYC-type measures.
throwaway23597··on Jan. 6 panel announces 4 criminal referrals for Donald Trump
You're barking up the wrong tree here, guy. I don't care about the politics or whether it's right or wrong, I'm just telling you, they're not gonna indict Trump based on this House committee report. If the DoJ is investigating it as well, that's fine, but this report will be completely ignored outside the media just like all the other partisan congressional reports. If you feel so strongly about this, then go write a letter to the DoJ or something.
throwaway23597··on Jan. 6 panel announces 4 criminal referrals for Donald Trump
I mean I'm not surprised. Everyone knows that congress is a joke and these "committee investigations" are the biggest partisan frauds. These congresspeople are a bunch of incompetent morons who care only about political point-scoring and have no interest in actually getting to the truth of any matter. The DoJ on the other hand is far more serious... if the DoJ indicts Trump then I'd say he's actually in legitimate trouble. This committee report is a stupid media charade, nothing more.
throwaway23597··on Google datacenters use 'a quarter of all water' in one US city
This is clickbait. This "city" has a population of 16000.
throwaway23597··on Jan. 6 panel announces 4 criminal referrals for Donald Trump
Hate to say it but I don't think the DoJ is gonna act on this, especially not while they're currently investigating Trump for other malfeasance. This committee is pretty partisan - 7 D, 2 R. You'd be setting off a real firestorm to indict top political leadership (not just Trump but McCarthy & Jordan as well) based on this report. One can already imagine the Fox News reports.
throwaway23597··on Binance's books are a black box, filings show, as it tries to rally confidence
Binance and Tether will not become insolvent, and that is precisely the issue. They have an essentially endless supply of laundered funds, criminal money, and international backing. It's essentially a financial weapon aimed at the West, and adversaries of the West will not let it fail. Major regulation is the only way that these beasts will be slain, but they have donned the cloak of "an exciting new fintech industry" and are lobbying like hell, so I'm not terribly optimistic.
throwaway23597··on AI breakthrough ChatGPT raises alarm over student cheating
These tools aren't going away. And I still think ChatGPT is incapable of writing a full essay with parenthetical citations and such that schools require. Perhaps the best solution would be to teach students to use ChatGPT to help improve their sentence structures and grammar, which I think would raise essay and writing quality across the board without explicitly crossing the line into blatant cheating.
throwaway23597··on Holographic Glasses for Virtual Reality
> Our binocular wearable prototype provides a diagonal field of view of 22.8°...

Definitely some cool tech, I'm glad Nvidia is innovating in the space, but they're really gonna need to crank up that FOV to make this viable. I hope it's physically possible to get a full-eye FOV in a glasses form factor...

throwaway23597··on Former Apple Executive Says Company Blundered by Firing Him After TikTok Video
This situation is so stupid that it seriously breaks my brain. A 22 year career ruined over some dumb movie quote uttered outside of work, for a video that didn't even go viral... Who the hell even was offended by this? If this sort of thing happened to someone who wasn't already financially secure, they'd probably go postal.

I genuinely wonder if some of cancel culture is driven by foreign influence operations? Seems like a pretty effective way to attack an open society. Like this guy apparently was one of Apple's top negotiators with China... seems directly in the Chinese interest to get him canned.

throwaway23597··on Ask HN: How is Snapchat getting away with no content moderation?
Snap is crazy, man. It's not just pornographic content. Back in high school, kids used to just openly sell drugs on that platform. Snap stories very blatantly selling weed, lsd, shrooms, cocaine, etc. I was honestly appalled at the time but apparently police never picked up on the situation. I imagine that things are even more intensified today, if anything.
throwaway23597··on Computer Science Students Face a Shrinking Big Tech Job Market
> The number of undergraduates majoring in the subject more than tripled from 2011 to 2021, to nearly 136,000 students, according to the Computing Research Association, which tracks computing degrees at about 200 universities.

I feel like this number is still much lower than it should be, given that our entire society pretty much runs on computers at this point.

throwaway23597··on Ask HN: How do you cope with existential threat regarding career?
There's a big difference between ML Eng jobs and ML Research jobs. Research, yeah you'd need a top PhD and many difficult years of study. Eng, far more attainable, but IIUC it's not exactly going to feel like you're working on some crazy cutting edge tech, you'll mostly be cleaning data and tuning pipelines.
throwaway23597··on Tell HN: Giving ChatGPT access to a real terminal
You're a madman. Well done. Starting to think more and more that the singularity will be caused by accident.
throwaway23597··on Pentagon debuts its new stealth bomber, the B-21 Raider
The military always keeps the real game changing stuff under wraps for strategic purposes. The very public parading of this plane, along with other "cutting edge" planes like the F35, makes me think that manned airplanes are already obsolete. It's been perfectly obvious for a while that unmanned aerial vehicles have the potential to be greatly superior - the lack of life support requirements alone creates an enormous amount of possibilities for maneuverability and observability. Highly recommend checking out the following article for more details on this: https://www.thedrive.com/the-war-zone/3889/the-alarming-case...
throwaway23597··on Musk’s Beloved Twitter Polls Are Bot-Driven Bullsh T, Ex-Employees Say
Eh, while this may be true, I would not exactly say that rolling stone is a credible source.
throwaway23597··on New details on commercial spyware vendor Variston
So the way this was discovered was through an anonymous tip. How often is this the means of discovery for malware / 0-days / etc? Would Google have found this if it wasn't for the tip?
throwaway23597··on Huawei phones automatically deleting videos of the protests?
Yes, you're absolutely right. Jonathan Haidt touched on this quite a bit in "The Coddling of the American Mind". Unfortunately I see no possible way to reverse the situation. People simply aren't used to hardship anymore, you can easily live a life of pure comfort. The advances in digital technology only intensify this phenomenon. Short of major economic collapse, I'd expect humanity to become increasingly soft and squishy, to the point of essentially becoming another form of cattle.
throwaway23597··on Huawei phones automatically deleting videos of the protests?
Haha, I can't imagine that this happens often. But that being said, there are documented instances of Alexa picking up sensitive conversations on accident, for example in this WaPo article where it was observed picking up sensitive information:

"There were even sensitive conversations that somehow triggered Alexa’s “wake word” to start recording, including my family discussing medication and a friend conducting a business deal."

https://archive.ph/c7G1c

throwaway23597··on Influencers were paid by Google to promote a Pixel phone they never used
Is anyone actually surprised by this? Influencers get paid to promote all sorts of products these days, and I'm sure they use practically none of them. You think all these celebrities were actually paying for things using their shitty pump n dump crypto tokens?

Influencers and influencer marketing is a very new thing and in time I'd expect ethics to develop around these roles, but for now it's the wild west and if anything I'd say products advertised by influencers are a red flag.

← PreviousPage 2 of 4Next →