The thing about larger-scale architecture is that you can be correct in any specific sense that it’s more than you need, but when you actually try to make the thing across a development team, you end up there because the code reflects the organization, and having it broken up like that lets you more easily rewrite your previous decisions.
At the small scale this occurs when you notice that the way in which you have to approach a feature is linguistically different - it needs conversion to a substantially different data structure, or an interface that compiles imperative commands from a definition. The whole idea of the database having a general purpose structure and its own query language emerges from that - it lets you defer the question of exactly how you want to use the data. The more configuration you add, the more of those layers you need. When you start supporting enterprise-grade flexibility it gets out of control and you end up with a configuration language that resembles a general purpose programming environment, but worse.
Casey Muratori talks about this kind of thing in some depth.
In the end, the point of the code is to help you “arrive in the future” in some sense - it’s instrumental, the point of automating it is to improve the quality of your result in some sense. For a lot of computations, that means you should just use a spreadsheet - it aids the data entry task, it automates enough of the detail that you can get things done, but it also gets out of the way instead of turning into a professionalized project.
Not dead, just sleeping. It’s a tougher, higher interest-rate market which cuts out a lot of the gambling behavior. I remain invested but my principle has shifted away from the financial and trad-economic terms to this:
Blockchains are valuable where they secure valuable information. Therefore, if a blockchain adds more valuable information, it becomes more valuable.
And that’s it. You don’t have to introduce markets and trading to make the point, but it positions those elements in a supporting role, and gets at one of the most pressing issues of today: where should our sources of truth online start? Blockchains can’t solve the problems of false sensation, reasoning or belief, but they fill in certain technical gaps where we currently rely on handing over custody to someone’s database and hoping nothing happens or they’re too big to fail. It’s just a matter of aligning the applications towards the role of public good, and the air is clear for that right now.