Blaming mysql because you can't RTFM makes you look like a beginner. If you had actually used a large range of databases professionally you would know that apart from CRUD operations every single database has its own quirks and there is no meaningful standard. Seriously, go read something like the SQL cookbook the variations are all over the place. I've also seen both PG and Mysql do some seriously dumb things with joins.
One of the things real engineers do is understand the tradeoffs between different options and choose the one that suits the particular application and environment at hand. Postgresql's unstoppable OCD has always made it a good choice for accounting type systems while mysql has always been good for blog style sites where the data is very dirty. PG 9.3 and 9.4 have finally got reasonable replication but prior to that it wasn't always the best choice if you needed replication.
That article was just click bait with large parts either wrong or irrelevant.