[wp-hackers] port of 2.1 to postgresql

[Dave Cramer]

On 16-Mar-07, at 7:27 AM, Sabin Iacob wrote:

> Charles Hooper wrote:
>> -1 for supporting multiple DBMSs. Alot of queries would have to be  
>> re-written to be strictly ANSI SQL compliant, which pretty much  
>> defeats the whole purpose of using one DBMS over another. I say we  
>> keep it strictly MySQL in order to take full advantage of MySQL's  
>> features.
>
> If you only touch the database in one point (say, in db.php), it  
> can be made pluggable; all one needs to do is implement the  
> database API for their DBMS of choice, using the whole feature set  
> they need, not ANSI SQL. This is different from using a generic  
> database access layer like adodb or creole. And I consider it  
> extremely bad practice to have SQL guts scattered all over,  
> especially in plugins, anyway.
I can tell you that this isn't the case, sql code is *everywhere* :(
>
> So, as I see it, Wordpress should support MySQL by default, but  
> allow for people to provide alternative implementations. It is  
> doable, and as far as I've seen there is an ongoing process of  
> cleaning up the mess and replacing SQL code with API calls, so the  
> future looks good :P
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>