HNHacker News
TopNewBestAskShowJobs

Leherenn

1,266 karma · joined December 27, 2017

submissionscomments
Leherenn··on Iran war energy shock sparks global push to reduce fossil fuel dependence
I believe the standard is 4h of storage.
Leherenn··on After two years of vibecoding, I'm back to writing by hand
I haven't tried it, but someone at work suggested using voice input for this because it's so much easier to add details and constraints. I can certainly believe it, but I hate voice interfaces, especially if I'm in an open space setting.

You don't even have to be as organised as in the example, LLMs are pretty good at making something out of ramblings.

Leherenn··on How I estimate work
How did you align with other teams?

I agree it's best if working in isolation, but if you need to synchronise then estimations make sense.

If you need 3 months to implement something, and another team 1 week, and both need to be ready at the same time; then if you actually know those estimations the second team can wait until then and do something immediately useful in between.

Leherenn··on How I estimate work
> you break it up into a small investigation story for this sprint, then decide for the next sprint whether it's worth doing

That's just too slow for business in my experience though. Rightly or wrongly, they want it now, not in a couple of sprints.

So what we do is we put both the investigation and the implementation in the same sprint, use the top of the range for the implementation, and re-evaluate things mid-sprint once the investigation is done. Of course this messes up predictability and agile people don't like it, but they don't have better ideas either on how to handle it.

Not sure if we're not enough agile or too agile for scrum.

Leherenn··on US electricity demand surged in 2025 – solar handled 61% of it
> There's AC in Switzerland.

Not at all, it has one of the lowest rate in Europe along with the UK. It's very hard to get the building permit required to install one. Portable AC has had a boom those past few years though (because it doesn't require a permit).

Leherenn··on Resistance training load does not determine hypertrophy
Anecdotally, my gym had a "challenge" some times back where the goal was to achieve the max total volume in one set without pause.

I tried various combos of weight* reps, and in the end the optimum was somewhere in the middle because no matter how light the weight there was a limit for me at about ~150 reps.

In my case, the curve would be: total volume increases quickly initially at you go from max weight/1 rep to something like 20/30 reps, then something of a plateau as things equalise, then it goes down again as you reach the max reps threshold.

Leherenn··on How well do you know C++ auto type deduction?
Right, although I would argue the most interesting part of the type here is the container, not the containee.

With good naming it should be pretty obvious it's a Foo, and then either you know the type by heart, or will need to look up the definition anyway.

With standard containers, you can have the assumption that everyone knows the type, at least high level. So knowing whether it's a list, a vector, a stack, a map or a multimap, ... is pretty useful and avoid a lookup.

Leherenn··on US air traffic controllers start resigning as shutdown bites
I think the argument is that if you take the airline industry as whole (so not just airlines, but aircraft manufacturers, travel agencies, airports, all the concessions there, ...) it's still very profitable.

And if you add the value to the customers, then it's through the roof.

Maybe the reverse is more clear: if air travel didn't exist, it would have a huge economic impact; a clear proof of the value creation. Airlines just happen to capture essentially 0% of it.

Leherenn··on Australia has so much solar that it's offering everyone free electricity
It might not be as reliable in other places to do it every day, even just in summer. Still, there's clearly a trend globally towards more dynamic prices.
Leherenn··on SQLite concurrency and why you should care about it
A bit off topic, but there seems to be quite a few SQLite experts here.

We're having troubles with memory usage when using SQLite in-memory DBs with "a lot" of inserts and deletes. Like maybe inserting up to a 100k rows in 5 minutes, deleting them all after 5 minutes, and doing this for days on end. We see memory usage slowly creeping up over hours/days when doing that.

Any settings that would help with that? It's particularly bad on macOS, we've had instances where we reached 1GB of memory usage according to Activity Monitor after a week or so.

Leherenn··on GLP-1 therapeutics: Their emerging role in alcohol and substance use disorders
Grit, or willpower, or whatever you want to name it isn't a unique, constant value. There are plenty of athletes who could spent hours training every day but are overcome by addictions. People who grind at work but cannot fill paperwork to save their life. That will diligently do something for months then stops after an unexpected interruption.

There's probably generally a bit of correlation. But just because someone can be very focused and go to extreme lengths in one aspect of their life doesn't mean they can consistently do it in every aspect of their life.

Leherenn··on "ChatGPT said this" Is Lazy
Isn't it the modern equivalent of "let me Google that for you"?

My experience is that the vast majority of people do 0 research (AI assisted or not) before asking questions online. Questions that could have usually been answered in a few seconds if they had tried.

If someone preface a question by saying they've done their research but would like validation, then yes it's in incredibly poor taste.

Leherenn··on The great software quality collapse or, how we normalized catastrophe
I mean, that was over 40y ago. Same thing for the Ariane 5 failure which is a staple of safety-critical classes (at least in Europe), it's not getting any younger.

If all the examples you can conjure are decades old*, is it any wonder that people don't really take it seriously? Software power the whole world, and yet the example of critical failure we constantly hear about is close to half a century old?

I think the more insidious thing is all the "minor" pains being inflicted by software bugs, that when summed up reach crazy level of harm. It's just diluted so less striking. But even then, it's hard to say if the alternative of not using software would have been better overall.

* maybe they've added Boeing 737 Max to the list now?

Leherenn··on Solar energy is now the cheapest source of power, study
Not the GP, but I think it's fairly reasonable, yes.

Ultimately, what we care about, from a grid policy perspective, is the cost to provide 99% (or whatever) guaranteed 24/7/365 power. Each energy source will have its own challenges in order to do that, and for solar availablity it clearly one of them. And yes, externalities should be factored in.

> Or can we just assume that for now we have a mix of sources where different sources have different pros and cons.

Of course, but the question is: what is the right mix for the right place. And saying "solar + storage" is cheaper than gas means very different things if it can only guarantee 60% availability like in England, or 95+% in the sunniest regions of the world.

The figures reported here come from (among others) Lazard' LCOE analysis. (https://www.lazard.com/media/xemfey0k/lazards-lcoeplus-june-...) If you have a look at how it's calculated, "solar + storage" only has enough storage for 4h for instance. You cannot really meaningfully compare it directly with nuclear which is much more reliable in itself.

What LCOE says is that the system will produce X amount of energy at cost of Y. It says nothing about when that energy will be produced. An energy source that produces 365 MWh on January 1st only, and another that produces 1 MWh every day, for the same cost, will have the same LCOE. The latter is, provided you can scale it, much more useful in practice.

Look, I'm not saying that solar is bad or we shouldn't do it. It's just that the "solar is cheap" thing which is regularly reported is a bit misleading. We've heard it for years now, and yet electricity prices around the world are mostly increasing. Clearly there's a mismatch, but where does it come from? And I think part of the reason is that the "ancillary" costs of solar have been underestimated. Sure, the energy straight out of the panel is very cheap, but if you need 10s of billions in grid upgrades and storage/backup to make it work in practice, then it should definitely be included in the comparison! Just like the externalities of fossil fuels should be.

Leherenn··on Wealth tax would be deadly for French economy, says Europe's richest man
Although wealthy foreigners in Switzerland were (and still are I believe) negotiating their taxes directly with the cantons. Wealth tax might not have applied to them if they qualified.

See: https://www.efd.admin.ch/en/lump-sum-taxation

Leherenn··on Swiss voters back e-ID legislation
But the first time it was due to be handled privately and this time by the state. And that was one of the main arguments against it at the time. So I don't think the GP is that far from the truth.
Leherenn··on “No Tax on Tips” Includes Digital Creators, Too
I believe it's because tipping implies they need a money incentive to do a good job. Essentially insulting their professionalism.
Leherenn··on Job mismatch and early career success
Interesting, thanks for sharing! Do you know what happened with the program and people hired this way? Was it generally successful?
Leherenn··on Swiss vs. UK approach to major tranport projects
Not really (274 vs 227), especially if you consider that ~40% of the land is unusable due to being mountainous.
Leherenn··on Geneva makes public transport temporarily free to combat pollution spike
According to the Swiss government that's actually the case there: https://www.bfs.admin.ch/bfs/en/home/statistics/mobility-tra...

"Degree of coverage of motorised road traffic infrastructure costs: 111%"

Leherenn··on Benchmarking GPT-5 on 400 real-world code reviews
Sure, but so far the cost is very minimal. Like 1 minute per PR on average. A crash in production and the subsequent falloffs is probably a good week of work and quite a bit of stress. That gives me quite a few PRs.

And it's not even safety critical code.

Leherenn··on Benchmarking GPT-5 on 400 real-world code reviews
Only has a sanity check/better hints. But I use it for my own PRs, not others'. Usually it's not much to review and easy to agree/disagree with.

I haven't found it to be really useful so far, but it's also very little added work, so for now I keep on using it. If it saves my ass even just once, it will probably be worth it overall.

Leherenn··on How I build software quickly
I think we might be using it in a slightly unusual way: collect data for a while, do one big query once in a while to aggregate/transform the data and clean everything. Rinse and repeat as it's a background app.

So lots of allocations/deallocations. If you're only storing a few key/value pairs long term, you won't have any issues.

Leherenn··on How I build software quickly
Keeping it in memory. After a few days, the memory usage reported by the Activity Monitor (so not the actual resident memory, but the one customers see and complain about) grows from maybe a few 10s MB to a few hundreds MBs.

But as far as I can tell, it's more an OS issue than really a Sqlite issue, simply doing malloc/free in a loop results in a similar behaviour. And Sqlite does a lot of allocations. We see a similar problem on Windows, but not as pronounced, and there we can force the OS to reclaim memory.

It's probably solvable by using a custom allocator, but at this point it's no longer plug and play the way the GP meant.

Leherenn··on How I build software quickly
I have had some bad experiences with Sqlite for local desktop apps with regards to memory usage, especially on MacOs. Insert and delete a few thousands rows per hour, and over a few days your memory usage has ballooned. It seems to cause a lot of fragmentation.
Leherenn··on Solar power has begun to transform the world’s energy system
They're not really solutions if they're not achievable in practice though. Otherwise why not add nuclear fusion to the mix?

To give some example: Switzerland is roughly electricity neutral over a year, but there's a significant winter/summer imbalance of about 5TWh. To add enough storage to compensate this imbalance, you would need to:

- cover about 2% of the country in batteries

- build about a thousand pump storage stations: despite the Alps covering about 40% of the country, it's not clear if you would have enough valleys to flood

- hydrogen looks a bit more reasonable, if we don't look at the costs, you only need to store a few millions m3 of liquid hydrogen. The gas storage in Germany for instance are quite a bit larger than that, but hydrogen is also significantly harder to store.

And all of this is to use once a year essentially! None of it looks practical or affordable (a pump storage station costs a few billions a piece for instance).

Leherenn··on LLM-assisted writing in biomedical publications through excess vocabulary
I read it as "statistically significant", i.e. above noise/error level. Sounds pretty well defined to me, at least in a scientific paper.
Leherenn··on SQLite Date and Time Functions (2007)
We do this as well, but the main drawback is that your DB is "unusable" without those functions, and the functions are application side only.

So if you get a DB from somewhere else and want to open it in whatever tool you use for visualisation, all the queries/views/... will not work because they don't know about all those functions.

Leherenn··on Maximizing Battery Storage Profits via High-Frequency Intraday Trading
I think it's pretty clear with the constantly increasing durations of negative prices, so far we haven't found a way to do so profitably. Carbon capture or anything else for that matter.

Anything that would really love free energy also cost a lot to build and maintain/operate besides electricity. So much that a few hundred hours of free (or even better than free) energy a year is far from enough when you need >90% uptime to make sense. Maybe it makes you go from 95 to 85%, but still clearly it's far more than there are sunshine hours.

Leherenn··on Forests offset warming more than thought: study
It depends what preindustrial means exactly. Most of the forests in Western Europe were cut well before that, I believe around 1800 is actually the trough. Your 80-90% figure is probably back to the original state, but I would guess it's antiquity or pre-antiquity levels.
← PreviousPage 2 of 26Next →