[wp-hackers] port of 2.1 to postgresql

[Computer Guru]

To be fair: EzSQL does a GREAT job of database abstraction and works just
fine with both MySQL & pgSQL, along with a number of other RDBMS.

I've set up many db-independent scripts with EzSQL -- including pagination
functions/features too that work just fine with all RDBMS supported by
EzSQL.

The reason why WP doesn't use PEAR or AdoDB is because of overhead and
performance - but seeing as WP uses EzSQL for MySQL access *anyway*, I don't
see that the usual reply "it's overhead" would apply to using
EzSQL-supported RDBMS with WP. 

Computer Guru
NeoSmart Technologies
http://neosmart.net/blog/

> -----Original Message-----
> From: wp-hackers-bounces at lists.automattic.com [mailto:wp-hackers-
> bounces at lists.automattic.com] On Behalf Of Alex Günsche
> Sent: Thursday, March 15, 2007 10:51 AM
> To: wp-hackers at lists.automattic.com
> Subject: Re: [wp-hackers] port of 2.1 to postgresql
> 
> On Thu, 2007-03-15 at 09:18 +0100, Martin Sturm wrote:
> > Why doesn't Wordpress support multiple databases? I understand that
> it
> > requires some changes to the archtecture, but it is a very useful
> > feature I think.
> 
> It's also a matter of plugins. It would be much harder for plugin
> authors to write their plugins for different RDBMS. Yes, there is a
> database API with the $wpdb class, still there are a couple of plugins
> that either work with special MySQL features or that modify the SQL
> query which itself is MySQL specific.
> 
> For example, if you have a plugin that takes advantage of MySQL's
> FULLTEXT index feature, you will have a hard time providing a similar
> functionality in PSQL. Or, consider WP's SQL queries themselves: For
> example, they use SQL_CALC_FOUND_ROWS for pagination (a proprietary
> extension by MySQL), and each plugin that modifies the actual SQL query
> must consider this.
> 
> 
> Regards,
> Alex
> 
> --
> Alex Günsche, Zirona OpenSource-Consulting
> work: http://www.zirona.com/ | leisure: http://www.roggenrohl.net
> PubKey for this address: http://www.zirona.com/misc/ag.ml2007.asc
> 
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers