Use PostgreSQL for WordPress Instead Of MySQL
MySQL is the preferred database for WordPress, however not everyone likes MySQL and there is no easy alternative to make WordPress use another database.
If you want to use PostgreSQL with WordPress there is a WordPress plugin that will allow you to do it without making any changes to the internal WordPress codebase.
PostgreSQL for WordPress (PG4WP) gives you the possibility to install and use WordPress with a PostgreSQL database as a backend. It works by replacing calls to MySQL specific functions with generic calls that maps them to another database functions.
When needed, the original SQL queries are rewritten on the fly so that MySQL specific queries work fine with the backend database.
Support for other database can also be added if the appropriate drivers are written for them.
We tested this out on a local installation and were able to use PostgreSQL with WordPress without any issues.
The only problem we see with the plugin is that you need to perform a fresh install for this to work, however it might work on older installations if you are able to import the MySQL database to PostgreSQL.
Author: Keith Dsouza
I am the editor-in-chief and owner of Techie Buzz. I love coding and have contributed to several open source projects in the past. You can know more about me and my projects by visiting my Personal Website.I am also a social networking enthusiast and can be found active on twitter, you can follow Keith on twitter @keithdsouza. You can click on my name to visit my Google+ profile.Keith Dsouza has written 4372 articles for us.
The author of this post can be contacted at keith@techie-buzz.com
We moderate comments to prevent spam. Moderation is done within few hours. Please try and stay on topic and refrain from using abusive language. If you think there is a problem with this post, please email the post author or send us an email at tips@techie-buzz.com with the URL and the problem you see and we will rectify it as soon as we can.