Postgresql Compatibility

Hi

I'm looking to make a purchase of the Membership Pro, but before I do I just want to check that it is compatible with a Joomla 5.x install using a Postgresql database. The main reason for checking is that so far most of the plugin's I've used are not compatible and have required a degree of manual intervention and converting the database create files to SQL that Postgres understands. 

Whilst I don't have a problem converting a database table, I do have a problem if the plugin is still 'borked' after the database has been created.

Any help / assistance with this would be gratefully received. 

Arcy

Hi Arcy

Honestly, I haven't tested the extension with Postgresql, so I'm afraid of it is not completely compatible

Regards,

Tuan

Hi Tuan,

Thanks for the prompt reply.

I thought that it might be the case, as it's the same with other extensions I've used. For the most part it's been the database creation that's caused the issue as MySQL & PostgreSQL use different implementations of the SQL Standard. If that's all that different I don't have a problem manually creating the databases, and supplying the modified SQL back to the developers.

That said its hard to say if any of the rest of the code would throw issues with database queries, but for the most part SQL Queries between the two are largely more compatible than the database creation.

There are still some database query code which might not compatible with Postgresql. Honestly, I would say our extensions are not fully compatible with Postgresql. If you want to use our extensions (and guess many other extensions), you need to use MySQL

Regards,

Tuan