Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

does q2a supports postgresql ?

+4 votes
81 views
asked Jul 31 in Q2A Core by smohamadi
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?
Q2A version: 1.8

1 Answer

+1 vote
answered Aug 1 by pupi1985

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.

...