Title: MySQL vs. PostgreSQL
Last modified: October 2, 2024

---

# MySQL vs. PostgreSQL

 *  Resolved [chillybang](https://wordpress.org/support/users/chillybang/)
 * (@chillybang)
 * [1 year, 8 months ago](https://wordpress.org/support/topic/mysql-vs-postgresql/)
 * I try to contact you on this way, because the ticketing system on your site is
   broken and forces a purchase code for pre-sale questions, where no purchase code
   can exist.
 * I plan a project based on wpDataTables and would like to know about pros, contras
   and known limitations with using of remote MySQL over PostgreSQL as separate 
   db/data sources.
 * Searching in your forum I found only a [limited set](https://tmsplugins.ticksy.com/ticket/3037987/)
   of threads, without needed informations.
   With “known limitations” I mean things
   like a need of pgsql driver for PostgreSQL connection, which usually isn’t a 
   part of standard WordPress host setup and needs a root server.

Viewing 1 replies (of 1 total)

 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [1 year, 8 months ago](https://wordpress.org/support/topic/mysql-vs-postgresql/#post-18049484)
 * Hello,
    1. Regarding your question, we can’t provide additional details beyond what’s in
       the premium ticket. We are not aware of specific pros or cons between using 
       remote MySQL or PostgreSQL as separate DB/data sources in terms of performance.
 * However, when it comes to the required drivers to make the connection between
   your WordPress and the remote DB – the specific driver needed depends on the 
   database you’re using.
   In other words, it is best to check with the remote DB
   server’s support which driver is needed – then that driver has to be installed/
   activated on the WordPress hosting server.
 * We cannot provide assistance on this Forum on the subject of SQL queries and 
   remote DB connections as they are not available in the Lite/free version of our
   plugin.
    2. Regarding the issue with opening a pre-purchase ticket:
 * We tested this and were unable to replicate the problem — no purchase code was
   requested. Please see the attached screenshots.
 * ![](https://i0.wp.com/ticksy_attachments.s3.amazonaws.com/3165258250.png?ssl=
   1)
 * ![](https://i0.wp.com/ticksy_attachments.s3.amazonaws.com/9673940597.png?ssl=
   1)
 * If you have any additional questions on any premium feature,please open a ticket
   on our [main Support platform here](https://wordpress.org/support/topic/mysql-vs-postgresql/../../?output_format=md),
   and one of our Agents will respond as quickly as possible.
 * If you don’t have a licence (or if it expired), please open a [pre-purchase ticket](https://wordpress.org/support/topic/mysql-vs-postgresql/../../submit/?output_format=md#100010481)
   which doesn’t require a purchase code.
 * Premium products are not supported in these forums, as per [this comment](https://wordpress.org/support/topic/error-when-not-logged-into-wordpress-backend/#post-15050671)
   by WordPress.org moderators.
 * Thank you for understanding. 
 * Kind regards.

Viewing 1 replies (of 1 total)

The topic ‘MySQL vs. PostgreSQL’ is closed to new replies.

 * ![](https://ps.w.org/wpdatatables/assets/icon-128x128.gif?rev=3010404)
 * [wpDataTables - WordPress Data Table, Dynamic Tables & Table Charts Plugin](https://wordpress.org/plugins/wpdatatables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpdatatables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpdatatables/)
 * [Active Topics](https://wordpress.org/support/plugin/wpdatatables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpdatatables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpdatatables/reviews/)

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [PostgreSQL](https://wordpress.org/support/topic-tag/postgresql/)

 * 2 replies
 * 2 participants
 * Last reply from: [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * Last activity: [1 year, 8 months ago](https://wordpress.org/support/topic/mysql-vs-postgresql/#post-18049484)
 * Status: resolved