Whilst I dispute the claim about Drupal being crap, the core works just fine on Postgres (although you will have to live without a good chunk of the contrib modules, but in my experience most of them fall into your PHPtards category).
There is one very, very good module called dbtng_migrator which can take one type of Drupal database and convert it into another one. I just used it to convert some old MySQL based sites to Postgres. There are comments on the website about someone using it to convert from something to SQLite to 'sunset' a couple of Drupal sites. Either way, it's excellent - and means there's literally no reason to use MySQL (unless you want to). I'll be converting my home projects to Postgres when I get time to do it.