I think the disconnect may be due to the article repeatedly mentioning that “this stuff is used by smartphones/websites!!!” but almost never mentioning that full-sized computers exist, even though most of the software being discussed is Linux-primary (and some of it is also used on Windows/Mac, like SQLite). It looked to me like the author’s target audience was “people who use a smartphone as their primary or only device.”