Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+4 votes
in Q2A Core by
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

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.