skysight-inc/HackerNews huggingface dataset:
Here's an example implementation in MSSQL - https://data.stackexchange.com/stackoverflow/query/edit/1873...

No need to filter within the window function if you use subquery or CTE, which is supported everywhere.
We shiv all the dependencies into a single file, bake it into a Docker layer, and refer to it in each scripts shebang.
Why don't you place the blame on the company who knew the rules and made a mistake?

I, as someone with an allergy, am grateful for the "faceless" people who show up every day for an unglamorous job and keep me alive.
My guess is that as a queer person, scarecrowbob gets regularly exposed to opinions that rise far beyond a mere difference of belief, and looks more like perpetual small doses of unmoderateable hatred. People who are willing to say that queer people are "literally demonic", for example, are not really offering some kind of thoughtful argument that queer people need to be engaging. But this toxicity is often expressed in ways that platforms are unable, or unwilling, to stop.
Mastodon allows you move instances with minimal effort. You can redirect your old profile to the new one in another instance, or permanently move it keeping your follows and followers.

No one there wants to hold your information hostage, you can always export it, and while it doesn't support importing, you can repost it through their API if you really want to.

https://docs.joinmastodon.org/user/moving/
Why does HN have a black line at the top of the page?
This morning I have begun seeing a black line at the top of every page of HN:

https://i.imgur.com/pFBvufs.png

Is this a bug or a protest / statement of somekind that I have no context on?
What's the tech stack? I assume you're doing quite a bit of scraping.
I've never understood the saying "the exception that proves the rule" until now. Possibly one of the greatest runs in game company history?
Better eliminate all other coal-burning as fast as possible, then, to minimize the damage done while the hydrogen-based steelmaking industry grows up.
JEP 496: Quantum-Resistant Module-Lattice-Based Key Encapsulation Mechanism
Yes, so if you were to encounter this butter in the wild, I understand that not seeing the label would throw you off.

But in this particular case, in order to comply with the instructions telling you to throw the butter away, you need to know that this is the butter you bought that actually contains milk but isn't labeled so.

The very act of noticing that the butter doesn't have the right label tells you that it contains milk.
https://en.wikipedia.org/wiki/SQL?useskin=vector#Standardiza...

According to wikipedia, windowing was standardized back in 2003.
-- "find the maximum value of 'views',
-- where 'sales' is greater than its mean, per 'id'".

select max(views), id -- "find the maximum value of 'views',
from example_table as et
where exists
(
SELECT *
FROM
(
SELECT id, avg(sales) as mean_sales
FROM example_table
GROUP by id
) as f --
where et.sales > f.mean_sales -- where 'sales' is greater than its mean
and et.id = f.id
)
group by id; -- per 'id'".
Does this article have a (2002) that I missed or something?
I think you can but you will get no interaction. No one (relatively, not literally) cares about “nice” or informative - they care about things that make them angry or otherwise emotive.

I’d also add that no one (again, relatively) reads anything, anymore. A couple of paragraphs and you’ll see your engagement drop off a cliff. But a quick, “witty” slap? A stupid pun thread on Reddit? Easy money.

I think your point is generally right - not trying to disagree, but I think these platforms are simply effective tools to mirror back their users and what their users want, rather than the inherent, specific problem themselves. That is, it’s not Twitter that’s the problem - it’s that Twitter users really like the behaviors Twitter rewards.
China is also massively building nuclear with 29 reactors being built in parallel.

Source: https://pris.iaea.org/pris/worldstatistics/underconstruction...
This sounds fun to play with and get feet wet in HDL, but it's only a lattice ice40, I have no idea what you'd seriously do with this. Usually ice40 are used as glue logic, or multiplexing/buffering a bunch of ADC/DAC chips so the processor can do large data transfers instead of a bunch of tiny ones.

The website claims hardware acceleration and... I doubt they got timing closure on the soft CPU at anything greater than 100MHz and you still have to get data to/from it at likely 30~40 MB/s via an SDMMC bus.
I dunno, I adjust climate and music frequently while driving. I have a Volvo now which requires touchscreen for those things, and I can't stand it. Otherwise a great car though.

After a while you "learn" to do it without looking at the screen too much. Nonetheless, it's far inferior to having tactile controls.
You might look into it to see if there’s something special about butter versus other oils/fats that may make butter specifically good for burns, but I understand that as keeping the air off of the burn, similarly to how oxygen tents work.
Doesn’t look like it —https://foundation.mozilla.org/en/blog/open-tech-advocacy-fo...
80k pounds of butter is being destroyed because the private company who made it could not be assed to do proper QA over a batch.

This isn't government overreach, this is a company trying to save money by doing less QA and getting bit for it.

THIS TIME it was caught, and handled, and the company is seeing a negative outcome for their lack of diligence in making OUR FOOD. What about next time? Maybe companies should be discouraged from lacking QA like this?
Um, the DOGE is rather a necessity about now.

The USA is ~$36 TRILLION in debt. Interest payments are now consuming ~20% of tax revenue...more than the defense budget. That's insane!

Musk is also absolutely correct about over-regulation and government bureaucracy stifling innovation and economic growth.

Then there's the amazing incompetence often displayed by the current admin... Witness Afghanistan, among many other examples.

Given a two party system, I can only think this election outcome was better than the alternative!
I’d want this as much as I used to enjoy open floor plan at the office… Discouraging 1:1 and private communication in my experience would actually have 100% opposite effect of what you are describing. This is equivalent to discouraging pair-programming which while may not be everyone’s cup of tea many find extremely productive
Simplest way = 5 * 5 * sqrt(5). But logarithms offer a more general approach. The math comes back fast. :-)
The Vivobook ARM from Asus also seems very decent, and it has a numpad.

Where I live, the T14s is also sold with 64GB memory. It's the cheapest VRAM around (although support for it is lacking everywhere).
> a $1M house bought with $100K down and $900K mortgage is a worse deal for the seller as compared to $500K down and $500K financed.

Do sellers in the US know how large your down payment is? AFAIK that's not a thing in Canada. Offers either have a financing condition, or don't. If the offer doesn't have a financing condition, the buyer might be paying cash. But they could just be trying to present an offer with better terms, gambling that they'll definitely find financing somewhere or the other.
Anything web platform has never been a new idea. Only evolutions from web technologies becoming more advanced.

Facebook is MySpace, Tumblr is live journal, reddit are forums and Discord is Skype.

It's all been done. Why create the new when you could recreate the old?

But yes; I to crave something new.

Can you think of anything new?
Actually interactive editing with ed saved my ass once on my FreeBSD server once. Somehow, my terminal driver (actually I actually used my vt520 even for emails at the time) was totally broken so I only had a single line. I actually managed to edit the settings file with ed to get things straight and do a reboot. However, if you know sed you should be able to handle. However, this was 2001 or so and I somehow doubt that I it will happen again ...
Off topic but I saw in a YouTube video how they suspect one of the earths greatest extinction events was partly driven by volcanic material igniting massive coal beds, the combination of the vulcanism and the coal burning killed like 90% of life on earth.
If you want a fun way to revisit the game but don't want to replay, the 50min "Developers React to 50 Minute Speedrun" is a ton of fun: https://www.youtube.com/watch?v=sK_PdwL5Y8g

It highlights some of the architectural decisions (and how players exploit them), and has gems such as one of the commentators having their entire section skipped by the speedrunner.
That's an easy way to dismiss all concerns, and backhanded also blame the ones complaining for "holding it wrong".

It's not about who I follow. It's about the replies I get when I participate in discussions around my interests.
The only reason people think "butter" may not contain milk is because we let advertizers abuse that term to refer to anything vaguely resembling that texture.
Lots of soccer moms driving Teslas in the Bay Area. Know several myself.
I am saying this rule is ridiculous, especially given the current situation.

I would agree with you more if it was not a product where Milk was the only ingredient.

This kind of bureaucratic action lacks common sense and protects no one. That's the kind of bureaucracy we don't need.
Seventy Years On, Why Godzilla Is the Darkest Monster Movie of Them All
It would be nice if it was again possible to run it in current Mac OS. The original Half life still lists Mac OS but with incompatible information (newer versions of Steam require recent versions, but HL only runs on old 32 bit OSX)
Since we're all giving replacements to this, nobody's mentioned my preferred one, so: use git add's patch mode. On a clean worktree, do the search/replace in bulk. Then use `git add --patch` to selectively add the good replacements and skip the bad ones. Finally, `git checkout -- .` to throw away all the bad ones. The nice part about this is that it's not much to remember. If you can make a global search and replace, and you can use `git add --patch` (which is useful loads of times), you can do a selective search and replace by combining them.

As far as this actual tool: the demo GIF is way too fast-paced to show what's going on. A better demo would maybe search "ring", have 10 or so results instead of pages and pages, and show how you can unselect "spring" matches which were unintentionally caught.
Try Jetbrains CLion
Judgment Need Issue from Human Lips
Your welcome, thank you for the message.
Nope. It's to form a barrier to keep bacteria out, with the downside that it also traps bacteria in.

Also, oxygen's a gas.
Feedback on My Teen-Focused Finance Manager App?
Hey HN :)

First time posting -I’m Zain, a 16-year-old developer building SimplyBudget, a finance management app aimed at helping teens track their spending, manage budgets, and develop smart money habits. The goal is to make financial literacy accessible and intuitive, with AI-driven features in the pipeline.

Would love to hear your thoughts on the concept, any feature suggestions, or advice from those who've built similar apps!

Currently also trying to figure out how to intigrate Plaid's API to link accounts for easier service, any feedback on how this would work, or ideas to make the app better?

Thanks in advance!
Unsalted butter is butter butter. It's the base form of butter with nothing added.

And peanuts in something that isn't obviously made of peanuts, of course. That's what allergen labels are for, nobody's arguing against that.

But you can't really mistake a bar of butter for anything else except margarine. And it you have a milk allergy, you're gonna make sure you know what the words are for butter vs. margarine, I should think?
I think you can only time travel a finite time.
I just wanted to look so I had context. Annual production of butter in the US is over 2,060,000,000 pounds.

These aren't new rules and are in place to literally save lives.

Are people really "sick and tired" of .003% of the butter being recalled? I feel like repeating "80,000 pounds" is attempting to appeal to emotion over the destruction of some mass quantity when in reality it's a rounding error.
Ask Git to Show a Method
A modern word document file (.docx) is literally just a Zip archive with a special folder structure, so unless your company is scanning word document contents I can’t imagine there’s any issue.
I take it you've never heard of Poe's Law?
What's really going to bake your noodle later is that Corn is a grass, just like Bamboo.

My total armchair answer: It helps to think about trees as just giant shrubs.

Shrubs are considered "woody", but most definitely are not trees. There are plenty of trees which are close relatives of shrubs (like poison oak and the urushi tree).

So what's the difference between a grass and a tree? Walking the tree of life up from Poison Oak and Bamboo, we see we land at Monocotyledon and Eudicots. There's lots of non-woody and tough fibrous (i.e. woody) plans in both clades (palm trees are monocots, btw).

Wikipedia says if it is tough and fibrous and has growth rings it's wood:

https://en.wikipedia.org/wiki/Wood

So Bamboo, although coming from a grass and not a tree, is wood. Further reading down that page talks about density as a key quality of wood, and goes on to not definitively quality bamboo as wood or as non-wood but some are dense enough.

Ultimately, there's no super clean definition of wood is my take-away, between the technical and colloquial aspects. You can use bamboo in construction much like wood, if you cut off a bit of shrub and dry it out, it's a "stick" just as much as if you trimmed it off a tree. You can make paper out of all kinds of fibers.
One hopeful note: the developers for the Snapdragon X Elite are active on the kernel mailing list, and they are supplying patches for specific laptops, including the T14s. Now I run Debian, so i don't use AppImages or Snaps or Flatpaks, but I expect to have a fully functional T14s Gen 6 running Trixie when it is released as stable next year, assuming Trixie uses kernel 6.12 or (hopefully) 6.13.
To add to bdjsiqoocwk pointing out the self-evident, in many jurisdictions you have both the right, and the tools to make backups of media for personal use. What exactly is legally permissible and actually possible with non-physical stuff is much more complicated.
Would probably still work. There's just too many formats which makes it very hard for a content blocker to really stop.

I pity the programmer that has to decode the 1000 versions of xls to find the binary blob that could be a virus.
> cook anything you can fit in the air fryer

Why would I want to cook my milkshake?
China’s growing coal capacity could be seen as a mix of welfare and bureaucratic waste. Each prefecture is incentivized to build its own redundancy, and in a flagging economy, government spending is up to keep the economy going. The resulting overcapacity could be used for ‘peaking’ to offset intermittency in renewable power, something that’s being experimented with currently. And in the shorter term, coal can have less warming effect than gas, but I’m not sure this would be true of China’s coal plants in particular
This is what I use for Termux. I found that I learned the symbol positions after a short amount of use, and it’s quite efficient and configurable (preferences for key size and spacing, etc.).
Half Life 3 is out, dude. It's titled "Alyx".
This is usually added when there's been a significant death relevant to the HN crowd. However, I don't see a related post, so it's possible that it's a mistake this time.
How to Send a Webmention with h-entry
Usually it comes from a reasonably common last name Placencia, which comes from a town on the border region between Spain and France.
Unfortunately VR also showed the flipside of Valves approach to development - putting extreme amounts of money and effort into a project, then abruptly dropping it and moving on to something else. The Index was great at the time but now it's five years old, dated in numerous aspects, and hasn't even had a price cut since launch. Alyx is great but it came out four years ago and Valve has done nothing with VR games since, either themselves or by using their infinite bankroll to help fund third party PC VR development until it's more sustainable.
I ran out of anthropic credits, I just refilled and the service works well now
Threads is another train wreck waiting to happen. The expected purpose of Meta can't be other than capturing a new data well.
I don't think I'm anti-nuclear power. The only thing that works against nuclear, in my opinion, is the time it takes to build. A lot of solar and wind and battery can be built in the decade (if not more) that it seems to take a nuclear power station to be built.

Having said that, given the increasing power demands of civilization, why not both in parallel?
Or just ask Costco to slap a "Contains Milk" sticker on it?
Cashier's check was only accepted for amounts less than $10k at our closing by our title company. This seems common to require wire. The title company contracted with a 3rd party escrow service so the money was required into the title company's account at the escrow service. I assume a cashier's check would need to be mailed to the escrow company
I remember Quora circa 2016 fondly. It had a high number of interesting people writing deep insights into their area of expertise. And then, of course, since they are a venture-backed startup, they tried to grow, and it all went sideways.

I think a small, somewhat homogeneous community is very attractive. You get a high ratio of interesting posts and very little toxic behavior.

The problem is those communities never scale. Maybe they can't scale. Technology won't solve this problem (because it is not a technology problem). Moderation also won't solve the problem (IMHO) because it's either too expensive at scale, or it just imposes the homogeneous viewpoint of a subset of the community.

Maybe the balkanization of social media is the best we can hope for.
I believe it is for Thomas Kurtz, one of the two people who created the BASIC language.

https://news.ycombinator.com/item?id=42141761
People are sick and tired of nonsense bureaucracy

Only when it's something that doesn't affect them. These same people whining and crying about macro-scale system bureaucracies will absolutely meltdown when the consequences of not having those systems in place hits (think supply chain issues during covid).

So much is taken for granted in our modern world because so many are unwilling to surrender to complexities beyond their reasoning. They alone have the answer and all must know it.
Standing more than you sit is nearly all that’s required.
That's not it though.

Pretend I was hiring a restaurant chef and the industry standard test was "run a mile in 4 minutes", a test that 98% of all candidates fail!

So professional chefs practice by jogging daily so they could prove themselves during the famous "run a 4 minute mile" weeding test so they can be hired to prepare meals for people.

That's what we're talking about here. I've had to write out the mathematical proof of various algo complexities of B* trees exactly 0 times when writing SDKs for some CRUD application but that's what's expected during the interview.

It's as correlated with the ability to do the job about as much as running a 4 minute mile in that younger, more desperate, easier to control, and thus cheaper people can do it better. That's what the actual filter is for - to find candidates that are easier to abuse and take advantage of - smart enough to do the work and foolish enough to take the job.

I've hired large teams at multiple companies where such tests were used and that was exactly why we did it. We didn't want the experienced 45 year old wanting to work 40 hours with vacation, we wanted the foolish 25 year old that gave us their weekend.

Actually saying that is illegal, but using a stupid test that selects for it is not.
There also clear lack of alcohol enjoyment education. Gather at friends place and stay overnight, carpools and draw a sober Sam, don’t get overdrunk and drink water for the last 90 min of the party, etc…

I do agree infras and density is a better option. But lack of infra doesn’t justify to drive drunk.
My point is this is how Windows has always been, it's not something getting worse over time. Acting like suddenly now they're including Candy Crush is the line that makes it into malware is laughable to me and overly hyperbolic. If it's malware today because it had a shortcut to Candy Crush it was malware in the 1980s with Reversi. Essentially Windows has always been malware if having a pack-in game distractionware is the standard.

Did you also find Windows XP to be malware? Windows 95? Windows 7?

Is Chrome malware because it's got a hidden game Easter egg in it as well?

Is some Linux distro that defaults to having cowsay malware?
So the government says "If you have an allergen and don't label it, you will be punished."

Industry decides "It would cost a little money to find out if we have sesame in our product, so instead just add a little sesame and then label it"

And you blame THE GOVERNMENT?! The one hurting allergic people here is the company putting sesame in everything so they don't have to give a shit about people with allergies.

I'm so tired of American companies taking the dumbest, most harmful routes to things, and all of you stand up and shout at THE GOVERNMENT, as if Biden himself told Nestle to just put sesame in everything.

Saner populations would correctly be angry at the companies making these overtly harmful decisions.
hacker news, reddit, and other communities. Hopefully there will be a strong incentive in the future for real estate agents or mortgage brokers to recommend the tool. Also I think the name closing.wtf will be good for distribution.
Why should Republicans have to put up with hordes of deranged leftists who believe all conservatives are inherently evil Nazi's? Why should white men have to put up with all the racists who believe they're systemically, irrevocably evil by nature, and awaiting the day that all white people can be killed or enslaved?

Diversity of viewpoints doesn't mean every viewpoint is equally valid. It means that we endure the crazies on both sides, and don't let their stupid theories prevent rational conversation and good-natured and loving people from coexisting. That is, we become more mature, and find ways to cool down the hyperbolic rhetoric -- not abandon each other.
Do they have a record of doing this?

Paranoia here is largely warranted. But people had fewer rights than they realized before. And finding a way to play older media is often a rather expensive endeavor.

Edit to add: I also find picking on Valve awkward here. Microsoft? Sony? I would be far more inline. Even Nintendo. Valve seems to be much more on favor of empowering users, though.
Named worlds safest airline 2023 and many other years. No 2 in 2024 to Air New Zealand.
Extract all the text from the PDF, turn the pdf into images, send the text for each page along with the image to an LLM with a desired output strucutre.
You are arguing that the regulation should be more complex...

Regulations that require the allergen labeling and don't make exceptions will obviously be shorter than regulations that make exceptions.

If the outcome were worse for consumers, I can see arguing for the more complicated regulation, but having a clear statement of the allergens regardless of the product doesn't hurt consumers any (If you disregard the bother from the redundancy anyway).
regardless of what is "really" happening under the hood, if this is model has any influence on the real world through robotics, this could lead to an actual fatality. Physical Intelligence has a robot with arms that can interact with the world. If a robot like this, or a more advanced robot like a car, ends up on the same thought pattern that this model did, it could make actions that can hurt people.

- https://www.physicalintelligence.company/blog/pi0?blog