[wp-hackers] Making WordPress database independent

[Andrew Nacin]

On Mon, Feb 7, 2011 at 8:44 AM, Piyush Mishra <me at piyushmishra.com> wrote:

> Is there any reason for wordpress to be completely dependent on MySQL? If
> not, why dont we work on making it dbms independent ?
>

WordPress allows for its database abstraction layer (the wpdb class) to be
extended or replaced.

Sometimes this is used to add a caching layer, or provide support for
multiple databases and even datacenters (see HyperDB). In other cases it can
be used to replace the database engine entirely. There's a plugin offering
PostgresSQL support, as well as a few other engines I believe. There's also
a patch (by Microsoft) offering SQL Server support, but this could just as
easily be implemented as a plugin (and we're working with them to make it
one).

Nacin