MySQL vs. PostgreSQL

  • Resolved chillybang

    (@chillybang)


    1 month, 3 weeks ago

    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 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

    (@wpdatatables)

    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.

    1. 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.

    If you have any additional questions on any premium feature,please open a ticket on our main Support platform here, 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 which doesn’t require a purchase code.

    Premium products are not supported in these forums, as per this comment by www.remarpro.com moderators.

    Thank you for understanding. 

    Kind regards.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.