Reply to thread

Appreciate your opinion on the MySql / Postgres. Both databases have pros and cons. But that's about it.  I have been supporting Postgres since  7.x version and have consulted and implemented solutions in Postgres for fortune 100 companies that I cannot disclose due to NDA's. But lets say these companies are in the Billions as far as revenue goes. In fact, we just finished migrating an Oracle based solution to Postgres with an annual savings of 7 million in licensing fees. Insane. Lets not forget who owns MySQL    Having said that, fault tolerance without slaves has been there for many years mainly with Aurora. Hot backups have never been an issue for Postgres and can be performed regularly.  And lets not forget the MySql was not even acid compliant until innodb became the preferred storage engine. Parallel query processing as far as I can recall was not even possible until mysql 8. As far as reads and writes, postgres can achieve insane throughput using citus.  Postgres can achieve full upgrades with zero downtime as well. RDS even offers their DMS which can get close to this. Dare I say declarative partitioning and sub partitions with parallel querying and partition exclusion? that's been around for a while as well. There are 10,000 ways to skin a cat

Lets not forget Discourse  They run on a Postgres backend. So who knows. Maybe one day XF will be available in postgres as well.

Regardless of database wars  I am in the middle of porting my gallery and classifieds app which runs on a postgres backend to integrate with Xenforo which runs on Mysql. Glad to say i have both database engines talking to each other using Postgres FDW's with minimal effort.