For example, one of the biggest optimisations that Hacker news does is that it serves logged out users from a cached copy of the front-page.

Logged out users don't care/notice about comment counts, they don't notice that it doesn't update as often, they can't be hiding articles so you can serve the same front-page to the millions of anonymous users and bots, and update that cached copy once and on a slower cadence than every request.

Maybe it's improved since I last used it, but to my knowledge SQLite essentially forces all writes to be serialised, at risk of data corruption otherwise.

There are tricks for improving the performance such as WALs, but that is merely a performance boost rather than genuine concurrency with things like row-level locks that you might find in other databases.

I guess if the whole thing is architected with a write-through cache that handles concurrent writes and deals with serialising all the writes, then it can be a single writer streaming changes through to the database, but then you still have a point of serialisation, it just will manifest itself slightly differently.

And SQLite is something that will give you constraints you will always have to consider.

Whereas running mariadb or postgres on the same machine would deliver similar benefits without a risky migration.

If your DB is small enough to run as a SQLite database, then it probably ought to have never been on a different machine in the first place.

There is a very happy medium between SQLite and a database on a different machine, one I am continually surprised to see people ignore.

OK Go blew up early youtube with Here It Goes again: https://www.youtube.com/watch?v=dTAAsCNK7RA .

But these are exceptions to the rule, most people don't have the ability to do much creatively with a shoestring budget.

( Which isn't to say this slop is better. This slop is far worse, it's utterly dreadful. )

Russia were first to almost every other milestone, first orbit, first man in orbit, first woman in orbit, first EVA, first moon orbit, first (unmanned) moon landing, and many others.

Edited "Russians" to Soviets because lot was done by non-Russian parts of the union, my original reply just mirrored the OP use of Russians.

So many well-known UK companies have been sunk by debt interest on loans taken out to acquire said companies.

By all means use the companies to secure loans, but the liability should be on the books of the parent companies not the companies being acquired!

There have even been cases where the companies have been effectively asset-stripped by "sell and lease back" of property, leaving the companies a shell of their former selves with no meaningful assets, so as soon as there are any unexpected headwinds they collapse.

It read to me to be entirely generated. The lack of details that people would normally mention tripped my spidey-sense. ( Who wouldn't name-check the restaurant in the opening paragraph? )

A double check, the author appearing to take up blogging in 2023, mostly about data science, with all the tell-tale signs of generated posts.

It's got so good at writing generally that it catches us off-guard.

60k isn't much bigger than the system prompt.

Weird to come back to a terminal running edge unprompted and the auto classifier waving it though as 'safe".

My reaction was also, "I need dev containers ".

People overestimate how much senior devs in the UK earn, even after knowing they're not well paid, my usual response to hearing we should be earning £90k+ is, "well give us a job then"!

UK wages are not great.

This isn't (just) a validation issue, and shouldn't be at the harness level.

I was in my late 20s when I realised I was "face-blind", but I should have realised a lot earlier, I remember reading in a book as a child about how "people can recognise a person by their face from a long distance, but find it difficult to recognise a voice", and I could not relate whatsoever to that passage.

I thought I regularly struggle to recognise someone until they start speaking, but it wasn't until a decade or two later that I read about prosopagnosia and then suddenly a lot of things made sense.

Your explanation is so much better than the rubbish illustrations of blanked or blurred faces, because it isn't like that at all, indeed sometimes I might rely on a detail about their face to recognise someone.

It's why face-blind isn't a great term either, because it's not a kind of blindness, I can see just as well as anyone, it just doesn't trip the automatic and instinctual recognition that I understand most people have.

You could then set it to hold the result until the next tick.

E.g. An I/O tick of 20ms, and it would only return on 20ms boundaries, then almost every SSD would look the same.

It would slow down the API a bit, but privacy has tradeoffs.