[wp-hackers] Making WordPress database independent

[Brian Layman]

On 2/7/2011 1:35 PM, Piyush Mishra wrote:
> Why not just take it to the point where we make a clean interface and
> implement it in mysql and let the users write and share their implementation
> for other databases. with time and testing, we can choose to integrate the
> more popular and stable ones?
> btw wont using the db.php need making something close to having POT kinda
> files for queries for dbmses which have different SQL (oracle can be a good
> example though am not sure if anyone will use it)
Using a db.php drop-in is good enough for a proof of concept though 
isn't it? HyperDB is a good example of how do start this.  It extends 
wpdb and overrides db_connect:
http://svn.wp-plugins.org/hyperdb/trunk/db.php

Just swap in NewADOConnection for mysql_connect and Bob's your uncle.    
Ok so you'll want to do more than that, but if the proof of concept 
spread like wildfire, there would be more people interested in coding a 
more closely integrated solution.

-- 
Brian Layman
http://eHermitsInc.com
Managed WordPress Hosting