Use PostgreSQL for WordPress Instead Of MySQL
By on August 9th, 2009

MySQL is the preferred database for , 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 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.

Download PostgreSQL for WordPress (PG4WP)

Tags: , , ,
Author: Keith Dsouza Google Profile for 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 and can be contacted at keith@techie-buzz.com.
 
Copyright 2006-2012 Techie Buzz. All Rights Reserved. Our content may not be reproduced on other websites. Content Delivery by MaxCDN