Interesting that the guy who wrote the article is an award-winning science fiction writer and also the author of FlashForward. They even made a TV series based on it.
I used SQLite for a few applications several years ago. One time, the database got corrupted and all the data was lost. That was the day I stopped using SQLite.
Also, the lack of enforced column data types was always a negative for me.
I mean, it’s the shitty human nature. You can't create anything publicly without people bashing your project, and you, for the sheer insolence of creating a piece of software.
I used tmux for a few years, until one day I discovered Zellij. With its significantly better UI and overall user experience, I was instantly convinced.