I'm at the early stage of designing my website. My webhost uses MariaDB. I need PIVOT like functionality to generate about 100 wpDataTables for product review posts on the website. Each wpDataTable will be a different product comparison table.
While it is possible to achieve this in MariaDB/MySQL with prepared statements, it gets ugly quickly. If I use MySQL it will mean maintaining about 100 views generated with complex prepared statements because there is no PIVOT functionality in MySQL (without installing the CONNECT engine which my webhost won't do).
As a result, I'm considering using Postgresql. I understand wpdatatables can connect to a Postgresql database. My goal is to have a simple and easy to maintain database setup, which is why I'm hesitant to use Postgresql as it adds complexity to the website design. My question is are there any disadvantages to using Postgresql with wpdatatables compared with MySQL? Your website says it's possible, but are there any disadvantages? I know Wordpress is deeply integrated to MySQL, so I'm wondering if there will be any unforeseen issues by using Postgresql for my products database? For example, performance or integration with other tool issues?
Any advice would be greatly appreciated on what direction I should take.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
To be honest, PostgreSQL is not my area of expertise to the highest extent,
so I will double-check this with our senior 2nd level colleagues to give you the most accurate information about any unforeseen issues, as you described, if you switch to PostgreSQL rather than MySQL .
As soon as I get confirmation I will come back to you straight away. Thank you for your patience.
Hi,
I'm at the early stage of designing my website. My webhost uses MariaDB. I need PIVOT like functionality to generate about 100 wpDataTables for product review posts on the website. Each wpDataTable will be a different product comparison table.
While it is possible to achieve this in MariaDB/MySQL with prepared statements, it gets ugly quickly. If I use MySQL it will mean maintaining about 100 views generated with complex prepared statements because there is no PIVOT functionality in MySQL (without installing the CONNECT engine which my webhost won't do).
As a result, I'm considering using Postgresql. I understand wpdatatables can connect to a Postgresql database. My goal is to have a simple and easy to maintain database setup, which is why I'm hesitant to use Postgresql as it adds complexity to the website design. My question is are there any disadvantages to using Postgresql with wpdatatables compared with MySQL? Your website says it's possible, but are there any disadvantages? I know Wordpress is deeply integrated to MySQL, so I'm wondering if there will be any unforeseen issues by using Postgresql for my products database? For example, performance or integration with other tool issues?
Any advice would be greatly appreciated on what direction I should take.
Kind regards,
O
Hi, Olly
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
That is correct, we have Multiple DB engine connections support (more details on how to set up the connection here);
-
To be honest, PostgreSQL is not my area of expertise to the highest extent,
so I will double-check this with our senior 2nd level colleagues to give you the most accurate information about any unforeseen issues, as you described, if you switch to PostgreSQL rather than MySQL .
As soon as I get confirmation I will come back to you straight away. Thank you for your patience.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi, Olly
Apologies for such a long waiting time on the confirmation, our developers have been extremely busy for the past week.
I am expecting confirmation on this query from them fairly quickly at this point. I will keep checking with them, and will confirm this for you ASAP.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi, Olly.
Thanks again for your patience, i've been advised by the devs.
Basically, if you use MySQL on same server where your WordPress site is, then it will be faster either way,
if we compare it to a separate DB connection, which is not on the same server.
- Other than that, everything should function without issues, and there are no known disadvantages,
just that the MySQL variant is faster, but this also depends on the configuration of the server database, etc.
-
I hope i passed the explanation correctly, but please let me know if you have any questions. Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables