does q2a supports postgresql ?

Question

Hi there,

I use mysql for database in my q2a

I decided migrate to postgresql for many reasons.

does q2a supports postgresql ?

do I need any special configuration?

Answer 1

It does not. This means that you will have to update many SQL queries to support the PostgreSQL syntax.

Check the qa-include/db directory and you'll see many files that will need to be updated. Some queries will work out of the box but many others, specially the ones with specific MySQL syntax, will not. Also bear in mind you'll have to update the installation queries too as well as any plugin that queries the database directly.