Home Messages Index
[Date Prev][Date Next][Thread Prev][Thread Next]
Author IndexDate IndexThread Index

Re: [wp-hackers] alternative database support

  • To: wp-hackers@xxxxxxxxxxxxxxxxxxxx
  • Subject: Re: [wp-hackers] alternative database support
  • From: Roy Schestowitz <r@xxxxxxxxxxxxxxx>
  • Date: Sat, 07 Oct 2006 16:21:48 +0100
  • Delivery-date: Sat, 07 Oct 2006 16:22:00 +0100
  • Envelope-to: s@schestowitz.com
  • In-reply-to: <FC8E41DC-51AB-4D6B-BBF9-D845749B0223@ftwr.co.uk>
  • References: <1160201374.6135.2.camel@sled10-laptop.mdcom-network.com> <FC8E41DC-51AB-4D6B-BBF9-D845749B0223@ftwr.co.uk>
  • User-agent: Internet Messaging Program (IMP) H3 (4.1.3)
___/ On Sat 07 Oct 2006 07:38:00 BST, [ Peter Westwood ] wrote : \___

On 7 Oct 2006, at 07:09, Michael K Dolan wrote:

I've looked through wp-db.php and it seems supporting an alternate
database (say db2, oracle or even postgresql) wouldn't be too
difficult... has anyone tried porting wp to another database before? Are
there other complications than changing the syntax to match a new

The main complication you will come accros will be mysqlisms in queries - either those in the core or those that plugins pump through $wpdb.

There have been attempts to port to sqlite

The best place to start is to write a extended version of the wpdb
class which uses the alternative database engine and converts any
mysqlisms in queries to work with the new database engine.

You code can be loaded in by the pluggable db code in 2.1
(http://trac.wordpress.org/changeset/4154 and

This is being discussed fairly regularly, e.g.:


Maybe it's worth inclusion in some FAQ under wp.org...? Also, it's bound
to become a serious problem from a political and a technical point of
view. I recently discussed this elsewhere, also in the context of
WordPress < http://tinyurl.com/s7kbt >. The sooner people get choice, the better, IMHO. Transparency is among one of WP's selling points. *smile*

Best wishes,


Roy S. Schestowitz, Ph.D. Candidate in Medical Biophysics
http://Schestowitz.com  |  GNU/Linux  |     PGP-Key: 0x74572E8E
http://othellomaster.com - GPL'd 3-D Othello
http://iuron.com - proposing a non-profit search engine

[Date Prev][Date Next][Thread Prev][Thread Next]
Author IndexDate IndexThread Index