Good reminder of this important but imperfect guide to software design. There is some ambiguity on what "simplest" actually means. Still it helps keeping in mind that simple is rarely easy to find.

It's indeed a nice little pattern to use when the type system allows for exhaustiveness checks of destructure operations. Allows to gracefully handle extension of structs in the future.

We got many options nowadays. Most of them are likely better than just making the underline disappear on links.

This is indeed an area which could be better handled in SQLite. It needs to be carefully checked when introduced in a project.

The idea is interesting... Seeing how the search engine space is degrading quickly I'm tempted to try this actually.