Compatibility with other databases than MySQL

[pixelbrackets]

»in2publish« says in the requirements, that MySQL is the supported type of database. TYPO3 CMS offers a database layer, which supports other database types like Microsoft SQL Server and PostgreSQL. So in theory the extension could support other databases as well. What is needed to do so?

[pixelbrackets]

I ran a test against PostgreSQL and want to share the result. This is not a feature request, but rather just for information in case somebody else would want to pick up this topic.

• TYPO3 CMS 7.6 with PostgreSQL and in2publish extension 7.2
  • CMS fails - needs the extension dbal to work
  • Extension working
  • SSH connection working
  • database connection fails - needs a patch to establish the connection and another patch the keep the connection persistent
  • database comparison tests fail - stopped the test here
• TYPO3 CMS 8.7 with PostgreSQL and in2publish extension 8.5
  • CMS fails - should work since doctrine dbal is included, but throws errors
  • Extension fails - backend not working as expected - stopped the test here
• TYPO3 CMS 9.5 with PostgreSQL and in2publish extension 9.0
  • CMS working
  • Extension working
  • SSH connection working
  • database connection fails - needs a patch to change the driver from hardcoded mysqli to a custom driver like postgres (https://github.com/in2code-de/in2publish_core/blob/develop/Classes/Utility/DatabaseUtility.php#L91)
  • database comparison tests fail - stopped the test here
• TYPO3 CMS 10 with PostgreSQL and in2publish extension 9.0
  • CMS working
  • Extension working
  • SSH connection working
  • database connection fails - needs a patch to change the driver from hardcoded mysqli to a custom driver like postgres (https://github.com/in2code-de/in2publish_core/blob/develop/Classes/Utility/DatabaseUtility.php#L91)
  • database comparison tests fail - stopped the test here