HNHacker News
TopNewBestAskShowJobs

dspillett

15,974 karma · joined January 12, 2011

email: ISawYourCommentOnHackerNewsAnd.DotDot@indiv.spillett.net

If you disagree or otherwise think I'm wrong, please reply. I'm always willing to be educated, or to explain myself further if I was unclear before.

If I'm right and this annoys you, downvote without reply and I'll understand.

submissionscomments
dspillett··on If IPv4 were land
Yes, the whole address is 128 bits.

Hence my having a /64 (/48 in fact, should I ever enable more than the current /64) shows that 64-bits is enough for global addressing. If it wasn't then giving me a /64 would be part of a path to creating an address exhaustion problem just like the one with IPv4 (which was exacerbated somewhat by handing out /8 ranges unnecessarily in the early days).

dspillett··on DoorDash to Acquire Instacart
> I don't understand how a "free" thing can be anti-consumer

If it is only free in order to inconvenience competitors in a way that will eventually reduce choice, either giving you undue control of a market or being done with a view to charge later when people have no choice as the competition is broken, or both - that is when free becomes an anti-consumer matter.

It is an issue that you sometimes need to think long term to notice. If you wait for it to be an immediate problem, it is often too late to easily do anything about it.

Your food example is exactly what people feared would happen with IE, and what actually did happen for a long time despite the anti-trust case: client side developments stalled because IE was such a large part of the market and it did not implement anything new because there was no reason for them to. There was not sufficient competition to make it inconvenient for the incumbent to stagnate, so the whole area stagnated somewhat until Chrome came along and stirred things up a bit. MS was in control due to an effective monopoly, the consumer suffered.

dspillett··on If IPv4 were land
That would still constitute an entirely new system, just one that looks very like the previous one. So much code and other infrastructure (routing tables in hardware etc.) relies on IPv4 addresses being 32-bits not 64 and that would all need to change, complete with extra new stuff being added for that translation layer while both are in operation (which would end up being near permanent, people will find ways to keep the old stuff running as long as they can). I expect that this new scheme would just become a new version of CGNAT, “Global NAT” perhaps, with the same problems that adds.

IIRC something like that was considered when IPv6 was first being designed, be deemed insufficient for the long-term future. 64-bits is thought to be enough to stave off address starvation though, which is why IPv6 address ranges are usually assigned as /64s (my homer link has a /48 range should I wish to use it all!), so I can see your reasoning on that level.

dspillett··on StackOverflow now gets fewer than 1000 questions a month
> Yeah sincerely good luck.

Thanks. I might need it!

> sooner or later they will start tracking if we fired up Claude for the day

We track who uses what AI and how much. For billing/expense tracking purposes, as we've gone from “use it as much as you can” to “use it as much as you need to but don't waste it”, but there will be a table somewhere with my name in the bottom section next to a bit fat 0.

> has been pretty pushy when it comes to GenAI use tho … Flat out saying no comes with …

You'll have to deal with that or get out, eventually, how soon depends on your management. AI is not going away, even when/if the costs rise when all that investment capital starts being clawed back. If it is any help in choosing an exit strategy: under UK employment law (if you are elsewhere you'll have to verify how things work in your jurisdiction) they can't force you to use AI or punish/sack you for not as it can be argued to be a material change of role (as it is described as revolutionary, or in less breathy terms “like becoming a manager”, etc.) not just a different tool. But if you refuse then the same argument can be used to make you redundant (“we need more AI people and fewer traditional devs, traditional devs are being declared redundant, would you like to switch roles instead?” would be perfectly legal). As much as the payout for my long years in the same place would be nice, personally I don't think I can sit it out long enough for that to happen.

dspillett··on Zero click, silent, remote Android DoS
> LLMs are always hallucinating that they've found the most severe bug in software history.

That is a function of the training data/method, like many of AI's problems. This doesn't stop it being a problem of course, but it shouldn't be a surprise.

Big bugs, like heartbleed, over the years have had breathy websites going over how serious the problem is because the problem was that serious, so the models associate that sort of wording with bug reports. Less serious bugs don't get the same excited treatment, repeated in many many places, so more measured descriptions figure in the training data relatively less.

dspillett··on StackOverflow now gets fewer than 1000 questions a month
No idea. I'm doing the “running away, worrying about the to later” thing to an extent. I'm thoroughly burned out so the first thing I'll do is take a break to rest my head and sort a few personal things. The mortgage is paid, I have a small but useful chunk of savings, and no dependents apart from the cats, so I have the luxury of being able to seriously consider that.

I'm not qualified for anything else that isn't also remote, full of AI and getting more so, or both, so I may quite literally end up waiting tables, I have friends who can help me skip the queue there with an “he's a good bloke” recommendation. While I was in hospital recently (gallbladder trouble and liver infection) talking to one of the porters who was wheeling to & from the CT scanner, they apparently need more bodies ATM, I could certainly do that (other than the temporary issue I was in there for I'm fit & healthy) and might actually find some enjoyment in it. Both involve dealing with real people who are in the room with me. Anything I do once I leave here will be result in a massive pay cut, but if the change saves my sanity then that will have to be acceptable.

dspillett··on Archive.today links going forward
I tend to think that being an arsehole when provoke is still being an arsehole. There are other ways to defend against such an attack than sending the boys¹ round to play bully², that was no better than throwing bricks through all their windows and I assume that we are civilised enough here that wouldn't condone that.

I particularly dislike the fact that I was, unbeknownst to me at the time, was coopted as part of that brigade of brick throwers.

--------

[1] a significant chuck of the internet

[2] beat up his online resources

dspillett··on StackOverflow now gets fewer than 1000 questions a month
> I miss Server Fault

Same. And DBA.se. I was a top contributor of both for the first few years at least, even got sent some free swag a couple of times, not because I cared about the points and being in the first page of people ordered by them, but because I felt genuinely useful and sometimes I got significant help with one or two of my own problems.

I never really did the social side though, I have problems with distance friendships including online communities (I just don't connect well with people that way) which is one reason that I'm hating tech work more and more these days (being on a remote team is not good for my mental health, while I'm not a huge people person it turns out I absolutely need some in my life, and really in my life not on the other side of a Teams call, even though I go into the office most of the people I work directly with don't most of the time so I'm still effectively remote).

dspillett··on StackOverflow now gets fewer than 1000 questions a month
> I don't understand the motivation to reattribute the death of SO to anything other than AI

A lot of people are rather bitter that they couldn't get the response they wanted from questions in the format they wanted to ask them, and would rather think that this slight against them is part of what killed the site. If it is all due to AI then they can't tell the tale of how SO rued the day its community deemed them off-topic :)

dspillett··on StackOverflow now gets fewer than 1000 questions a month
People like me⁰, who I admit will also soon be as obsolete as horse-drawn carriages, will still refer to it for some time.

--------

[0] I'm leaving tech as a career in the next year¹, I don't care if I have to wait tables on minimum wage, I've been unhappy since ~2020 for a growing number of reasons and the great purloining+cheating+polluting machines are the final bail of hay

[1] Maybe before then end of this year, my notice period is two months and I have some accrued annual leave to use, we'll see how the next week or so goes!

dspillett··on Code-execution flaw in UEFI firmware threatens most servers on planet Earth
It could push us further into dependency hell though, as people look for a package that does a simple task instead of the risk of expanding their bug/attack surface area, assuming that the library they depend upon has itself been checked (and the same for its dependencies all the way down).

Trying to keep code small could backfire by ballooning dependency on dependencies to do more of the work.

dspillett··on About the compromised eMudhra intermediate CAs
> This isn't entirely accurate. Plenty of apps run Terminal commands in the background (for some reason).

A lot do it because sometimes there is no convenient library wrapping what they are trying to check or execute that they are aware of, and running a cli command is generally cheap unless you are doing it in a tight loop. A lot of the time this is “it'll do until I find the right library or bindings” code that should have been fixed before release, but it isn't all as bad as running top as you describe.

dspillett··on Apple's git still trusts the compromised eMudhra certificates
Don't underplay it either though: with a compromised but unrevoked signing cert all it takes is a successful phish, or some problem to allow DNS poisoning (or hack a wireless AP, or …) to direct you to a fake site or (potentially worse as it might be less immediately noticeable and could quietly collect credentials/data for a while) send your automated tools to a malicious API.

It may not be directly exploitable on its own, which is the impression some reports give, but it is a serious hole to leave open especially with the current rate of old security issues being found, as it could be _incredibly_ useful to a malicious actor as part of an exploit chain.

dspillett··on Wikipedia's Cleanup of AI-Generated Content
> Is 80/20 ever generally correct?

Sometimes. But it, or 90/10, or sometimes 75/25, is understood to main “a large part of the time”/“a significantly smaller but still crucial amount off the time”.

> If you pay attention, so much user content is just repetition of something they read on the same fucking website and uncritically checked into their brain.

Which is exactly the problem. We now have LLMs doing the same thing, flooding everywhere with more of that noise, further hiding what good signal remains. Even if some of that good signal is by chance almost entirely LLM generated too, it appears to be at best a vanishingly small amount.

dspillett··on Wikipedia's Cleanup of AI-Generated Content
This is the problem that a lot of user-content based sites, and open software projects, are experiencing. The tools make prodiving 80% correct submissions so easy that many people are doing that and thinking that it is fine not to bother verifying for correctness (or not even knowing how to verify correctness). This means those projects are being inundated by submissions that are 20% tosh or worse.
dspillett··on UUIDv7: Timestamps aren’t time-ordered and other oddities
> Good, as it should be.#

Ah, a connoisseur of the semi-automatic foot-gun, I see. Or maybe the foot-RPG?

> It is, SQLite’s docs are great and explain how it works in great detail.

But not the “and when creating a table that way.” part?

dspillett··on UUIDv7: Timestamps aren’t time-ordered and other oddities
> I like SQLite’s decision to make integer primary keys not marked as auto increment to simply be aliases for its rowid which is not guaranteed to be unique for the table’s lifetime.

That to me sounds like a good way to amplify a bug whereby a foreign key has not been defined¹ where it should be. I hope there are copious warnings about it in the docs and when creating a table that way.

--------

[1] Or can't be as the referrer is in an external system, though in that case you probably want a separate external ID, possibly a UUID of some sort.

dspillett··on UUIDv7: Timestamps aren’t time-ordered and other oddities
As well as keeping rows of similar age roughly together, which may create access efficiencies but should not be relied upon, relatively ordered keys massively reduces page splits as the index grows (this can be particularly significant for clustered indexes as implemented by MS SQL and others) because you are always adding items to the end of the index. This can reduce the size of the index overall, potentially a big problem if working in a situation where your data+indexes do not fit comfortably in RAM (you don't want your precious RAM half full of half-empty index pages).

Yes you can shrink it down when things get bad, but if your index is large enough that you care then it is large enough that this reorganisation is going to be costly in time and may slow your system while it happens (or cause a complete lock if your DB doesn't support, or optionally supports and you don't select the option, this as an online operation.

dspillett··on UUIDv7: Timestamps aren’t time-ordered and other oddities
> If you need to list things ordered by creation time very often, it’s useful if the primary index gives that behavior, removing the need for another index.

If you are using your primary key for anything other than a unique identifier for rows, you are almost certainly doing something wrong. If you need an index on creation time, or just creation order, have a creation time column and an index on that.

dspillett··on Dutch government had hacked into Jared Kushner's phone
> Iran is actually fair game since it doesn't want to be part of the ICC.

The current American regime is hardly friendly to the ICC. Are they fair game too? (I'd likely say yes, they would strongly disagree!)

dspillett··on Is this the new cyber normal?
> People are saying the pace will settle down once LLMs find and fix all the bugs.

Only for projects that are in a maintenance state. New features will produce new bugs, unless everyone pays for the tokens to scan every release with the top-of-the-line agents or otherwise spends more time than many do ATM to ensure that changes and new code don't introduce significant exploit paths. Things will slow down once the low-hanging fruit from the past is mostly detected and pulled, but the level of vigilance will always have to be at least a little higher than it has been until recently.

Time between updates releasing and people installing them has been an increasing problem for some time, we are just going to have to be a lot more disciplined about that. This will be a problem for places that have strict availability requirements as they might have to compromise on the testing time they spend on new patches before updating their installations, and we might have to move to having more flexible maintenance windows (the old “an hour or two once a month after Patch Tuesday” hasn't cut it for some time and certainly won't going forward) to allow faster updates.

The bigger problem, compared to the patch-availability-to-general-use time which can be reduced somewhat via automation (though that might accelerate bad-patch based attacks…), is greater constraints for the time between bug discovery and patch release: as soon as there is a rumour of an issue many will start scanning for it (as that is easier now) so the time to wide exploitation is going to be much shorter. This might lead to buggy patches that add new issues of their own.

Perhaps we'll see a lot more projects having explicit LTS releases that only get security updates or signifiant bug fixes, which will reduce the attack surface area (and fault surface area) most users, letting those with less stability concerns deal with the bleeding edge.

> For people like me, this is just yet one more way LLMs are making my life materially worse.

I'm with you there…

dspillett··on Local Wikipedia: Wikipedia, but only for things a half hour walk from you
> EDIT: actually this is just a wrapper around wikipedia's nearby feature I think.

It does at least add a useful feature: being able to state a location to search from. The Wikipedia page (unless there is one other than https://en.wikipedia.org/wiki/Special:Nearby that is more flexible) will only work off your current location, which is completely turned off on my work machine. Also upon checking on my phone, even with “desktop site” forced, the map looks to be an additional feasure too.

dspillett··on Tell HN: I unknowingly broke the PHP RCE embargo. I am sorry
> I have learned my lesson.

It is not your lesson to learn. You tried to be helpful, in a way that you had no idea was verboten. Unlearning being helpful is not a good outcome of this.

It being a potentially massive security issue, taking care to make sure it is safe to release the information is definitely something that should happen, but it appears that you did this:

> My contact had told me there was no embargo, and her contact had told her the same thing.

I'm pretty sure I'd have been more cautious given that the CVE details were not minimal, as this usually implies that releasing the details is expected to cause early exploitation¹, and wouldn't have discussed it as publicly as on HN, but don't kick yourself too much for having done so. You did not break the chain, someone before you, maybe several links before you, did by telling others without giving them information about the need for an embargo.

--------

[1] Perhaps that is a lesson to learn, rather than the not being helpful one? Even then that is a small correction to your level of caution, the big lesson (“FFS be careful, things are embargoed for a reason”) is still for those before you in the chain.

dspillett··on Ask HN: If the models are so good, why doesn't OpenAI just start 100 companies?
Switching to full cynicism mode:

You can't take over the world overnight with little money, even the billionaire class and their companies have limits past which the risk of going bust by overstretching is far too high.

Better to sell the AI services to individuals and smaller business entities, let them take all the risks to build those companies, and later consolidate by buying up the ones that are doing well.

--------

Slightly more grounded: the models aren't that good, at least not yet, despite what marketing would like you to believe.

dspillett··on Local Wikipedia: Wikipedia, but only for things a half hour walk from you
I think¹ it is more likely just a function of how we judge danger. Something local could be relevant to us now (if it were ongoing, or was likely to occur again, or affects/affected someone we care about), something far away might be relevant to us later. Nearby or approaching animal sounds? Definitely pay attention. More distant animal sounds? Maybe keep an ear on that. A tale of animal sounds in the next valley? Only take much note if it is part of an otherwise interesting/entertaining story.

--------

[1] caveat: I am in no way a biologist, sociologist, nor psychiatrist - this pondering may be complete bunkum

dspillett··on CVE-2026-111943: Compromised Intermediate Certificate Authority
I think it is circular, though the glib rewording of Clarke's phrase that I used at best only hints at that: advanced stupidity is probably malicious.
dspillett··on SBD: We Have a Filesystem at Home
It is always worth remembering that LLMs use certain phrases and patterns because many source materials in the training set did. One or two smells does not a cesspool make.

As anti-AI as I am, people pointing out that they've spotted an AI are getting quite tiresome too. If you think people won't spot it without you telling them, then it is good enough for them no matter who or what generated it.

dspillett··on No more icons in every menu by default
> A cogwheel for settings is a great example

Though the cog for settings is, like the three-dots commonly used to represent a menu itself, is only recognised as such because it has often been used that way. The first time(s) it was used it would not have been obvious to people. So the rule isn't that a good icon should be obvious. A good icon is either immediately obvious or consistently used.

The common save icon is a good example of this in both cases: to those of us who have been around a while it is obvious because it looks like a floppy disk, to those who never used floppy disks it is obvious because that is what save icons (almost) always are.

dspillett··on CVE-2026-111943: Compromised Intermediate Certificate Authority
Any sufficiently advanced stupidity is indistinguishable from malice.
dspillett··on PHP2Shell: AI uncovers critical RCE in PHP
> How is a bug that was patched six years ago causing RCE today?

From what I read last night: that patch fixed a specific case (an over-large index that became a negative number) that could trigger the problem, but did not fix the core problem itself. The new exploits try to trigger the problem in another manner, the new patch does address the core issue.

← PreviousPage 3 of 34Next →