skysight-inc/HackerNews huggingface dataset:
Postgres does. :-) At least if genetic algorithms count as AI. If there are a lot of tables in the query, Postgres will switch to its GEQO planner [0]. The hardest thing about planners is they need to make a decision fast. It would be silly if they took longer than the marginal improvement over a worse plan. And since the possible ways to join tables grows exponentially, an exhaustive comparison quickly becomes impractical.

[0] https://www.postgresql.org/docs/current/geqo.html
I would heartily recommend Immune by Dettmer [0] if you are interested in how your immune system works. Fascinating read.

[0] https://www.goodreads.com/book/show/57423646-immune
There is one more: I have one address shared with about 100 private users in Germany. Many of them not technical at all. It gets German phishing attempts all the time, maybe 1-2 per month. I assume a user was infected by malware.

Edit: And there has always been spam to my gmail address. I have shared/stored my gmail address in extremely few locations just for forwarding and it's of form first.last@gmail.com. There are only 3-5 people on the planet with the same name. The spam comes without dot so I guess it's not from a list of email addresses, but generated from a list of names. My name has been on the Internet e.g. in Usenet and in scientific papers many times long before gmail existed. Volume is not too bad, a couple of them every month. It was worse years ago.
We live in Greater London, with the Mayor of London (the City has a Lord Mayor). We tend to adjust our local government boundaries to match development, or create green belts to prevent sprawl.
> Then there is grass fed cattle.

Sure. Which is significantly more expensive. If only grass fed beef was available, beef consumption would automatically decrease.
For thorough review, look for loopop as usual:
https://www.youtube.com/watch?v=9DqqKYAGsGo
GhostiPy: Open-Source Signal Processing and Spectral Analysis for Large Data
Being in a caloric deficit of 3500kcals x [the amount of body fat pounds you lost] over a given period of time is responsible for losing [the amount of body fat pounts you lost] over that period, no matter what kind of food you eat. Keto might be responsible for you to adhere and stick to that caloric deficit though, and it's good that it worked for you, but that's not what drove your weight loss (anecdotally, I lost around 150lbs and never cut any food group out of my diet, I just track calories and proteins)
> It’s funny because the Onion has long since stopped being controversial enough to be at risk of being banned by anyone.

If the Onion stopped being controversial, that's because too many people started to confuse articles posted by Onion as being a reflection of their personal beliefs instead of the parodies and satire that they are.
I was curious of seeing if pydantic was mentioned, thanks! We use most of the same tooling as you, I'm always interested in improving our tooling, would you be willing to share your mypy plug-ins names or maybe most useful tools for inspiration?
Is she? People couldnt afford to buy houses in the 1980s, which is why 40% of the population lived in council housing. High rates of home ownership are a generational anomaly, not the norm.
This is one of those long essays you come to the end of and wonder “What the hell was that?”

It’s entertaining but what does it even say? Books need commitment and mental labor and most people on a podcast tour or radio tour never even read the book, just the talking points? Some people read deeply and well? Having a conversation on the same set of talking points can be valuable even if you wrote an entire book on the same topic as the talking points? That’s probably the meat of the thing.

The riffs on books and video games and social media are less well developed. He’s trying to fit a book into an essay and it won’t go. The compression leaves you with a copy of the idea in the book so blurry you can’t see anything but the shape of what he’s trying to say.

And then there’s an annoying postscript that can be safely skipped. I wish he’d told us who the teenage Korean podcaster was. He sounds interesting.
> wool, which is also not very sustainable

This is a matter do be checked with some detail, since some position against wool have become vocal: wool is, as expected, biodegradable (though it may be subject to chemical treatments that ruin this property); wool is recyclable, both as fabric and as industrial-use material (e.g. as an insulant); as a material for clothing, the excellent properties relative to the other options include durability (which of course - though nowadays the full importance of durability seems to be a neglected idea - reduces environmental impact); processes for the production of wool may entail some impact, independent from the material but related to the sheep.

One summary: https://thinkofthepandas.com/2022/01/13/is-wool-eco-friendly...
It will work the same if the microcontroller is an Attiny48 and the ICSP header pins are exposed.
Yes. My answer was to walk away from the tech industry and culture and do part time IT work for my buddy's law firm whilst writing code in my spare time for fun and recovering from my stress-induced triple heart bypass.

I make about as much as a Starbucks assistant manager, though, so your mileage may vary. :-D
Yep, though this is Israel... Still I think both could well be correct.
Yes, most of the HEPA air purifiers are trash, offered like as a "subscription service" due to the large cost and short lifespan (6 months in average) of the filters.
But there are other options like Sharp KCA50EUW [0] with an advertised filter life span of up to 10 years. A more trendy and smart offering is Electrolux PA91-404DG, albeit it has a shorter filter lifespan (could not find the number now but if my memory is right then it's 2 years).

[0] https://sharphome.eu/en/sharp/airpurifierhumidifier/en-kc-a5...
A book isn't backlit either, but that's not a problem, is it? The type of display used in the Playdate (Sharp memory LCD) is highly reflective and has very high contrast.
RE chargebacks: stolen cards are often monetized these days with a scheme known as "triangle fraud". Here's how it works:

0) the scammer somehow acquires Person A's credit card info

1) the scammer sets up an online store on Amazon or similar and sells some popular item at a 20% discount (eg Nespresso pods)

2) the scammer doesn't actually have that item in stock, but when they get an order from Person B, they use the stolen card to place another order with a legitimate seller and set the destination address to Person B's address (basically drop-shipping but where the victim is paying for the cost of the goods being sold)

3) Now the scammer has received already-laundered clean money from an online transaction, and Person B got the product they wanted on-time and at a steep discount. They're happy, and certainly won't be complaining to their credit card company.

4) when Person A reports their card stolen and tries to perform a chargeback, the legitimate seller who acted as an unwitting drop-shipper ends up eating the cost.
I disagree on the term limit topic.

Democracies benefit from change. Indeed I would argue that cadre change is their kill app. But it must be happening.

The same top politician will employ the same ministers, consultants etc., thus slowly creating an ossifying structure that aggregates a lot of mistakes of the same type. It is a process that reminds me of inbreeding in biology. Small pathologies slowly become more pronounced.

As we live longer and longer, we run into a risk that our Senates etc. will turn into gerontocracies of 80+ year old people and that a typical intern will be fifty.
> people who use hints seldom report the query problem to the project

This statement is shockingly user-hostile and paints the users overall as selfish and uninterested in the improvement of the postgresql project. Certainly some users will use their hint and go home, but you can't know that this would result in a net decrease in performance reports. Maybe with hints different users would be empowered to submit more reports like "The query planner creates a slow plan for query X, I know because when I use hint Z it's faster". Not implementing hints just to spite selfish users while ignoring the potential additional reports submitted by different caring users is shortsighted and antisocial.

Maybe there are a bunch of good reasons why hints should not be implemented, but this is not one of them.

My past commentary: https://news.ycombinator.com/item?id=29987139
I.e., expensive.

US got 15,000 tons of massively subsidized fuel processed from Soviet bombs.
> Netflix pays for connectivity just like consumers do.

Yes, Netfix pays their ISP. They should never need to pay the customer's ISP. Peering should be cost neutral. ISPs shouldn't be allowed to double dip.
> regularly maxes out his credit card so he can pay it all down and rake in the score bump

Does it really?

I have a very high credit score but putting a large charge on one credit card (nowhere close to maxing it out though) dramatically drops my credit score for one month until I pay it off in full at the end of the month.

I pay my child's tuition in full for the year each August (school in California is way too expensive so it's a lot of money, but that's a different topic). I put it on the credit card to get some cash back. My credit score drops by about 150 points right away. Once I get the bill at the end of the cycle and pay it off, the credit score goes right back to where it was before. I don't get any bump though.
That sharp one is something I've missed and it also does Ionization, impressive lifetime, thanks for sharing that.
For an article about book promotion and tone of voice, the tone of voice sure did put me off buying the book.
Me too. I believe the effect contains a logical recursion that is impossible to escape from. Maybe the randomness variable in it? It looks as if all validations and refutations of it are always going to appear logical. I don't know what to call it or compare it with but it feels this must be documented as being a prime example of its category.
Boss: why did it take you 2 days to integrate lib-foo when it should have only taken hours?
Me:
Oooh, I hadn’t thought of sales. I always use support@server whenever a site asks if I want to join their newsletter.
Thank you for so much detailed advice! I’m sure this will be valuable to reference as I dive in
> Then I realized it was an Onion story.

From the looks of it, indeed too many people are still being fooled by Onion stories.
oh! TIL. Thanks for that.

I feel like this isn't widely known
You can also just change the timestamp of your commits
Someone decided to start a weed business in Spokane Washington using my gmail address as their business email contact for all of the greenery suppliers. Now I get tons and tons of marijuana-related spam. I guess they are too stoned to tell the difference between 20 and twenty? I don't know.
Correctness in Python is all about unit tests - if you don't bother with them then you're playing with fire (and of course I often "play with fire").

Type hints .... well they help the IDE to autocomplete which is great. They also help you to get the order of parameters in a function/method call correct which is useful if the parameters aren't all the same type!

I converted a medium sized project to type hinting once. The original author wrote no tests and obviously didn't design it to be testable so I was looking for some small way to make it less horrendously unmaintainable. Every test run of the source took hours and there would be some trivial syntax error or whatever right at the end.

Type hints weren't so difficult and I hoped that they would "staunch the bleeding" while I tried to get it into testable shape. In this case they did almost nothing - didn't help me stop a single bug - probably because most types were "str" but that's not the fault of the hinting system as an idea, right? It's just an unprofitable load of work in particular situations.

Static typing fans are always going to be disappointed by Python and it's great because there are other languages for them. For the rest of us we can use them where it turns out to be profitable to us.

Unit tests are, however, by 1000x, more important.
Celebrating 13 Years of Longreads
How I made a 90s version of my landing page
The author of this article is sort of expanding it on twitter:

https://twitter.com/mattsheehan88/status/151724587067212595

I don't know if the author picked the subtitle of the article:

"What Washington Can Learn From Beijing About Investing in Tech"

Or an editor did it?

As it reads, it is kind of tragic. Because what can Washington do? Other than make matters worse for the US; because at this point the policy response seems to be a strictly adverserial one: sanctions, harsh rhetorics, have the FBI chase Chinese students and researchers ...

All policies that deprive the US of its single biggest advantage: That US tech companies and research institutions are extremely attractive to work for and thus suck talent from all over the world including China.
An online drinks shop here in Switzerland. I sent them an email asking WTF, but no answer. Still not sure if it was malicious by them or someone else. Haven't used them since.

Aside from that, I'm guessing it's mostly my Git commits on GitHub being the source.
I don't get a lot of spam but those that I do are to ye olde addresses. Think monster, orkut, and myspace. The vast majority come to a postgres mailing list address I sent one mail to, about ten years ago. A few to whois contacts on domains, before I signed up for the anonymous service. Guessing all those were allowed to be scraped by spammers.

I get a few others to an apartment building I once got on a mailing list to, and other random stuff like that. Probably folks that use Windows and got worms.

In short, I don't think anyone sold me out... but I could be wrong.
In my case it's the opposite - SQL is perfectly readable and fits my mental model while the project you linked feels awkward and hard to read.

However, it's good to have options, I wonder if prql will get traction. It would be great if it did.
I cannot check right now owing to time constraints, but I can tell you that in the past few months a comparatively large number of studies seem to have emerged.

One article I met earlier in the year was about creating systems to tag microplastic, in order to follow its path: https://news.ycombinator.com/item?id=30020879 ("New measuring method reveals there may be more plastic “on” than “in” your salad" (phys.org))
Just as a heads up, Zillow will ban your account if you use zillow@domain for violating their terms. Happened to me in March 2021.
According to discussions on the Gentoo [1] and Fedora [2] forums, i686 without SSE2 could be broken in some packages in subtle ways. One is that the stack alignment changed from 4 bytes to 16 bytes, another is long NOPs, another is that some software seems to require SSE2 on i686 like rustc or qt.

Even those platforms that claim to build for i686, I’m not sure if everything works correctly on pre-SSE2 (Pentium Pro, Pentium III, older Pentium 4) CPUs. And I don’t think any of the Linux distributions will actually run on a i386, i486 or i586 as i686 is almost required to have multithreading without busy waits.

The BSDs I don’t know about, but it’s a fair number of distributions that seem to support older x86 CPUs you posted. I didn’t know there would be so many. I couldn’t find Linux Mint though.

[1]: https://forums.gentoo.org/viewtopic-t-1087434.html?sid=4b682...
[2]: https://lists.fedoraproject.org/archives/list/devel@lists.fe...
Do you read the terms of service?
Just to backup the source the other commentor provided, here's 3 more "prominent conservatives" as you wanted -
The Republican attorneys general of Texas, Arkansas, and Nebraska want for the federal repeal of net neutrality to preempt states from enacting their own net neutrality rules -- https://arstechnica.com/tech-policy/2018/10/fcc-quest-to-kil...
> Correctness in Python is all about unit tests - if you don't bother with them then you're playing with fire (and of course I often "play with fire").

But Python does support type hints, and tools like MyPy do use those type hints to evaluate correctness. It seems to me that Python's type hints are indeed Python's way to check for correctness.

Also, unit tests don't verify correctness. They only serve to check whatever small set of ad-hoc invariant developers put up.
A conman has all the time in the world to lay down a path for their marks to follow. They can hone their process over time and have the benefit of running the same scan over and over to improve it. A mark has a single moment to react to these well laid plans, a moment in which they can be distracted and not thinking in a security context. There is a scale of conman skill vs mark awareness but pretty much anyone could fall for a con given the right situation.

For those disparaging this person's job title of security engineer: an engineer dealing with network security of IP traffic is a different skillset from a security consultant advising on human involved phishing attempts & cons. The context also matters here. Being on your computer & working on network security, looking for threats, is a very different and incomparable situation from being in the park living your non-work life and getting a call from the bank.
My answer was written with the intention of helping others and sharing my knowledge with fellow engineers, I enjoy talking about tech and engineering and even thinking of writing a blog post about it.
Real men don’t play, obviously .
First person to have Covid infection for more than a year identified in UK
> Naw, my family and I, including two young children...

One of your arguments against red meat is that it's devastating to the environment. You know what is also devastating to the environment? having children. It's not a necessity to have children, I have none.

Why is your need for breeding more acceptable than my need for eating red meat?
> we had net neutrality for years and it never improved the reach of broadband into rural areas

The issue there isn't net neutrality but rather open access. Countries with affordable internet generally have open access requirements for network operators.

Net neutrality is a separate issue to do with ISPs attempting to double dip, leveraging a large customer base in order to do so.
Calorie Restriction with or Without Time-Restricted Eating in Weight Loss
We ended up with that disruption anyway because the foreign companies Thatcher gifted the market to, NTL and Telewest had to dig up the roads to lay their low-tech coax.
> use with a merge statement in order to get an atomic upsert - holdlock in sql server

Because of all the potential edge cases that MERGE didn't handle properly when introduced to SQL Server (2008?), I've avoided its use. Despite several revisions over the years there are apparently still significant behaviours that I'd consider bugs¹, some of which have been closed as WONTFIX² so are a fact of life you just have to accept if you use MERGE in SQL Server.

[1] see https://sqlsunday.com/2021/05/04/how-merge-can-deadlock-you/ & https://michaeljswart.com/2021/08/what-to-avoid-if-you-want-... and many other similar articles

[2] https://www.mssqltips.com/sqlservertip/3074/use-caution-with...
Takes more time to request it to the server and loading it in the browser than downloading the resource :)
Low wages is a problem that will fix itself. When there was a shortage of truck drivers, wages for truck drivers went up.

That’s how a market economy works. If there aren’t enough people willing to do a job, then wages for that job will go up until there are.
Unfortunately it wouldn't even look anything like that. "The algorithm" is probably a bunch of ML with some shitty product driven hacks on top, and those hacks will be trivial to game. Things like "if follower_count > X: spam_model_weight *= 0.1"
once again HN demonstrates how much it does not know anything . he does not need to own 100% , 51% is well and good. musk + jack + ark invest + JPM already have 25% they need to get the other 26% which should be very achievable with tesla stock . All SEC fillings aside this is pretty much a done deal .
The same (and only) way you’d reasonably be able to do it in any other language that uses a series of text files for an input.

File by file.
REvil resurrected? Ransomware crew appears to be back. Keyword: Appears
The section on how union & intersection types behave with interfaces (rather than primitives) has them flipped: a union of interfaces will allow access to only the intersection of the fields/methods of all the types (unless you do the work to distinguish between which type you're working with), while an intersection will allow access to the union of the fields/methods of the composed types.

i.e. `ICat | IDog` will only allow `pet.eat()`, and `ICat & IDog` will allow `pet.eat()`, `pet.meow()`, and `pet.bark()`.

Good article otherwise, though. The explanation of top/bottom types was more intuitive than most attempts.
I talked to a used washing machine purchaser who quoted what my washing machine that was used for 2-3 years would be worth. (spoiler alert: not much at all, you're better off buying used)
He told me to check out how unreliable Whirlpool washers are, check it out: https://www.designnews.com/corrosion-outbreak-whirlpool-mach...
"Open sourcing" the algorithm to a public platform will be very interesting... but even getting Twitter out of influence of foreign agents, whether they are bots [1], the 50 cent army [2] or powerful foreign state-level actors [3] will be a good start for Twitter.

[1] https://twitter.com/johnkrausphotos/status/15172153497243525...

[2] https://www.washingtonpost.com/news/monkey-cage/wp/2016/05/1...

[3] https://twitter.com/Alwaleed_Talal/status/151461595698675712...
> And this tracks for most skills. How good are you at tying your shoes? Probably average?

In fact, this is pretty much what the Dunning-Kruger graphs look like. The article shows the one for humor which has the bottom quartile participants answer "eh, about average" while the top quarter of participants realize they're better than average, but estimate roughly 75-percentile rather than 87.5-percentile.
A lawyer in Texas has the same initials as I. Their domain is the same as mine + "law" at the end. Guess how many of her clients forget the "law"?
> The worst part is the high degree of censorship. Everyone is so sensitive now that it's impossible to speak openly

What would you say if you weren't censored?
You can't just claim that switching from corn and soy to a wide range of other vegetables would make things worse with no argument. If nothing else this goes against basic common sense because (1) we eat more than two vegetables, and (2) people eating vegetables directly instead of feeding those vegetables to animals is a vastly more efficient way to feed a population.

The absolute best case scenario for your argument is that monocropping turns out to be just as bad under a shift-to-vegetables model, but in that case we still end up reaping enormous environmental wins. Just because vegetables might not (?) solve the monocropping problem doesn't mean that we don't have good reasons to switch to them, as was originally argued. I'm not really sure how you avoid that, and frankly, the number of large scale climate change studies urging a shift to our diets seems to bode poorly for attempts to push this line.
I think they don’t want the tile server API have to think about what planet it’s on and where said planet has its oceans. So every tile has to have a valid image associated with it.