PostgreSQL Vs other DB for Drupal 8
Per our analysis/discussion following are information about POSTgreSQL with respect to Drupal 8 Portal
1.Below link created on 2015 & updated until Aug-2019 lists the issues of PostgreSQL DB that should be fixed in terms of performance, security
https://www.drupal.org/node/2564307
2.In the below link, we see that Drupal 8 listed with Apigee Edge On Premise (or Private Cloud is also same as On premise) does not lists PostgresSQL under “# Install database”
3. Lists MYSQL 5.5.3 as one of recommended DB
https://www.drupal.org/docs/8/system-requirements/database-server
Overall the above link hints about having issues with PostgrSQL with Drupal 8 .
We are trying to evaluate the DB for Drupal 8 (On premise) with Apigee 4.19.06 (On premise)
Would like to know, your experience with PostgreSQL or better to go with MYSQL/MariaDB for Drupal8 Portal
Based on above usage of PostgreSQL is discouraged with Drupal 8, any one had experienced similar judgment or experienced same ? please comment.
The reason we put MySQL in the Kickstart is because of the Remaining Drupal 8 PostgreSQL issues issue on Drupal.org. We do have automated tests running for Apigee Edge Drupal module, but you could still run into issues if you use contributed modules that are not yet ready for PostgreSQL.
That said, we would like to spend more time ensuring that you can use PostgreSQL since that database is installed by Edge private cloud installations, and it would be easier to maintain one type of database versus two different kinds.
You would be safer with MySQL, but if you could test out PostgreSQL with your install and make sure it works, with the fallback of migrating to MySQL if you ever run into issues installing a module or configuration that causes issues.
