MurphyA/hacker-news huggingface dataset:
by Sesse__ | 2025-09-10 13:27:09+00:00
It would be interesting to see how OrioleDB does with more OLAP-like loads. From when I spent a lot of time benchmarking this, the indirect index design was _the_ main reason why MySQL+InnoDB was losing significantly to Postgres on TPC-H (well, DBT-3).[1] There was a lot of working around it with covering indexes etc..

Of course, the flip side of the coin is that if you do an UPDATE of a row in the presence of a secondary index, and the UPDATE doesn't touch the key, then you don't need to update the index(es) at all. So it really depends on how much you update rows versus how often you index-scan them IME.

[1] TPC-H doesn't have difficult enough queries to really stress the planner, so it mattered comparatively less there than in other OLAP work.
by ThrowMeAway1618 | 2025-09-10 13:28:00+00:00
>California schools generally score right at or just below the median for the entire US.

I'm guessing you're referring to the statement above from the comment here[0]. Is that correct?

I read that as "[All] The schools in California [in aggregate] generally score right at or just below the median for [other states' schools in aggregate] for the entire US." Which is as Tyr42 (https://news.ycombinator.com/item?id=45191847 ) interpreted it as well.

Perhaps I misunderstood, but I don't believe I've ever seen comparisons of individual schools across the US. Ever. It's always comparisons of all the schools in one state as compared with those in another state.

Sure, there are often comparisons within states between school districts or between schools in the same district, but never one-to-one comparisons of a single school in one state vs. all the other schools in the US.

But yes, i can see how you might read it that way. That said, I guess we won't know which GP meant unless they come back and tell us.

[0] https://news.ycombinator.com/item?id=45190611

Edit: Clarified comparison examples within within states/between school districts/schools.
by MangoToupe | 2025-09-10 13:28:03+00:00
I of course understand this attitude, but it fills me with hopeless dread that this country will never be able to do anything hard again. Our addiction to cars is one of the hardest to swallow and easiest to fix problems, and yet the will to do so is simply non-existent.

To convince an American to give up on any collective, just point out they'll be mildly inconvenienced. No wonder we never even tried to fight our carbon emissions.
by haspok | 2025-09-10 13:28:12+00:00
> But when cities are much bigger, problems start to arise.

Actually, the bigger the city, the more efficient public transportation is. Just look at LA with it's 16 lanes of car traffic, and compare it to London - the fundamental difference being that LA has no real public transport and London has an extensive tube and train network. Oh, and London has about twice as many people as LA... which one would you rather be a commuter in?

Just an example: a colleague of mine was commuting from Reading to Canary Wharf (before the Elizabeth line even), this is now an hour long train ride, if you tried to take it by car it would be double that - and then you'd have to find parking for your car in Canary Wharf, which is not easy and very expensive.
by Aurornis | 2025-09-10 13:28:15+00:00
> Come to Europe

Anecdotally, among myself and my friends we have more stories of problems with theft and encounters with hostile people from very brief travels to Europe than all time spent on public transport in the USA. To be fair, I haven’t lived in NYC where public transport is famously more dangerous.

I also suspect that foreigners are more targeted for wallet thefts while traveling in Europe.

However, watching multiple friends get pickpocketed on European public transport and having to shake some sketchy people who were being aggressive with women in our group during our brief travels shattered my illusions that European public transport is universally superior in safety.

Edit to add: I also thought it was funny when we met up with someone’s friend in a populous European city who refused to ride public transportation with us. He would drive his car from point to point and meet up with us at the destination. He seemed to believe that the underground was not something people his age liked and was surprised we were riding it without a second thought.
by mystraline | 2025-09-10 13:28:20+00:00
I made the point of calling the whole situation 'poverty'.

You make a valid claim that urban schools have highest per-capita expenditures, which I accept.

However, no amount of school funding can fix: violence/crime, food deserts, poverty wages, parent(s) working multiple jobs and not enough parent-child time, or all the other trappings of poverty not explicitly in schools.

Free breakfast/lunch would definitely help, at least in terms of nutrition and hunger.

But we're past just pumping a district with cash to fix it. We would need to pump the whole community to fix the disease of poverty to start turning the academic performance around.

The downside? Fixing poverty proper takes longer than politicians are elected in. Well, that and "those people shouldn't get freebies, cause that's socialism".

("Those people" is obviously barely coded language for ghetto black people. Howls of socialism and not deserving aid. Glad I never had children.)
by Chris2048 | 2025-09-10 13:28:22+00:00
but this is survival bias. lots of those FOSS projects go nowhere, unnoticed.

You are flipping this around: "companies pretend they need this whole fucking edifice", but they'd need to pick the winners first. those people need no management for them to do what they are motivated to do, but corporation have some people they are asking to do something they might not care much about - the same results aren't guaranteed.
by Balgair | 2025-09-10 13:28:33+00:00
Yeah, that is the thing.

Like, the task I sketched out is the bare basic sketch of what you can ask a new grad/hire to do. Which ends up being ~80% of their job anyways. I really don't think the average person could do that task (unfortunately).

If the new Claude code stuff honestly can do this, then, like I said, that's a close enough definition of AGI for me.
by mschuster91 | 2025-09-10 13:28:40+00:00
Compared with light railway/tram, they need more energy per km traveled due to friction and malleability losses in the tires, they emit fine dust from tires and brakes, and usually they pack significantly less people than a railcar so you need more vehicles and especially more drivers for a bus network.

I'll admit though, a bus network is faster to set up and with mini-buses the size of a MB Sprinter van cheaper to operate even in challenged suburbian hellscapes.
by gxnxcxcx | 2025-09-10 13:28:47+00:00
Tech and the occupation of Palestinian territories have enough overlap to warrant organic self-interested flagging, and that isn't even accounting for any coordinated or state-sponsored activity.

Most people don't like seeing their employment, the stock they hold or their retirement plans stained by this kind of shit hitting the fan. It's one thing to let some token CEO boogeyman catch some flak every now and then, and another thing to be made aware of your own complicity by holding MSFT or HPQ or whatever.
by sevensor | 2025-09-10 13:29:01+00:00
My municipality runs a household hazardous waste collection twice a year. I’ve talked to the folks who run it and their hearts at least are in the right place. No guarantee it won’t end up being tossed in a fire in Bangladesh to recover metals, but they try to avoid that outcome.

Your best bet is to reduce consumption. After that comes repurposing the device. Responsible disposal is hard.
by ClaraForm | 2025-09-10 13:29:16+00:00
Hey, I know what the article wanted to say, see the last two-ish sentences of my previous response. My point, is that the article might be mis-interpreting what the causes and solutions for the problems it sees. Relying on the brain as an example of how to improve might be a mistaken premise, because maybe the brain isn't doing what the article thinks it's doing. So we're in agreement there, that the brain and LLMs are incomparable, but maybe the parts where they're comparable are more informative on the nature of hallucinations than the author may think.
by mystifyingpoi | 2025-09-10 13:29:26+00:00
> Plan your route so you get access to a seat

What do you mean specifically? Most of people working regular jobs don't really get to choose the time for their transit. They generally want to get to work as late as possible and get out of work as early as possible. Which means more people, because everyone wants this.

Fun fact, when I was at high school, some students going home by bus would go backwards the bus path and get inside a few stops away from the school, just so they can guarantee a seat and not have to stand up for 60 minutes.
by thinkharderdev | 2025-09-10 13:29:34+00:00
> I can have the call in the background while looking at something else without it being impolite. I can eat, drink, or use the restroom at will.

This works great when you are one of a dozen anonymous people on a zoom call. less so when you are the senior person in the meeting who everyone is actually talking to and expecting you to make a decision.

But this response kind of proves my point. If you are the principal in a meeting, the fact that everyone else in the meeting is zoned out and doing something else is not great.
by eli_gottlieb | 2025-09-10 13:29:49+00:00
Thanks for getting down to details where we can talk, as well as the look into my papers.

I gotta say: I had a pretty terrible public-school experience too, which I mostly don't talk about in adulthood. Policywise I'm more anti-anti-public schooling than in favor of the system as I went through it, because I've spent the past couple of years living in a state that allows quite a lot of local control, quite a lot of "school choice", and doesn't invest very much in taxes... and currently attempts to brag that slightly less than one third (yes, 1/3) of its kids score as proficient in reading and math[0]. The idea that basic literacy and numeracy qualify someone as belong to an "upper" or "elite" cohort drives me absolutely freaking nuts -- hence my not really supporting a "shut it all the fuck down for how bad it sucks" approach to public education.

[0] https://www.tn.gov/education/news/2025/1/29/nation-s-report-...
by gwbas1c | 2025-09-10 13:30:32+00:00
> Your largest users eventually stop posting if you don't pay them (because they can go elsewhere after using your platform as a springboard: see Vine)

I don't think that's as big as a problem as you do, as long as you don't care about exclusivity.

Think of the streaming music market: Youtube Music, Spotify, Tidal, Amazon Music, ect, generally have mostly the same content and little exclusivity.

For example, you could have a feature where all uploaded videos are automatically uploaded to YouTube and all of your competitors.
by giancarlostoro | 2025-09-10 13:30:40+00:00
> This piece was mostly written because I've been frustrated that YouTube is effectively the only place for user submitted video on the internet.

I realized this back in 2009 and tried really hard to start using other platforms, but wound up just not watching YouTube as often instead. I hope this changes. The only true competitors are places like TikTok and Instagram, but they don't feel like a true replacement to the rest of us who don't want to be tied to "social media" but YouTube shorts are evidence that it does compete with YouTube directly.

I think YouTube even tried to have "IG Stories" at one point iirc.
by evolve2k | 2025-09-10 13:31:04+00:00
Gen Z on the whole don’t agree with either of you. Younger people don’t want to have to drive or to take on the burden of vehicle maintenance or the considerable risk of being in an accident.

Cramped trains and buses and symptoms of under investment they do not need to be this way. Switzerland deeply values trains and as the saying goes once the business class actively uses trains the whole dynamic changes.

Taking a zoom call in a car sucks. Taking one in a train with face to face seating, wifi, Power plus and a table between you is a much better experience.
by codingdave | 2025-09-10 13:31:34+00:00
No, there are many of us with grey hair in the software industry.

42 is probably too old for the startup world, which is where the discussions on HN tend to focus, but that is really just one slice of the industry. There are a ton of jobs at larger non-tech companies, where ageism is not as much of a problem. It is slower-paced, lower-paid, more boring... and perfectly acceptable if all you are looking for is a solid stable job.

The bigger challenge is the "junior dev" problem. There is some harsh reality there. But you can probably fight through that if you look for software work in whatever industry you are coming from, so that your couple decades of prior experience is relevant to the work being done by any team you would join.
by dbish | 2025-09-10 13:31:40+00:00
eh no. a good education system educates the populous. if a student's goals are to play sports and never learn to read, that is irrelevant, they are measured on the education aspect. if their goals are to become a professional streamer, or they value "fame" over anything else, also irrelevant.

we have and should set clear and high education goals. you can adjust teaching strategies towards those goals based on the student and aim to drive those goals even higher, and things like advanced classes are clear ways to do so.
by fzwang | 2025-09-10 13:31:41+00:00
I second this. If you're trying to signal just on "I can code", then there will be fewer differentiating factors between you and younger people.

Typically, I don't think of software dev as an "industry" in itself, unless you're talking about dev tools etc, but that many industries depend on strong software. Your best bet is to target software problems related to your prior job. This way, your skillsets complement each other. You may not be the best at either side, but your ability to integrate the two could be a strong pt.
by wackget | 2025-09-10 13:31:45+00:00
Are they surprised? Why on earth would anyone want to switch to 11?

Getting rid of the customisable/movable taskbar and replacing it with the god-awful Mac-style centre menu was an absolute travesty of design.

Similarly, replacing functional control panel dialogs with the "settings app".

The insistence on packaging programs as "app bundles".

Then there's the slew of useless always-online garbage, which literally nobody asked for, and which basically amounts to user-hostile spyware.

MS needs to accept that user interface design mostly peaked about a decade or two ago, and anything beyond that has been pointless tinkering at best, or actual regression of usability at worst.
by FinnLobsien | 2025-09-10 13:31:48+00:00
Bending Spoons has recently been buying aging SaaS companies that have established PMF and customers and decent brands (Evernote, Komoot, WeTransfer, Meetup).

I guess it's mostly a private equity play—usually after being acquired by BS, prices go up, paywalls go everywhere, companies get "more efficient" (aka layoffs) and the product stops evolving.

I wish there was a better outcome for beloved brands with good products that won't experience any more hypergrowth.
by Tempest1981 | 2025-09-10 13:31:55+00:00
Maybe OPM: (U.S. Office of Personnel Management)

https://www.opm.gov/policy-data-oversight/pay-leave/work-sch...

Official Duty Station

An agency may prescribe a mileage radius of not greater than 50 miles to determine whether an employee's travel is within or outside the limits of the employee's official duty station for determining entitlement to overtime pay for travel.
by sebstefan | 2025-09-10 13:32:01+00:00
There's no amount of convincing that is going to make them feel safe, you need to get them to use it, and change their opinion that way.

They're not gonna use it unless you build it, and they're not gonna use it unless it becomes more convenient than the car.

Right now you've got 3 unreliable bus lines, each bus 30 minutes apart, service stops at 8pm and the schedule is useless because they get stuck in traffic. Consequence is, nobody uses it and there's always a crackhead in the back (they're part of the population that actually uses it to get around even when it's inconvenient)

My point is, you can clean busses regularly (and you should but -), you can put a cop on every bus, you can do a lot of things to improve "the feeling of safety", but it's not going to offset inconvenience, and you won't need to do all that if you just make public transport the most convenient way to get around in your city. Except cleaning them. You'll still need to clean the bus.
by JohnFen | 2025-09-10 13:32:03+00:00
It seems to be a side effect. It doesn't help me in any obvious way. However, when it's happening then I've also ceased to be conscious of writing code. It just flows of its own volition.

I mean, I know I'm writing code, but I'm not consciously seeing, analyzing, formulating, or typing in code.

Edited to add: On reflection, the geometric vision does actually help me sometimes. When there's something wrong with the code I've written (be it a syntax or logical error), then the shapes react in a way that I'll call "dissonant". I pay attention to that signal and more consciously analyze what I've just done, to find the error.
by aunty_helen | 2025-09-10 13:32:07+00:00
Or, as the algorithm seemed to be rewarding 10min+ videos at one point and a bunch of creators put out filler content, people no longer enjoy forced long form content.

This has been a huge thing in car YouTube, a drag race that’s over in 11 seconds stretched out to a 19 minute video. Realistically 5-7 minutes would’ve been heaps of time.
by pjmlp | 2025-09-10 13:32:09+00:00
I live in Germany, and don't need any lessons in Park and Ride.

What I need is a transport infrastructure that cares about people that live outside city central area.

Maybe it will blow your mind that with P+R some of us take about 2h to come to work, versus 45m with a car.

Spain, Portugal, Greece, Italy? P+R isn't even a known concept.
by nathan_compton | 2025-09-10 13:32:52+00:00
I actually think that for the most part string theory and its detractors and its rise and fall have had little effect on total physics budgets in the last 30 years.

I will say that theoretical physics is in a hard spot, but the problem isn't string theory. It is that we are short experimental data because the domain of validity of our theories is currently somewhat larger (in most obvious ways, anyway) than the domains we can reach with experiment.

I don't think any amount of clever budget allocation is going to make progress in theoretical physics go faster, nor do I think we'd be in a different position if we had allocated the resources differently. Notably, LQG and similar approaches (of which there is hardly any shortage) have not made noticeable progress either.

My perspective is this: string theorists are cheap. We may as well have a few for some long shot research, and while we fund them they teach kids math and physics. Seems like a good trade.
by embeng4096 | 2025-09-10 13:32:57+00:00
+1 to your point about the type of books being popularized.

I grew up obsessively rereading Redwall, Pendragon, RA Salvatore’s stuff, Ranger’s Apprentice, Enders Game, Tyrant of Jupiter, Maze Runner. Like you said, the me of now can’t recommend things like Tyrant, but still I can’t imagine that would have appealed to any of the girls I knew at that time, let alone the young women of today.

By the same token, although I read Twilight and Hunger Games, I never was obsessed like the girls in my classes were. I can’t imagine that boys today are particularly interested in A Court Of Thorns and Roses and the other spiritual successors of Hunger Games, Divergent, Twilight, etc.
by y0eswddl | 2025-09-10 13:32:57+00:00
How much effort do you put into trying before you quit?

I used to look at games like Hades and Returnal and see nothing but chaos. But with enough time on the sticks both games became instinctual and I was able to find a flow.

Yes, there's variation in potential range but most brands are capable of most things if you give them enough time to grow the necessary neurons and pathways.
by ModernMech | 2025-09-10 13:32:59+00:00
That's pretty much my point -- my batteries aren't your batteries. If you're building houses, kitchen sinks are your parts. I'm high up on the abstraction stack so I need SLAM, and Kalman filters, advanced logging, mesh pub/sub networking in my stdlib. Here's another example of one of my "batteries" that is perhaps a little more concise: https://www.mathworks.com/products/image-processing.html

Something like OpenCV in the language stdlib is my idea of "batteries included". Like I said: what you consider batteries are not what people in my line of work consider batteries; Odin advertises "batteries included" but looking through the list I wouldn't use any of that in my day to day.

That's why Rust has a small stdlib of just the essentials, because doing so keeps things general, and everyone gets to choose their own idea of batteries.
by mothballed | 2025-09-10 13:33:03+00:00
The case for public transit in the US would be strengthened if it weren't used largely as a vehicle for money laundering public funds into private funds. Another problem is that security tends to be poorly enforced, the last time I rode a public train there was a knife fight in our car over some ear-splitting gang music being played on the wrong turf (lol, literally the turf the train happened to be passing through at that moment as it passed momentarily from a latino to black neighborhood) which did not even alarm most the passengers.

Normal people don't want to ride on a vehicle used for turf wars, robbery getaway express, and as a homeless sleeping center. Normal people are alarmed when ear-splitting rap music is being played provocatively, normal people get alarmed when lethal weapons are pulled out for immediate use in a crowded box. An occasion before that, a schizophrenic person tried to corner me in the back of a train car while going on an increasingly aggressive rant about how the government is out to get us.

And this would bother me even less if I weren't disarmed, because of course it was illegal for me to carry a gun or knife to protect myself from the literal knife fights surrounding me on the train. I presume anyone poor enough to need public transit with half a brain in that town bought, borrowed, or stole a bicycle.
by komali2 | 2025-09-10 13:33:16+00:00
> From a quality of life point of view, I have never been comfortable being crammed into a sardine can with that many other people.

Then, you've experienced poor public transit systems. A good one doesn't make you so packed in because there's enough trains for people to have comfortable amounts of space.

Anyway, it's moot - if your city has lots of people, the only feasible way to move them around is public transit. Trying anything else will fail due to the nature of two things not being able to exist in one place at the same time. One somewhat packed subway car is several hundred square meters of unmoving packed highway.
by skydhash | 2025-09-10 13:33:19+00:00
It helps in my case. Bash is all about text so you just see text being output and manipulated. Something like lisp is about lists and eval, so you mostly see those and equivalent expressions. With something like React, there’s this tree representation of state that is always on your mind.

It’s a more abstract representation than code. Not as fixed, but helps greatly with designing the next steps.
by bluGill | 2025-09-10 13:33:55+00:00
> rather than spend potentially far more time navigating a crowded subway system.

That isn't how it should be. A good subway system is faster than your car for the trips you normally make, and it comes so often you don't think about waiting. There are very few good subways in the world, (much less the US), and so people think it needs to be bad because that is all they see - but it need not be that way.