skysight-inc/HackerNews huggingface dataset:
EDIT: I was understandably being downvoted for saying that the code could be more readable. On reflection, the sql is good, and it's the Perl-ness that I had a bit of a reaction to.

I'll leave my questions here in case people would like some food for thought anyway.

- what's with the mixture of styles (q{sql}, sql with '?', sql with '$1', sql with '\$1' etc)?

- what's the use case for a right join, when left joining is the norm?

- in the $stats query, inactive_workers isn't actually inactive_workers and instead it's patched based on active workers afterwards. For me, the jumping of inconsistent column selections on each line makes it hard to see that. (If someone just copied the sql into psql to run it, it would be wrong, but not obviously)

- Maybe it's not fair, because I have sqlalchemy to improve readability, but this whole thing where the variables aren't obvious in a blob of sql could definitely be easier to read
> However, the fact is the hardware is still a separate entity from OS and is still locked down.

Is that a fact? I think not. (don't misunderstand me, I would love mobile hardware to be 'the same' as fixed PCs, but as far as the world is concerned, it is not.)
JRE doesn't have open debates between pro/anti vaccine guests. He gives 3+ hours of air time to vaccine conspiracy theorists with very little pushback. It's easy to get swayed by a contrarian opinion if that's the only one you hear.
Because I may have an offer?

Your hostility is completely uncalled for by the way.

Hacker news is a special place, where the technically minded discuss many things of interest including opportunities.

It’s (still) a special place and if you want to keep it that way then consider shifting your perspective.
I'm very sceptical of non specific hate hustlers. Character-conditioned or rational variants are peddled by academic observers who don't appear to have ever been threatened with life threatening hatred.

In the western world claims of being 'hated' are often a desperate cry for visibility and relevance in society.
Just out of curiosity which email client do you use on mobile with Migadu?
I just went through this experience due to the notification from Google that my free G Suite Legacy account was going away. Fastmail's documentation and onboarding experience made it a few hours of work to do the migration.

I'll also be going the same route and using an old vanilla gmail account for Google Docs as needed.
Adding my useless website to the list: http://magickeyboard.io - it’s fun to build one-off random sites and put them out there :)
The episode dropped in 1992 (the dub in 2008). I imagine $30 was egregious at that point.
Presumably because you like Erlang.
It's not moving the goalposts; it's accurately portraying the concept that was imperfectly conveyed in the past by "minorities".
The "ONE" is auto-"corrected" by HN software, so you need to actually go back in and edit it after posting when submitting such titles.
Could you point me to some resources about this sort of thing? I remember hearing about someone implementing transpilation of some subset of C++ to some subset of Java using Prolog but I couldn't find the actual code.
No. https://en.wikipedia.org/wiki/Epiphenomenalism
Part of the problem is, vulnerability scans are the only tool for vulnerability management that our puny tiny pathetic programmer brains have invented. Now, realistically, it would make a lot more sense if libraries that call pickle() had some kind of "use warning" attached to them, which your IDE would use to detect when you do something that opens you up to compromise (such as using untrusted user data in some weird contrived context that forces a library to call pickle() on it). But NO. You CANNOT have this. Everything MUST be a CVE.
I'm gonna let you in on a secret. Unless you're working for a charity, NGO, etc the company is almost always rotten on the inside. Don't ever go looking for a moral company, that's not what capitalism is. That's the nature of things. What you need to worry about is if the company will treat you well for what you bring to the table. If they don't then make sure you have an easy out in your contract. You should worry more about the team you will be working with and how they fit the way you like to work. Do you like to work alone with things throw over the wall? Do you like the product/service they provide? Do you like the pay? Do you like tight knit group that works closely and has lots of meetings? Those are few things you can eek out during an interview with some clarity. You will never know if the atmosphere is poisonous or not really until you get there.
You can't generalize speculation or growth stocks with value stocks. Cut out meme stocks or recently IPO companies, for they skew the data for an overall economy analysis.

On Apple, if you compare a 1 month (from new year's heights) market correction with major direct or indirect competitors (quick sampling) before their earnings: Microsoft, AMD, NVidia, Amazon, Netflix showed 15-30% decline, while Apple was only -10%, S&P500 -9%. This downturn was mainly based on [unfounded] fear sentiment outlook (bear/short speculation by media): supply chain disruptions, fed hikes, Ukraine war. More on this below.

After earnings, Apple was ~+10pts or -5%, while S&P -7.5% on 1 month avg. Because Apple is diversified (and successful) in so many present (and future) industries, you can prob. treat it as a better indicator/peg for the US economy - if you don't want to be involved with "blood money" stocks inside popular ETFs (Meta, J&J, etc.) No wonder Buffett holds Apple as a majority stake in his portfolio (~49%).

If you want to see how unfounded the fears above are and how those newly printed dollars will eventually flow into the system/economy (and not just "disappear"), take a look at these sources:

[1a] P/E ratio: 1st peak caused on 2007 caused by 1st iPhone announcement and later decrease caused by mortgage crises or earnings increase?
https://www.macrotrends.net/stocks/charts/AAPL/apple/pe-rati...

[1b] The fed printed money for the 2008 crisis and lowered int. rates to nearly zero (though less scale), 2nd P/E peak now (dejavu?). Notice the marked crisis periods.
https://fred.stlouisfed.org/series/M2

[2a] Interest hikes: Fed plans 3-4 till 2023, but will not top 2% (media estimates). Gov likely not rise it too much like the 1980s, since we are still recovering from the pandemic.

See the 2016-2020 hike? This could have been affected by Trump's corporate tax reform, but the stock market went on a parabolic rise since then
https://tradingeconomics.com/united-states/interest-rate

[2b] Historical effect on hikes
https://www.forbes.com/sites/kristinmckenna/2022/01/24/how-d...

[3] Historical effect on wars
https://www.investopedia.com/solving-the-war-puzzle-4780889

Fearmongering has been used in the last crisis to sell gold, this time is crypto.

PS: This was just a quick analysis, would love to hear from experts.
> where nuance is particularly hard to convey

It's not just not easy to convey there, it's not tolerated by a large part of the population there.
No, you don't understand progressive taxation. You pay 0% on your first 10,000€, then a few percent for the next 12,000€ and so on.

In 2021 in Germany for an income of 60,000€ you need to pay 11,735€ income tax, roughly 19.5%. there is also no soli tax anymore unless you are earning a top-2% income.
When I was in college, and much more willing to suffer, it was 335 miles from home to school, and took 5.5 hours driving. I could do that without stopping, though normally would stop at least once for snacks/bathroom. Now I’m more likely to stop two or three times on a trip that long.

Even now on a mountain west traffic-free interstate I don’t really count on going more than 500 miles in a day. And that includes a meal break.

Both of these use cases sound like they would be very minimally disrupted by planning my stops around a charging break.

I think that range anxiety is largely overblown for a huge majority of use cases.
> What's not clear is that I have a YouTube channel attached to this Google identity and I don't know if when my custom .com GMail address enters the 'suspended' state whether I will lose access to my YouTube channel.

I believe the prevailing proposed solution is to migrate your accounts to the free Google Cloud Identity service [1] before cancelling your Workspace subscription.

[1] https://support.google.com/cloudidentity/answer/7319251?hl=e...
Apologies if this comes off as trying to e-diagnose you, but may want to look into “Complex PTSD” (ICD-11 F62.0) if you haven’t.

“Complex PTSD is a new disorder category describing a symptom profile that can arise after exposure to a single traumatic stressor, but that typically follows severe stressors of a prolonged nature or multiple or repeated adverse events from which separation is not possible (e.g., exposure to genocide campaigns, childhood sexual abuse, child soldiering, severe domestic violence, torture, or slavery).”

https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3799241/
Ruling Out Real-Valued Standard Formalism of Quantum Theory
When people send me google docs I make use of the guest account feature. You do not need a Google account.
https://arxiv.org/abs/2103.08123
For me the annoyance was that I had 4 legacy organizations that I had to spend hours figuring out how to merge (incredibly non trivial to get drive contents from one organization to another, shared drives work but only with files and not folders, so I had to move stuff over a folder at a time). If they’re going to do this crap, I wish they had proper migration tools. They left a lot of us high and dry. A lot of people aren’t against spending money, but if we already have to spend the time to move crap around, we might as well pay an organization we trust.
I'd recommend picking one between (1) Fastmail and (2) Hey.

There are some pros and cons, but both are good.

I went with Fastmail.
.local not working might be your router trying to be helpful and snoop multicast to limit it to pairs of devices. Something about iptv optimization or whatever I don't really understand. Since I turned this feature off .local works as it should.
You can consider the last two years to be a staging environment, depending on your industry.
From all the places I'm surprised Fastmail gets so much praise in HN. I'm sure it's a nice paid service but it's based in Australia which is notorious for being a disaster for those who care for privacy. There are countless posts in Hacker News about this (just search Australia + privacy) and here's one [1] that's specifically addressing Fastmail and its situation over there.

I'm not against Fastmail specifically but I'd definitely consider services based in countries which do better privacy-wise.

[1] https://news.ycombinator.com/item?id=28410178
A good use for the prefers-reduced-motion media query in CSS.
There's a great documentary on Netflix about her called The Center Will Not Hold.
I'm not familiar with this author at all, but from a search it looks like they wrote about the issue before moving to substack: https://thomasjprosser.wordpress.com/2021/02/22/whats-causin...

And a follow up post: https://thomasjprosser.wordpress.com/2021/02/25/why-speak-ou...
That isn't quite true

https://en.m.wikipedia.org/wiki/Consciousness
In order to compete with native apps the APIs would have to grow and thus the attack surface would also grow
Why do it though? You’re ruining your life and halving your normalized hourly rate. There are plenty of companies where 40 hours of effective work is a top performer and things aren’t breaking every week
One reason I am looking to move away is that Google simply has too large of a market stake in the email business. If I'm going to pay, I'd rather pay a smaller company in order to stimulate diversity in the field; it's just better for open standards.
"a distinction arises in using ..."
You can still get a google account without signing up for Gmail, so you can still use Google Docs and share/collaborate fine.
Almost as if the writer is looking at a fish tank, it demonstrates how everyone is now in a constant state of isolated perspectives, and unable to walk in the shoes of others.

Whatever is normal for us defines our world. The constant underlying battle is that we're less and less capable of walking in the shoes of others. If you live in rural America, you'll realize the same blights and issues exist too. People go through trauma and tragedy, and they often simply give up, this world is harsh on people who give up, or use drugs, or resort to harmful behavior especially if they're financially and racially not able to overcome societal stereotypes that are promoted. Just as there are individuals using crack and heroin in the inner city, there are wealthy people in Hollywood doing exactly the same things. Society works so hard to define differences and then to rebrand them as case studies and perspectives, but no one talks about the human nature perspective because it's really uncomfortable for humans to examine their own individual faults in the process.

I've lived in DC for over 30 years, and seen every corner of it. I was born to middle-class priviledge, but I've also As a minority myself, I know how hard it can be at the bottom through not being intimidated of living inside of that "fish tank", and knowing from that experience that there are people born to, and suffering from, much worse situations than mine.

If we look at the ways out of poverty and desolation as a scientist, we're already failing because there is no really effective way of grouping individuals into any actionable case study. It's frickin everyone that is the issue now. The cure for ignorance is understanding how every last one of us is vulnerable, susceptible, and accountable for their individual perspectives and actions and self education about wealth inequality and racial insensitivity... world wide.
I'd say,

1. Communicate intent.

2. Explain why.

3. Do not use more than 3 bullet points.
----------------------------------------------------------------

Dear battery technology claimant,

Thank you for your submission of proposed new revolutionary battery technology. Your new technology claims to be superior to existing lithium-ion technology is is just around the corner from taking over the world. Unfortunately your technology will likely fail, because:

[ ] it is impractical to manufacture at scale.

[ ] it will be too expensive for users.

[ ] it suffers from too few recharge cycles.

[ ] it is incapable of delivering current at sufficient levels.

[ ] it lacks thermal stability at low or high temperatures.

[ ] it lacks the energy density to make it sufficiently portable.

[ ] it has too short of a lifetime.

[ ] its charge rate is too slow.

[ ] its materials are too toxic.

[ ] it is too likely to catch fire or explode.

[ ] it is too minimal of a step forward for anybody to care.

[ ] this was already done 20 years ago and didn't work then.

[ ] by this time it ships li-ion advances will match it.

[ ] your claims are lies.

----------------------------------------------------------------
By now I'm semi-convinced ISPs are deliberately holding back IPv6 in order to make a buck selling static IPs. They charge a good chunk of money per month for an IPv4 address (at least in Switzerland, the UK, and New Zealand), which is basically just rent extraction from artificial scarcity. And it's pretty obvious that once they transition to IPv6 there is no good reason not to give every single customer enough static IPs for a lifetime of devices.
I use Tutanota due to its privacy focus. 1€/mo is very affordable.
The funny thing is, for my entire (scientific) career, I never felt like anybody was scooping me. Instead, I felt like I was waiting for the rest of the literature to catch up with where I was mentally, years before. Many of the things that I worked on as an undergraduate sort of... didn't go anywhere for 20-30 years until neural nets became awesome again.
> For example if your ISP gives you /64 prefix, most consumer routers will not recognize it as valid.

A /64 is the most valid IPv4 prefix there is. Most consumers should be given multiple (usually about 16) and the router starts with the first one.

> And if you get a /128 prefix, good luck that

No kidding, that's a single address subnet!

> NATs are apparently disallowed in IPV6 world.

It's allowed it's just not the right answer in the vast majority of cases.
There is a YouTube video about India's attempt at semiconductor fabs. Never knew they had built a fab before Taiwan had one.

https://www.youtube.com/watch?v=isBYV6QWDIo
Worked at an OEM and Microsoft charged a license fee for every processor out the door regardless of whether the system had DOS, Novell, or nothing at all installed.
Found this one, good one! https://mondrianandme.com/
Some people, perhaps correctly, see them as a centralizing entity for the internet with a profit motive. That they are also currently kind of "eating the world" gives cause for concern. They currently haven't yet betrayed their users but many see it as a matter of time before they begin selling user data.

Happy to be corrected on that last bit by the way if they have done anything egregious.
Oh I see, yea you are correct
Can you tell more about tools you use? And what about renaming functions/variables...? It seems it's error prone without IDE/language server.
NAT is actually probably preferred too for homelabbers one because you don’t have to re-address things ever and also because you can use your whole ISP assignment as a pool of dynamically assignable/attachable public addresses.
I'm paying for Workspace and use it as my primary Google Account and really wouldn't recommend it unless you also have another regular Google account and use Workspace only for work, because the "Google experience" on a Google workspace account is really sub-par. Google assistant functionality is limited, you can't get invited to someone's home, you can't set up a family, actually you can't use Google One at all. The list of inconveniences is huge. I've been planning to move out of Google Workspace for years but it's a hassle to migrate primary inbox.
What I see is that the code bases that don’t get cleaner over time either go away, or calcify and the maintainers spend most of their energy on talking people out of changing anything.

I’ve worked on teams where a competitor could add features faster than us and eventually they pulled ahead and took customers. I’ve been on the other team too. Early lead matters if you planning a quick sale and to run with the money. But if you miss then someone will eat your lunch. If you learn to write less brittle code you can recover.
Biden's Failure to Acknowledge Tesla Is Wearing on Elon Musk
Ask HN: Why did BBC broadcast James Burke's “Connections” when it's so wrong?
Braess's Paradox[1], mentioned in the article, is a wonderful observation on traffic flow.

I was once told that "common sense is just what the stupid think is obvious without actually checking", which makes me chuckle[2].

All these counter-intuitive OR observations are wonderful because they remind us to dig deeper and measure stuff instead of guessing.

1. https://en.m.wikipedia.org/wiki/Braess%27s_paradox

2. Because we are all stupid occasionally, to one degree or another.
Cancel culture is rather more specific than that. It's not descriptive of getting arrested for a crime, stubbing your toe for being careless, or getting dumped for mistreating your SO. It's a quite specific response (Twitter mobs, contacting the person's employer, making it a sin to enjoy the offender's art/works) that has a lot more to do with what the responders choose to do than what the offender chose to do.
I just switched to Fastmail this past week and like it quite a bit.

On a related note, I changed my credit card email address, and it triggered a security alert & they froze all 4 of my credit cards. They asked for three different forms of documentation to prove I was who I say I am, and reviewing the evidence will take 7 to 10 days. So if you change your email, be prepared for a little pain just in case.
> It’s entirely on you if you think there is any hypocrisy here

I like Neil Young, and I don’t care what he chooses to do with his music. Pull it from Spotify, it’s going to hurt him financially more than hurt his fans, we have already purchased his music. If I can’t stream it, no biggie. If I really want to listen to NY, I’ll dust off the vinyl.

I am sure he has a sincerely held belief that to him that allows him to carve out an authoritarian pro-government exception that satisfies his own moral values. He has done it on a couple of songs.

However, I personally feel like a person who made his fame on anti-authoritarian, free speech, anti-government themes in his art should not be surprised at people drawing a conclusion that he is a hypocrite when he takes a public position that is pro-authoritarian, pro-government, and requesting corporate suppression of another person’s opinion.
Not sure I see the point. If you want to post a fake Wordle unicode that shows you got it right in one try, no one is going to believe you because it is so easy to fake it by just editing the text.

This thing will be likely to fool people, because they won't think you went to the effort to go into a paint program and faked it. (admittedly, that isn't hard either, but still.... )
This would definitely be a bad sign for me during an interview, I would say "next" pretty quickly. I have enough to deal with at work I don't need a social warrior that is more worried about the woke twitterati rantings than helping me get next week's bucket of issues done.
I’ve had the same experience. Feel like shit every time I get hopped up on the latest paper and try it again. I don’t want to live forever with T levels of an old man. I thought maybe I was the only one feeling this way, although I had seen the papers about it lowering testosterone.
I used to spend a lot of time at DA with Linux customisation. There used to be it's own category which was useful. Now I have to filter through screeds of nudes and shit to find anything. It's not worth the effort.
Try Debian Stable -- we only need milliseconds!

(Current machine saw exactly one, 45 kB patch in the past week).
The difference is that with a firewall, you open the port and that's that. With port forwarding, you get whatever port happens to be available. If done manually, you have to tell the other sode which port to use. If done automatically (like upnp), you need to do that every time your port changes.
It's excellent!
Some idioms were lost in translation, here is a perhaps a bit more literary version

> This was a comic book that described what the compooters[1] are and what to do with them, and I finally realized that I could never get to the fairy land called "minframe" [2] in this life.

[1]: sic, deliberate misspelling

[2]: I could not find a better English translation for the original word "ЭВМ". The acronym stands for " electronic computation machine" which technically just means "computer", but in the sense of "computer occupying a whole room that feeds on punch cards and interns"
Reading from “SaaS generating usd 500/month” thread, I believe you can create SaaS and host it in your home.
It extends to other policies as well
> Zoho could perform a Google style rug-pull on you.

Zoho has done so, with the removal of POP/IMAP for their free tier without any notice.
What about axes other than economic and foreign policy? There are many government policies in effect that large parts of the right strenuously object to.

In fact, even on foreign policy, I'd be surprised if the forever wars in the middle east enjoy majority support among the right. Isn't isolationism also right-wing? If it's at all helpful to classify policies into 'left' and 'right'..
A mouse on an Android phone? Does your phone not have a touch screen?
https://www.infomaniak.com/en/free-email- free email if you move the domain to their service. Pretty inexpensive (1/4 of go daddy).
Really like a lot of things, it's both.