That's why I never accepted the app from my bank. It still work most of the time but it's cumbersome for some uses (like adding a new recipient for wire transfers, it takes two days).
A Linux distribution that uses well the CPUs de have now and do not waste resources would be godsent. Zero copy networking is needed as well. Avoid wasting resources in all sort of ways, I can only dream.
This is really a great manifesto, but I fear that it might go a bit too far to be realistic. Perhaps rethinking the filesystem and databases is not the top priority.
I can run this on an AMD Framework laptop. A Ryzen 7 (I dont have Ryzen AI, just Ryzen 7 7840U) with 32+48 GB DDR. The Ryzen unified memory is enough, I get 26GB of VRAM at least.
I remember just using PHP sessions back then on a XHTML document produced parse errors. Because PHP added the session to the query strings of links and used the raw & character instead of & for separating params in the query string. Thus causing a XML parse error.
There was a push to prevent browsers to be too lenient with the syntax in order to avoid the problem that sloppy HTML produced (inconsistent rendering across browsers)
I wouldn't even know how to prompt the complex queries I have in mind. For simple queries that an ORM could write, I see, but for something complex that generates actual data from the tables, I don't see it coming.
For my work I use SQL pretty extensively, the PostGreSQL flavor, and it's really powerful. I wonder how it is possible to do without except for very simple queries where the ORM might kind of work.
There is however a weakness of SQL is that it's purely declarative and it's difficult to make sure it does the right thing. I often find myself in front of queries that are badly optimized and I'd welcome a language that would be less declarative where you could tell the database engine which index you want to use and how explicitly. The optimizer has table metrics but with the domain specific knowledge the programmer has generally better insights.
I'm not surprised at the powers of htmx. I have been doing single page apps (or close to) using Rails + Hotwire (Stimulus/Turbo) and it works really well.