skysight-inc/HackerNews huggingface dataset:
At least in our case, it comes down to expectations.

For the `IN` query the DB doesn't know how many elements are in the list. In MSSQL, it would default to assuming "well, probably a short list" which blows out performance when that's not the case.

When you first insert into the temp table, the DB can reasonably say "Oh, this table has n elements" and switch the query plan accordingly.

In addition, you can throw an index on the temp table which can also improve performance. Assuming the table you are querying against is indexed on ID, when you have another table with IDs that are indexed it doesn't have to assume random access as it pulls out each id. (Effectively, it just has to navigate the tree nodes in order rather than needing to do a full look into the tree).
> A prior poster made a claim that they can read a file into memory, and that it won’t actually use any additional memory because the kernel will “automatically take care” of it somehow. This is plainly false.

Nobody made that claim except in your head.

Why don't you read it now:

Just curious: why would you not load the entire dataset "into memory" ("into memory" from a Python perspective)?

Look carefully: There's no mention of the word file. For all you or I know the programmer is imagining something like this:

>>> data=loaddata("https://...")

Or perhaps it's an S3 bucket. There is no file, only the data set. That's more or less exactly what I do.

On an average desktop/server system the OS would automatically take care of putting whatever fits in RAM and the rest on disk.

You know exactly this what is meant by swap: We just confirmed that. And you know it is enabled on every average desktop server system, because you

> Swap is disabled on my system

are the sort of person who disables the average configuration! Can you not see you aren't arguing with anything but your own fantasies?

> If I “just downloaded it from the network”, it’s on-disk.

That's nonsense. It's in ram. That's the block cache you were just talking about.

> If I mmap() the disk contents, there’s no copy going on, it’s “mapped” to disk

Every word of that is nonsense. The disk is attached to a serial bus. Even if you're using fancy nvme "disks" there's a queue that operates in a (reasonably) serial fashion. The reason mmap() is referred to zero-copy is because it can reuse the block cache if it has been recently downloaded -- but if the data is paged out, there is absolutely a copy and it's more expensive than just read() by a long way.

> Even if it wasn’t, I’d only have so much of it. Even if I had a ton of it, read()’ing 100GB of data and relying on swap to save me is going to grind the rest of the system to a halt as the kernel tries to make room for it

You only have so much storage, this is life, but I can tell you as someone who does operate a 1tb of ram machine that downloads 300gb of logfiles every day, read() and write() work just fine -- I just can't speak for python (or why python people don't do it) because i don't like python.
Every time I start to think HN might be getting better, comments like this still get to the top.

Folks, if you don't like the story, just downvote it. It'll go down in the rankings and you won't have to see it again!
> Double-decker cars are significantly more common in continental Europe.

And west of Chicago in the US. Amtrak runs double-decker cars west of Chicago and in fact Chicago's passenger rail service (Metra) is mostly (all?) double-decker.

My understanding is that tunnel clearance in the east is not sufficient for the double-decker cars.

I also see containers stacked two high and auto carriers that appear to be similar height and these probably also don't travel east in the US for the same reason.
Not a big Twitter/X user, I hadn't noticed they stopped previewing titles. That seems odd, googling for what is behind it, the headline is "X stops showing headlines because Elon Musk thinks it will make posts look better", okay then.
It does contain copies of copyrighted works.
what are you even on about? are you complaining about sites that use JS?

I have nothing to do with mastedon, nor do I have an account. If you want an ASCII version, make it yourself, I could care less

everyone can read the discussion, still not sure what you are talking about
I don't think the article made that conclusion? I see this in there:

> As seen in the benchmarks, the current Rust standard library unstable sort implementation outperforms the C++ standard library counterparts

And I can't find any generalizations like that from the author, though I may have missed it.
I remember when my previous place was looking into Dynamics as an option for the company it seemed like it would be very much easier to deploy various Dynamics-adjacent bits to Azure, and we didn't want to be multi-cloud so this was a minor detractor for us.

M365 to Azure is a bit more of a jump maybe, but there's AAD which I think is a bit of an on-ramp? Then I gather Excel is getting better at integrating with the data products on Azure? I think there's something there, enough to make Azure the path of least resistance for some orgs.
more importantly, where does my computer let the time go?
Show HN: Image App AI Card Battler
Find an opponent, name card, generate AI image via prompt (stable diffusion), create attack, BATTLE !

v1, let us know thoughts
Length is then not an argument against always using Ed448 over Ed25519.
can we just move on from C/C++ already
What is it with these comments? I'm not sending you a "damned" newsletter, go complain to someone else. Emails from my server are either my personal emails, or from one of various websites/tools which can send you emails, for example to notify you of when a player you chose to follow uploaded a new level, when the local river is exceptionally low or rising sharply or whatnot, when security updates were applied... thing that you asked to receive.

I'm sorry if you're as pissed off about marketing garbage as I am but I am not your problem.

At least to hobbyist services like mine, by hitting spam and not using the proper unsubscribe mechanism on emails that are not spam by any definition, it becomes very hard to run these things and not have a quarter of the people (particularly on google services) complain they don't receive the requested email. They assume the problem lies with me because google couldn't possibly ever make a mistake, they're too big for that and clearly it works for everyone else (yeah, everyone else runs commercial services and either indirectly contracts or employs people whose full-time job it is to make sure that sent emails dance to the tune of a few big providers)
that's pretty much how CUDA was born 15 years ago. Crazy how a few guys playing with shaders to simulate clouds led to the AI craze we have today.

Look up Mark Harris PhD thesis "Real-Time Cloud Simulation and Rendering" for more details.
A Dyson sphere wouldn't cause the star to significantly brighten and then wink out all at once.
Javadoc.io Is Down
Both links reference the same source material — "Table 16: Side-by-Side Comparison of function points and lines of code metrics"

Seems like a comparison of Smalltalk using an IDE and Java using Notepad?

Not really credible is it.
Well, isn't it the sense of CRDTs that you don't see them? I mean, traditionally users are asked what the system should once it finds a lock, but with CRDTs they should never find a lock and therefore the user isn't bothered.
Sometimes a webpage just wants to have a bunch of images, which is not a bad thing, and something like this helps it load better.

> It’s great Netflix and friends can stream content efficiently.

This barely affects streaming. Streams work fine with a single TCP connection.
Sorry, but you are just assuming that the borrow checker is an authority of safety, when, even stated by rust lang developers, it is not.

The borrow checker is known to be far in to “overly cautious” territory.
People are generally more cognizant of the harms caused by the tech industry than they were even a few years ago.
Are you trolling? How do you expect people to troubleshoot your OS problem when they don't even know what hardware it is running on?
Great Interactive Simulations here: https://www1.grc.nasa.gov/beginners-guide-to-aeronautics/bga...
Ok, so you recirculate exhaust into the combustion chamber and inject new fuel.

Now what? It doesn't burn, since there is no oxidizer. The only way is to inject some. And since you don't want nitrogen, you can't inject air. So you inject pure oxygen, or something like peroxide?

Sounds expensive.
And then the bleeding hearts bled, and pleaded for me to wander down another path.

> Google: neuralink federal investigation

> Dec 2022, pigs and sheep died, no explanation of how, no explanation of to what purpose, no discussion of what law or ethic was broken.

> Feb 2023, contaminated hardware shipped improperly

Can you please cite anything specific? All I want is an instance of some animal being butchered; not by some bureaucratic corporate mistake; not by some individual slip, but by actually evil behavior or causing unnecessary pain to an animal.

How is everyone crying so hard when there is essentially no information of what actually happened? 60 pigs died- ok, how and why?
Literally the second paragraph :

“ Overall no correlation between performance and safety could be found, nor whether safe or unsafe internal abstractions are used.”
I agree. It absolutely is IPv4. Hosts could use DHCPv6 with prefix delegation (DHCPv6-PD), and use that delegated /64 for its internal Docker bridge and get rid of NAT. And yes, you can still have your Netfilters stateful packet filtering in place! People are going through so much pain because they won't embrace the tools IPv6 gives you! This solution is 20 years old. God help you if your network is actually using 172.17.0.0/16. grumble grumble get off my lawn, kids.
From what I understand an actual Dyson shell completely covering a star is probably out of reach of even such a civilization. Would a
Dyson swarm make the star disappear?
>a bug causing the CPU to waste additional cycles in a specific set of circumstances

It's called modern software
It's not just cats; I think humans are capable of much of the same but we actively suppress it for $reasons.

Any time I have an alarm in the middle of the night for any random hh:mm, after just a few days of the same pattern I will naturally wake up exactly 1 or 2 minutes before the alarm as my internal clock knows what to expect. If I ignore it out of laziness and go back to sleep until the alarm rings (literally a minute later) I can break the habit but if I embrace it, it is really accurate and reliable (though thrown off if I went to bed absolutely exhausted, so there are limits as one would naturally expect).
There are circadian rhythm genes in c. elegans that take effect even when under artificial light. Also the skill for this is trainable.

At school we used to have a bell mark class ends and without a clock or a watch I could predictably tell when the bell would fire. One time I demonstrated this to a friend (both of us kicked out of class) by counting down from 10 on the second to when the bell rang while looking at a blank wall.

Strange. But nonetheless true.
Round-trip time.
They are creatures of habit
The problem with Framework is that BIOS updates are really rare. I been running the 3.0.6-beta for my 12th gen for almost 8 months I think and the full release has yet to come. I bet it will never happen as they are focusing on AMD and 13th gen + 16" one at the moment.
More evidence that humans were in North America over 20k years ago
Also, one of the pictures in the article, and apparently "one of her more popular posts" is this: https://twitter.com/NicoleKelner/status/1589748415130664960

The claim is that using a two-stroke leaf blower for 30 minutes produces as many hydrocarbon emissions as driving a pick-up truck from Texas to Alaska. Clearly she has never actually thought about the logistics of this!

The shortest route I could find on Google Maps was from Dumas, TX to Metlakatla, AK at around 2500 miles. I drive a car in the UK, but that would be probably 200L or more (or 100 gallons for US folk) and even more for a truck. There's no way that ANY leaf blower gets through 3 gallons of fuel a minute! In fact, google tells me that a typical leaf blower uses 0.43 gallons per hour. So driving a truck will use approximately 500 times as much.

I'm concerned about climate change, but making completely ridiculous claims like this, even if they are pretty watercolours, isn't helping the cause - especially when it's immediately obvious that it's nonsense!
Have you played any of the games for it?
In this case it was done in Austria, and on excised larynges of postmortem pets.

> The animals’ owners gave their explicit consent for the larynges to be investigated postmortem.
This is why I bought a https://frame.work and am a happy customer. Will do business with them again
Any more info/sources, or only assurances from EVa5I7bHFq9mnYK?
cat law sounds hard. cat lawyers must make a fortune litigating in cat court
No. /s
Even Mozilla's telemetry is encrypted, so private.
I think the submission link is wrong?
b) and 2) is my bet.
The worst is when you have a passion that you love, but it turns into a job you hate.
Maybe my point got lost within the threads but I never said types aren't useful or that we should reject them at all. After all, what you said is true. Whether we want it or not, everything is "typed" in one way or another.

My issue is a practical one. Using limited typed languages like TS has several drawbacks for little benefit. Using a strongly typed language like Haskell would add a ton of greatly needed rigor and correctness, but it's also not without huge drawbacks. Same goes for dynamic languages.

It's not a question of whether or not we should model our software based on our worldly types, it's about how strict we should be about it and the benefits and drawbacks that come within this spectrum. For that reason I argue there's no single general answer to this and claiming there is one is nonsense.
Oh, I already have implemented something[0] like that. It doesn't need lambdas or anything "cloud scale" like that. You "just" need a few dozen to a hundred IP addresses assigned to one machine and run a multi-homed DHT node on that to passively observe traffic from multiple points in the keyspace.

But neither of these approaches is what I'd call a "super simple DHT crawler CLI tool" that the initial comment was asking about. BEP51 is intended to make crawling simple enough that it can run on a single home internet connection, but a proper implementation still isn't trivial.

[0] https://github.com/the8472/mldht
This reminds me of a job I once had that was about 50% travel; the company required employees to charge travel expenses to their personal credit cards, saying they would be reimbursed. The company consistently dragged its feet on the reimbursement, sometimes for several months. They scrutinized reported expenses to an absurd level, or simply refused to pay. I once had a layover on a flight (because the company required the least expensive flight, which was generally not direct) that was cancelled. I was stuck in Denver for 9 hours, waiting for an available flight. I got something to eat and reported it as a travel expense. Denied; I was told the expense didn't occur in the city where I was working, so it was personal, not business-related. A colleague had her credit card maxed with business travel charges, and could only afford to make the minimum payment for several months. She requested the company pay the interest on the carried charges. Take a guess how that went? Denied. She ended up quitting, and last I heard the company refused to reimburse her because she was no longer an employee. I ended up quitting, too. But yeah, this article reminded me of that situation. When it's known that you're basically powerless to collect on a debt, you can expect to get screwed.
Hotels always offer worse rates offline than online
I estimate 50% success. I find it more successful when emailing the sales person, or the manager directly.
I'm not spending $1k just to prove a point
I was in the same camp. After hearing glowing reviews from that one guy, I was expecting something harmonious and was willing to give MS another chance. After a few days, I lowered my expectations to "usable by everyone," like Windows is. Now I don't think it's that either.
upvoted : absolutely well said.
Oldest footprints in North America push back human arrival
> I have to ask, why use 3rd party booking sites at all? From what I can tell, the prices are usually the same as the hotel... needlessly adding middlemen into the booking process.

It can be worse. I once called the hotel and didnt realize I was calling Hotels.com (which used a tricky website to make it seem like I was calling the hotel.)

Worse, the [Hotels.com] agent pretended to be a the hotel reservation desk. I gave him several discount codes (my consulting company code, my AAA code) and each time he said it wasnt reducing the price. That got me suspicious...because my consulting company Accenture always had discounts.

So I asked the person outright, "do you work for the hotel, which company do you work for, etc" and learned he was a Hotels.com employee.

Based on this, i'd note that Hotels.com might not be the same price but might actually even be more expensive that booking direct with the hotel.
I don’t think anyone is using any google products should still be concerned about privacy or tracking their activities, it’s like using Facebook, these companies business is built around mining your/users data, stop using them.
Almost 30 years ago, I attended a college prep high school in Santa Clara County that allegedly removed all of the lockers because of pipe bomb explosions in the 1970's. The safety rationale was "lockers plus bombs equals shrapnel." The concrete footings for the lockers were still present throughout the school's outdoor halls. The campus was completely open and each classroom was a free-standing building.
And for a lot of people who do have a passion, turning it into the nine to five kind of ruins it. I think it's a pretty rare sort of person who can really love their job for a long time.
Naturally. Not only are the US chip makers losing the World's largest market for their products, they can see that the Chinese will now not stop in their forced building of a semiconductor industry from scratch.

The US chip makers know it's now too late. And can see their doom rapidly approaching.

Politicians should be forbidden to interfere in business.
Looks interesting. Do you have visualizations or examples on debugging audio embeddings (like https://huggingface.co/spaces/facebook/MusicGen) ?
Ask HN: What's a new developer tool you recently started using?
I always like learning about new tools and never know what I'm missing out on. Share some tools you've recently started using.
That's an interesting example because it illustrates out how fair use is in part defined by its effect on the market.

A teacher copying a New York Times article verbatim and distributing it to a classroom for the purpose of analysis or criticism is likely to be held by the courts as fair use. On the other hand a teacher photocopying an entire textbook (or distributing a PDF) would probably not be considered fair use.

Both are copying educational material in full, but they have a different impact on the market. Distributing copies of an old news article to 30 students realistically isn't a direct substitute for 30 subscriptions to The New York Times. But a textbook publisher's business model specifically revolves around selling its textbooks to students - the teacher is distributing their copyrighted material to their target market and removing any incentive for the students to pay the publisher.
Probably Life of Pi by Yann Martel.

The message of choosing the better story is at the heart of the book, and I apply it in so many areas of my life.
I live about 100 yards from the Union Pacific mail east/west line out of Chicago and we see a great variety of freight cars, but I cannot recall the last time I saw a stock car. I guess that's because the Chicago stock yards no longer exist except as a neighborhood.

The only passenger cars this like carries are the Metra double-deckers (except for the very occasional heritage trail such as the Big Boy entourage.) Amtrak uses the BNSF rails a few miles from here.
You could replace Rust for almost any language in that assertion and it would be true, so it would be good to clarify that Rust does not trail of behind C much, and it's even faster than C on 4 out of 14 tests.
Locking `Body` Scroll for Modals on iOS
Yes 600W are enough, but I once had a 1750W microwave and it was luxurious and ridiculously fast at warming. I would pop a bad of popcorn in like 30 seconds, or warm up a slice of pizza in 15 seconds. Makes me think like the difference between a Camaro and a Geo Metro
If you hadnt typed "15" twice, i would have thought you typoed "51% attack".

To the ones like me, who dont know. Here is an explanation.

https://engineering.cmu.edu/thailand/_files/documents/tendri...

Edit: I am not sure if the PDF really describes the attack you mean. Could you uncrypto please?
Crazy story that someone at the local radio astronomy observatory told me.

Context: Radio observatories need to minimize as much radio interference as possible. Typically, they are some distance away from population, and people are asked not to use phones within a couple of km of them. Inside the premises no unshielded electronics are allowed. If any are used, you can immediately see the effects on the data being collected by the telescope.

Anyway, these guys were getting some sort of strong interference signal at 4 pm every day. They could not figure out where it was coming from. They eventually decided that it was not coming from within, but from somewhere outside the observatory. They got some triangulation equipment out and over the course of several days, finally determined that the signal was coming from a house a couple of km away.

So they went over and knocked. Asked the owner what was going on. Turned out, the guy had a electric can opener, and every day at 4 pm he would open a can to feed his dogs. That was the interference signal they were getting all the way to the observatory!

Eventually, after some back and forth, they got the guy a new can opener they had vetted to not cause an interference signal.
I just hate all the dark patterns that create feeling of scarcity.
You can do a chargeback, but Booking.com bans you after - even if it is completely their fault
>To me the Results across all tested implementations is indicative of a pervasive mindset in the C and C++ world, that argues it's the users responsibility to be careful, even if that has been proven impossible at scale.

I mean, even if the sort function is implemented in such a way that it's impossible to use it incorrectly, the user is still programming in C/++. Yes, all else being equal, the harder it is to introduce bugs the better, but if the user is not careful they will shoot themselves in the foot one way or another.
This is a job for a chargeback from your credit card company.
I predict to you that demand for shares in emerging country currency in exchange for real goods will be low, and that no country will ever get rich by this method, because none ever has. As for system dynamics, I don't know about it - maybe it's great. But I do know a little economics, and a glance at NBER reveals very many deeply practical applications from unemployment to inequality to supply chains to sexual harassment: https://www.nber.org/papers?page=1&perPage=50&sortBy=public_.... So I'll repeat my point: do you know economics? If not, what makes you so confident to pontificate about it?
You made my week, I think this is my favorite piece of writing in a while.

"A little kid on a tricycle with a squirtgun filled with HYDROCHLORIC ACID. "
That seems to be just metadata about metadata.

Where do you go to actually find the Classifications or Subject Headings themselves, in whatever format?