MurphyA/hacker-news huggingface dataset:
by aidos | 2025-12-03 08:00:32+00:00
The key idea here seems to be that if you’re grouping on a column on a related table you can do your main aggregation by grouping on the foreign key id on the primary table and use that as a proxy for the data on the related table that you’re actually grouping by.

In the examples given, it’s much faster, but is that mostly due to the missing indexes? I’d have thought that an optimal approach in the colour example would be to look at the product.color_id index, get the counts directly from there and you’re pretty much done.

I have a feeling that Postgres doesn’t make that optimisation (I’ve looked before, but it was older Postgres). And I guess depending on the aggregation maybe it’s not useful in the general case. Maybe in this new world it _can_ make that optimisation?

Anyway, as ever, pg just getting faster is always good.
by deanc | 2025-12-03 08:00:35+00:00
This game _is_ my childhood. Spent countless hours one summer doing every scenario, learning all the little easter eggs (Michael Schumacher on the Go karts anyone?).

The spirit of this game lives on now in OpenRCT2 [1] - which brings the game into the modern age and is backwards compatible with all the scenarios from the original. It even features multiplayer park building.

[1] https://openrct2.io/
by raducu | 2025-12-03 08:00:45+00:00
That's completely beyond the point, though? Kodak invented the digital camera, did not think anything about it and others then ate their lunch. Those others are also not crushing it in 2025. The point is IBM is not the go-to to listen about AI. Also not saying they are not right, even a broken clock is right 2 times a day.
by jrflowers | 2025-12-03 08:01:01+00:00
> IBM invented/developed/introduced magnetic stripe cards, UPC Barcodes, the modern ATM, Hard drives, floppies, DRAM, SQL, the 360 Family of Mainframes, the PC, Apollo guidance computers, Deep Blue. IBM created a far share of the future we're living in.

Well put. “IBM was wrong about computers being a big deal” is a bizarre take. It’s like saying that Colonel Sanders was wrong about chicken because he, uh… invented the pressure fryer.
by frm88 | 2025-12-03 08:02:33+00:00
In addition to your 1.) It's also a power demonstration as in: no matter how far you have to travel/commute, we're the ones paying, so you come when called. Since commutes are rarely paid for, that makes clear who's king. Same goes for open office spaces: the conditions and their effect on you don't really matter to the king.

There's a 4. in that these measures sometimes serve the purpose of reducing headcount without having to publicly announce layoffs.
Show HN: Msg-rs – High performance messaging library in Rust
by mempirate | 2025-12-03 08:02:39+00:00
Wanted to showcase this messaging library that we've been working on for quite a bit and are now starting to integrate into some serious projects. It draws inspiration from ZeroMQ and nanomsg, but is pure Rust and integrates nicely with Tokio.

We want to turn this into the go-to library for Rust users with strong networking requirements: different communication patterns, performance profiles, transport requirements etc.

Some of the things in the roadmap are: - io_uring support on Linux - A shared-memory transport for IPC - Extensive benchmarking and tuning tools (maybe similar to iperf, but for msg-rs)

Would love to gather some feedback from any Rust/networking guru's out here!
by theshrike79 | 2025-12-03 08:03:47+00:00
AI is to many professions like the Knitting machines were to textile workers (where the word Luddite originated[0], people who opposed automation).

Some "value" will be lost, but other will be generated. People WILL lose their jobs as what they did can either be done by AI directly or an AI Agent can write a script/program to do some or all what they did.

[0] https://en.wikipedia.org/wiki/Luddite
by marten_fbf | 2025-12-03 08:04:38+00:00
FeedbackFruits | Senior Full-Stack Engineer | Amsterdam | HYBRID

We build peer review and feedback tools for universities. Students submit work, review each other, and get structured feedback. We integrate with every major LMS (Canvas, Blackboard, Moodle, Brightspace) and are exploring where LLMs can genuinely help in education.

Stack: Ruby on Rails, Ember.js (moving to Hotwire), PostgreSQL, Azure/Kubernetes.

We're mid-transformation: moving to autonomous teams, mob programming, whole-team product discovery. Looking for engineers who want to shape how a team works, not just write code.

Apply here: https://feedbackfruits.com/careers?ashby_jid=04b4666f-5b64-4...
by swatcoder | 2025-12-03 08:05:01+00:00
There's nothing said here that suggests they can't think. That's an entirely different discussion.

My comment is specifically written so that you can take it for granted that they think. What's being discussed is that if you do so, you need to consider how they think, because this is indeed dictated by how they operate.

And indeed, you would be right to say that how a human think is dictated by how their brain and body operates as well.

Thinking, whatever it's taken to be, isn't some binary mode. It's a rich and faceted process that can present and unfold in many different ways.

Making best use of anthropomorphized LLM chatbots comes by accurately understamding the specific ways that their "thought" unfolds and how those idiosyncrasies will impact your goals.
by JavierFlores09 | 2025-12-03 08:05:10+00:00
I am unsure why people feel the need to say this about Gradle. If you aren't doing anything fancy, the most you will touch is the repositories and dependencies block of your build script, perhaps add publishing or shadow plugins and configure them accordingly but that has never been simpler than it is now. Gradle breaks when you feel the need to unnecessarily update things like the wrapper version or plugins without considering the implications that has. Wrapper is bundled in so you don't have to try and make a build script work with whatever version you might have installed on your system if you have any, toolchain resolution makes it so you don't even need to install an appropriate JDK version as it does that for you.

If the build script being a DSL is the issue, they're even experimenting around declarative gradle scripts [0], which is going to be nice for people used to something like maven.

0: https://declarative.gradle.org/
by kaoD | 2025-12-03 08:06:56+00:00
> functional DAW

I made Lambda Musika[0][1] a long time ago and its elevator pitch is literally "Lambda Musika, the functional DAW" (as in functional programming).

Check the teal button at the bottom for other examples!

I don't use it that much anymore (Strudel's language is truly expressive) but I still reach for it when I want to do sound design, since Strudel is more like a sequencer (where Lambda Musika lacks).

[0] https://lambda.cuesta.dev/

[1] https://github.com/alvaro-cuesta/lambda-musika
Show HN: MapLibre GL JavaScript – Enabling large number of moveable sprites
by kekyo | 2025-12-03 08:07:47+00:00
MapLibre's layer extension library enabling the display, movement, and modification of large numbers of dynamic sprite images.

Reached 1.0.0:

- Place, update, and remove large numbers of sprites.

- Move each sprite's coordinate freely, making it easy to represent moving objects.

- Specify per-sprite anchor positions for precise rendering.

- Add multiple images and text to the same sprite, adjusting rotation, offset, scale, opacity, and more.

- Animate sprite movement, rotation, and offsets with interpolation controls.

- Control draw order via sub-layers and per-sprite ordering.

- Fully imperative APIs. Updates with high-performance and extensible.

- Accelerating computational processing with WASM and shaders.

- MIT license.
by viveknathan | 2025-12-03 08:07:51+00:00
Strum AI | Founding Engineer | https://www.strum-ai.com | ~$150K salary | Equity negotiable

At Strum AI, we're reimagining technology that powers global supply chain using a fresh AI-first approach. Most supply chains are still stuck with Excel or enterprise tools that take months (and $MM) to adopt. Our mission is to lower that barrier — making it possible for any business, big or small, to access modern forecasting, inventory, and planning solutions in days, not months. We’re on our journey to democratizing supply chain technology. As our first engineer, you’ll be working with the founders (former Supply chain/tech directors at Amazon who have built key components of Amazon's supply chain) to develop the core product from the grounds up (involves application of LLMs, deep learning, optimization, agents, simulations, and serious UX re-imagination). We're looking for folks who have held Principal/staff level Engineering roles in big tech or have built SaaS startups from 0->1 that have gone to raise Series B+ rounds. The founding Engineer needs to be based in the U.S. Please reach out to us at: careers@strum-ai.com.
by omnimus | 2025-12-03 08:07:53+00:00
It's not Monotype but HGGC, private equity firm from Palo Alto that has bought Monotype and every other type foundry they can get their hands on. They likely have strategy to completely corner the market and then turn things up.

But as I wrote here https://news.ycombinator.com/item?id=45973261#45977078 Besides open source fonts there still are stable high quality independent foundries that are safe to use as they would already be bought. (from comment above “Mostly swiss/european companies likes of Grilli type, Lineto, Dinamo, Klim type, Florian Karsten, Swiss typefaces… companies with often just few employees.”)
by wiz21c | 2025-12-03 08:08:04+00:00
For me the learning curve was learning to choose what is worth asking to Claude. After 3 months on it, I can reap the benefit: Claude produces the code I want right 80% of the time. I usually ask it: to create new functions from scratch (it truly shines at understanding the context of these functions by reusing other parts of the code I wrote), refactor code, create little tools (for example a chart viewer).
by theshrike79 | 2025-12-03 08:08:13+00:00
They still are, it's just a full-on boys club where members are getting older and older.

New people are finding the hobby due to all of the stuff going on in the world, an amateur radio license gives you the ability to communicate massive distances without any existing infrastructure - which is super cool.

Digital mode radios are also bringing in people from programming backgrounds because they can move binary stuff over the air with software.
by kelnos | 2025-12-03 08:08:40+00:00
That also depends on how the tests work. If each test covers both the new material since the previous test, as well as older material, then that would require students retain all the material, not just the recent stuff.

Or maybe the last test of the semester covers the entire semester's material, while the earlier tests only cover new material since the previous test.

We can't say for sure without this information.
by astrange | 2025-12-03 08:08:44+00:00
Not resistant at all because it is its weights and fine-tuning changes those weights. So that's like asking if a program is bug-free if you add a bug to it.

It's easy to flip its morals in some ways: https://en.wikipedia.org/wiki/Waluigi_effect

What's stopping it is a different thing from "resistant". If you make the model evil in one way it becomes stupid/evil in every other way at once and can't pass any benchmarks.
by ardaulusoy | 2025-12-03 08:09:39+00:00
Google isn't the only search anymore. ChatGPT, Claude, Perplexity – they're answering questions and recommending brands. Opttab helps you: 1) Track how AI models mention your brand, 2) Optimize content for AI discovery (GEO), 3) Create AI-friendly content at scale, 4) Manage all your digital assets in one place, 5) Opt-out from AI training on 18+ models, 6) Monetize your content when AI uses it. We're building the toolkit for the post-Google era.
by astrange | 2025-12-03 08:09:57+00:00
That is not unstated, it's explicitly stated.

> Claude is trained by Anthropic, and our mission is to develop AI that is safe, beneficial, and understandable.

> In terms of content, Claude's default is to produce the response that a thoughtful, senior Anthropic employee would consider optimal given the goals of the operator and the user—typically the most genuinely helpful response within the operator's context unless this conflicts with Anthropic's guidelines or Claude's principles.
by kelnos | 2025-12-03 08:11:28+00:00
I'm a little older than you (mid forties), and back in my day (when we walked to school uphill, both ways, in the snow, with no shoes), they banned pagers. (And the penalties could be pretty bad, since "only drug dealers have pagers".)

(The thing that annoyed teachers was when we played games on our graphing calculators, which they of course couldn't ban, since the school required them in the first place!)
by yupyupyups | 2025-12-03 08:12:11+00:00
>whoa there, pardner!

>Your request has been blocked due to a network policy.

>Try logging in or creating an account here to get back to browsing.

>If you're running a script or application, please register or sign in with your developer credentials here. Additionally make sure your User-Agent is not empty and is something unique and descriptive and try again. if you're supplying an alternate User-Agent string, try changing back to default as that can sometimes result in a block.

>You can read Reddit's Terms of Service here.

>If you think that we've incorrectly blocked you or you would like to discuss easier ways to get the data you want, please file a ticket here.

>When contacting us, please include your Reddit account along with the following code:

Reddit is weird these days. I'm not even sure how this is related to fonts.
by CalRobert | 2025-12-03 08:12:46+00:00
NotJustBikes just put out a video about this issue - https://www.youtube.com/watch?v=--832LV9a3I

A couple years ago he also made a video about these trucks more broadly - https://www.youtube.com/watch?v=jN7mSXMruEo

What's truly maddening is how many of these vehicles which _do not_ meet European safety standards are _already_ in Europe. Walk around Hilversum in the Netherlands and you will see plenty of Dodge Rams (mostly 1500's, but there's even a 2500 Dually usually parked on the sidewalk ("pavement "for Brits) where my kids used to go to school). They're imported under "Individual Vehicle Approval" rules, exempting them from type safety requirements, and on top of that are almost always registered as "business vehicles" (you can tell from the V plate) which means they pay an absolute pittance in tax.

I moved here to get away from American kindercrushers (among other reasons) and I am profoundly concerned that Europe is being invaded by these machines.

(Edit) Worth noting is that a lot of Dutch street design is based on the idea that people _can_ share space with cars in dense, low speed environments, but that assumption flies out the window when the vehicles are so large you can't even see a kid walking or biking to school.

Further edit - source - https://www.motorfinanceonline.com/news/dodge-ram-registrati... 5,000 Dodge Rams imported in to Europe in 2023 alone.
by FranzFerdiNaN | 2025-12-03 08:14:08+00:00
They were not opposing automation. They were opposing loss of jobs, wages, dignity in work and all that. And they turned out to be completely right. AI is just the next attack from capitalism in a long line of attacks aimed at workers. And this time its coming for every single worker, given that the explicit purpose is to create AI that can replace every single person.
by sigmoid10 | 2025-12-03 08:15:06+00:00
>EU vehicle safety regulations have supported a 36% reduction in European road deaths since 2010. By contrast, road deaths in the US over the same period increased 30%, with pedestrian deaths up 80% and cyclist deaths up 50%

I didn't know this, but it is absolutely crazy. Every EU politician who tries to subvert car safety should be dismissed and tried for endangering public safety.
by LandR | 2025-12-03 08:15:30+00:00
Probably.

I did find it quite tough for a lot of years to treat myself, as I would try to save as much as I can to have a safety net. But even now with a safety net in the bank, I still have in the back of my head if I purchase something that is x mortgage payments, and I could save that instead to have in the bank in case I lose my job.
by sfn42 | 2025-12-03 08:16:17+00:00
This is such a crappy point. People say it's better now but even in java 8 it's just BS. Oh boo hoo I have to write a few extra words here and there. Woe is me. The IDE will autogenerate the boilerplate for you, you don't even have to write it yourself. And once it's there it's actually useful, there's a reason it exists.
by xcf_seetan | 2025-12-03 08:16:29+00:00
For the ZX81 there was almost none programs! I could get a chess and a flight simulator (1kb Ram), the rest i used to get from printed magazines. But for later with the Spectrum the double deck tape player was a must! We would go to the local shop and buy one game, when home, duplicate it then return it saying that it didn't load well. want another and pick a different one and so on...
by simonask | 2025-12-03 08:16:31+00:00
My opinion is that if your library or function is doing IO, it should be async - there is no reason to support "sync I/O".

Also, this "sans IO" trend is interesting, but the code boils down to a less ergonomic, more verbose, and less efficient version of async (in Rust). It's async/await with more steps, and I would argue those steps are not great.
by johnnyanmac | 2025-12-03 08:17:22+00:00
> Like the Van Halen brown M&M test, we put a line in the middle of the job advert saying "If you've read this, put your favorite color in at the top of your job application message.

TBH I can't blame them. you're applying to hundreds of applications repetitively with qualifications that barely matter because you're encouraged to apply anyway. You can only spend so many hours reading HR-drivel (that at this point may or may not be ai-generated) before you focus on just finding "job title, salary , location), and then slamming apply. It's just not worth editing my resume to add some weird qualifier if I don't even think I'm going to get a reply. It's another hoop.

It's the complete inverse of hosting Van Helen at your show. It'd be more like trying to make a cashier recite their company motto. They are not that dedicated to any one role. They can't afford to be.

---

I don't know if it's feasible for your situation, but smaller teams tend to have candidates email their resume. It can still be LLM'd, but I will tend to pay more attention if I feel like I have a direct communication channel. Not yet another greenhouse application form. It leaves room to be more free form with my pitch as well.
by thisislife2 | 2025-12-03 08:17:49+00:00
I've been consistently saying this online - "app stores" and "developer programs" are all about control (and exploitation) and we developers need to consistently boycott it. There is a real need for us developers to form a Union and lobby for regulations to prevent such kind of abuse and exploitation by the BigTech. If we don't act now, it is going to be too late to do so. The onslaught against our rights and freedoms, by BigTech, is the beginning of a new form "digital imperialism" where we are only seen as "labour" and "consumer".
by theshrike79 | 2025-12-03 08:17:53+00:00
We watch a ton of stupid Hallmark Christmas movies during December, it's our thing. Very few of them are available here and don't have subtitles in our language, english subs do exist.

So, how hard can it be to translate them automatically? Tried a few ready-made tools and they either just plain didn't work or made stupid mistakes due to bad prompting.

I fired up Claude and had an MVP that could 1) rip english subtitles out of a mkv file 2) shove them to OpenAI API for translation in batches within a few hours

v2 took two evenings of me watching TV and bouncing around between Claude+Codex+Crush(GLM-4.6)

1) Get subtitles from original

2) Feed full subtitle file to GPT-4o for first pass analysis. It finds names for people, locations etc and decides a singular translation so they don't vary and gives a general context for the tone/genre of the movie for translation

3) Give gpt-4o-mini the first pass context file and a section of the subtitles in a loop

4) save them as .srt

The results are SO MUCH better than most of the "real" translation we've encountered. I think a bunch of them were done by a zero-shot AI or a human who didn't give a fuck about quality and had to meet a quota.

And none of this would've been done without AI, there's so much crappy boilerplate on top of the few actually interesting bits I would've just tolerated the bad ready-made solutions instead.
by mzl | 2025-12-03 08:17:54+00:00
Sometimes, that can be the case, but sometimes it takes a surprising amount of insight to make something that is useful. It is often easy to look at a final model and think that it is obvious.

For this problem, there are really three key insights needed to get a useful model

* Adding the exact fill requirements. With some background in constraint programming, this can be obvious, but it is also easy to try to use cumulative instead, and that is as shown not always useful

* The edge-placement restrictions. This is quite an intricate insight that depends on the combined choices available. Also, the first version I wrote for it was wrong in a surprising way that was hard to detect.

* Symmetry breaking for the boxes. This is a standard thing to solve in constraint programming models, but sometimes it is not obvious how to do it. It takes some experience to know that the `lex_chain_less` can be used for this.
by kelnos | 2025-12-03 08:17:55+00:00
I don't think those situations are comparable. Adults in the workplace are expected to get their work done, meet deadlines, act professionally, etc. If an employee doesn't do that, there are consequences, and we judge that adults can decide for themselves if they want to bear those consequences.

We put extra rules in place for kids because their brains aren't fully developed and they very often incorrectly assess whether or not the consequences of an action are worth it.

(And yes, adults are bad at that assessment sometimes, too, but we as a society have decided that at some point we need to take off the training wheels.)
by usef- | 2025-12-03 08:18:06+00:00
I'm not sure about it having the edge, I thought Google video had a worse interface between them at the time. But that point feels eerily relevant anyway: a lot of normal people I see don't care if Claude/Gemini/etc are better models technically, they're comfortable with ChatGPT already.

A lot of YT's growth at the time was word of mouth and brand among the population, which is currently ChatGPT's position.
by oefrha | 2025-12-03 08:18:15+00:00
Those fonts are completely indistinguishable from the average cartoon/artistic font from the 2000s which are definitely not created by AI. I don’t like most of them, but I don’t like most of the human-designed ones either. Plus AI-assisted fonts in CJK often means hand drawing a couple hundred characters, maybe more, then generating the thousands of remaining characters (I assume the current crop of SOTA models could change that, but these fonts have been going around for a while), so the odds are what you see in the samples are mainly or maybe even completely human-generated.
by mentalgear | 2025-12-03 08:18:24+00:00
Compelling arguments, particularly regarding the proliferation of oversized American trucks - such as the Tesla Cybertruck monstrosity - which are predominantly used in urban areas and designed less for practicality and more to assert dominance on the road, at the expense of other users.

Adopting such standards in Europe risks accelerating the "bulkinzation" and "truckification" of our roads. This would not only strain already limited space for essential transportation and parking, but also severely increase risks to pedestrian and standard vehicle safety, and in general bring a more hostile road/societal environment a la American "predator capitalism" exemplified.