HNHacker News
TopNewBestAskShowJobs

fabian2k

12,556 karma · joined March 18, 2011

submissionscomments
fabian2k··on We Tracked a Shipment of Rare Books. It Ended at an Amazon AI Training Facility
The books get trashed because loose pages are much easier to scan.
fabian2k··on We Tracked a Shipment of Rare Books. It Ended at an Amazon AI Training Facility
Do we know if they actually buy one copy of each book here? Or are they indiscriminately buying books in bulk and just processing all of them?

The latter seems inefficient, so my first assumption would be that they would avoid that. But while I suspect they'd check if they know the book before scanning, I could imagine them not caring that much before buying them and just focus on volume.

fabian2k··on Does anyone run Postgres without PgBouncer?
Not everything is a SaaS application. There's a lot of software where you only run one or two application servers.
fabian2k··on Does anyone run Postgres without PgBouncer?
If you have a connection pooler in your application, and the DB is only used for this application, you don't need an external pool like PgBouncer. That is probably a pretty common scenario, and typical web frameworks include a connection pool anyway.

An additional complication is that more aggressive pooling methods have side effects that you must know and prevent in your application. They're not safe to use out of the box.

The need for a connection pool is a side effect of the heavy process-based PostgreSQL connections. And I would suspect that this will change at some point in the not so near future, so that users don't have to think about this part this much.

fabian2k··on Danish high schoolers will have to verbally defend written assignments
Oral exams can also compensate a lot for different types of exam anxiety. Blanking on individual points doesn't matter as much, the examiner will help you along or ask along a different path. Doesn't help for someone that completely shuts down, but it's much easier to determine if a student was just stuck on some minor point and actually knows the topic in an oral exam.

They are likely prone to more biases than written exams, and the variability among examiners is likely high. My experience is both in taking these exams myself, and also sitting in on them as the note taker many times. Though that was only with one specific professor, and almost always on the same course. But that was in my experience a very fair exam, even for those students that were very noticeably nervous.

fabian2k··on Danish high schoolers will have to verbally defend written assignments
But that is how certain exams are done right now. Though it's usually 30 minutes including overhead. It's not something you can do in classes with multiple hundred students, but it's certainly done at scale.

I was the PhD student in the room in dozens of these exams, and I toke some of them myself. But that was for classes with a bit less than 40 to maybe 60-80 students. The load for the larger ones was shared among professors, if I remember correctly. But it was certainly the case that a single professor spent 1-2 days doing nothing else but these exams.

And it was 1 professor and 1 PhD students, and those don't count. They essentially grow on trees and are always available, if you need some.

fabian2k··on DOGE overstated savings, government watchdog says
I certainly hope that the US finds a less destructive way of changing their reputation than Germany did.
fabian2k··on DOGE overstated savings, government watchdog says
The goal wasn't to save money, but to destroy the administrative capacity of the government. And to eliminate programs Musk, Trump and their cronies disliked, while circumventing the legal procedures.

Of course it didn't save any money, and it was obvious from the start that the numbers they put out were entirely fictional.

fabian2k··on xAI, SpaceX, and the Race for AI Buildout
> Creating widespread non-consensual nude images of primarily women and children

That is an example of ignoring laws and regulations. So that is certainly relevant as context to the current case where the company is ignoring laws and regulations.

fabian2k··on Decathlon Germany adds Wero payment option to decathlon.de website
I've seen that in Germany as well. I was surprised that automatically recognized everything after throwing it in the bin. I knew such systems existed, I didn't think we had any in actual production use here. They seem to trust the system well enough, it didn't even explicitly ask me to confirm if everything was recognized.
fabian2k··on Clinical failure rates over the decades: yikes
A large part of that failure rate is in phase 3. Your comparison with prototypes would be more like drug development before even phase 1. Phase 3 is enormously expensive, much more than the earlier parts. And what's even worse, you don't get to learn all that much from failures in drug development in many cases. You can't just fix the problem and try again, you essentially have to try a completely new molecule.
fabian2k··on Couple pay >$800k for a gene-editing therapy for their daughter. She died.
They did animal experiments first. But according to the article they didn't really look at the serious side effects observed in monkeys, or ignored them. But animal experiments can only provide warning signs here, they can't tell you what will really happen in a human.
fabian2k··on Couple pay >$800k for a gene-editing therapy for their daughter. She died.
It's worse than that. The therapy likely killed her, and her condition wasn't fatal in the first place.
fabian2k··on Couple pay >$800k for a gene-editing therapy for their daughter. She died.
There's so many ethical problems with the events as described in the article. The worst to me seems to be that the researchers/doctors seem to have downplayed the risks here. Which for a never before tried gene therapy that is meant to work inside the brain are absolutely enormous. The ethical issues around the money seem minor in comparison with that and the fact that they seem to have ignored similar side effects in the monkey experiments.
fabian2k··on The startup's Postgres survival guide
It's more of a problem with triggers. But in the end you're switching languages at that point, and devs that have no problem reading your backend language will not necessarily be good at reading stored procedures. Of course depends on how complex you make them.

And of course devs read the content of functions they call. Unless it's a well written library used by many different people, odds are the function isn't documented well enough and has quirks that force you to understand in more detail how it works. This is not external library code, it's still part of your application.

fabian2k··on The startup's Postgres survival guide
You do not need stored procedures or functions to prevent SQL injection. Any Postgres client library from the last decade or two supports parametrized queries, and that's enough. Odds are, most people will use an ORM anyway, which also avoids SQL injection.

In most situations I'd try to avoid using stored procedures. Unless you're all in on them, the effect will be that it hides some logic from the developers since it is not in the main part of the codebase.

fabian2k··on OpenAI and Hugging Face address security incident during model evaluation
The first thing a malicious AI worm would probably do is compromise enough developer machines and other servers to commandeer all the AI hardware it needs. So I think a purely digital AI attack would not need this.

Now, once the AI can carry all the compute it might need, I'd really worry when it doesn't only carry compute but also more explosive ordinance.

fabian2k··on Cheap self-hosted Kubernetes on Hetzner cloud (2025)
They're the first, I strongly doubt they'll be the last to adjust prices that much. The big cloud providers might have enough margins to eat the cost increases, especially since bare VMs are only a small part of their offer. But I don't see how the smaller, more VM-focused providers will be able to absorb the high hardware prices.
fabian2k··on US gas prices hit an average of $4 a gallon again
How many liters per 100 km does a typical US car consume?
fabian2k··on I'm Done with Mullvad
I don't know enough about this specific party, but a quick look at the Wikipedia page about them shows this quote, which to me does seem to suggest that the label is defensible:

> In a podcast segment about immigration and deportations Allard stated his opinion and said that "They will also be forced to leave, even if they are born in Sweden, because they have no natural connection to Sweden. They are not Swedish."

https://en.wikipedia.org/wiki/%C3%96rebro_Party

fabian2k··on I'm Done with Mullvad
There's a huge difference between enforcing reasonable immigration laws and what some right-wing parties are proposing. I don't know enough about this specific party, but you'll find similar ones in other countries. And remigration is in the end about deporting even legal and well integrated immigrants.
fabian2k··on What AI did to stackoverflow in a graph
The vast majority of duplicate closures use already answered questions as duplicates. So ideally that question should have answers that apply to the new question as well. In my observation this is usually the case, though the answer might be more generic.

I have also seen bad duplicate closures that weren't actually exact duplicates. But people talk like this is the only kind of duplicate closure that actually happens. I've no idea if the rate of bad duplicates is so much higher than I observed, or if people are missing that their question is actually answered in the duplicate.

fabian2k··on G# – A modern .NET language with Go, Kotlin, and Swift ergonomics
Yes, you can. I am using that in production right now. An ASP.NET Core application as a self-contained single-file binary, without AOT.

.NET AOT right now is a very specialized solution that isn't widely applicable. Self-contained and single-file binaries do work pretty much out of the box already.

See the documention here for the PublishSingleFile and SelfContained options:

https://learn.microsoft.com/en-us/dotnet/core/deploying/sing...

fabian2k··on G# – A modern .NET language with Go, Kotlin, and Swift ergonomics
You don't need AOT for a single self-contained binary. This already works with C#, but it's still JIT-based.
fabian2k··on G# – A modern .NET language with Go, Kotlin, and Swift ergonomics
AOT is entirely independent of single file binaries. And self-contained binaries that run without the framework installed are again a separate concept. There are some dependencies between these, but they are not the same thing.

AOT is not all that useful yet for many applications as important libraries still don't support it. So more something for things like CLI tools with a small scope.

It's not quite the same as with Go, the binaries get large if you can't trim them. But creating single-file self-contained executables is very much usable and works well otherwise.

fabian2k··on Irish datacenters now guzzle 23% of the country's electricity
Journalism is allowed to have an opinion, that doesn't make it propaganda.
fabian2k··on EF Core 11 makes your split queries faster
Assume you fetch a single customer entity with their 100 order entities as includes. With single query this will join both tables and produce 100 rows that contain the order data but also each one contains the customer data redundantly. Now Imagine you had two includes there, that will multiply the number of rows again.

AsSingleQuery is as dangerous as this makes it sound. This works surprisingly well if you know that the number of included entities is low, but only then.

You can get much better queries here if you write a Select() and let EF Core translate that into SQL. That will probably do roughly want you are imagining here, usually with subqueries fetching the data from related entities.

fabian2k··on PlayStation can delete all your digital games after 3 years of inactivity (EU)
I'd consider keeping the other personal data to be still easily justifiable, as you might want to support various account recovery options. And the odds that a user forgot their password only increases for old accounts.
fabian2k··on PlayStation can delete all your digital games after 3 years of inactivity (EU)
Those articles don't require deletion in this case, in my non-lawyer opinion. There is still a purpose to keeping the user's personal information here. Sony needs that information to be able to grant the user access to the content they bought.

There's a difference here between an account that hasn't been used and doesn't hold anything of value and an account like this that holds items that were bought.

fabian2k··on Introduction to Genomics for Engineers
Scientists tend to understand that part, that's more of a political/cultural thing (I'm ignoring the language part here entirely about which terms to use for which concepts here).

There's the X and Y chromosomes, those produce a binary result (unless you have a genetic anomaly). And after that comes the messy and fuzzy parts I mentioned, where those genes trigger changes in hormone levels and development. And those parts are analog, very complex and contain a lot of different parts. So the outcome is not binary anymore.

← PreviousPage 2 of 34Next →