Could you please point me the right place to check ? Couldn't find it...
I was thinking of this post: http://forum.joomla.org/index.php/topic,142051.0.html
which is about a (working?) MSSQL database class.
Pe7er mentioned some in http://forum.joomla.org/index.php/topic,180358.0.html
and maybe http://joomlacode.org/gf/project/msconnect/
The PDO developer's confession: "I've been talking about this for years, and now I am in the position to actually do something about it. "
Since all DB vendors invent extensions to the ANSI/ISO standards, and improve their own engines with each version, teaching it new tricks, one will always run into trouble with literal sql code -- you don't need CONCAT_WS() to break a query, a simple LIMIT will do.
At the end you need a "sql builder" like those provided by Zend_Db or PEAR::MDB which adds another layer in between your application and the database, and you'd never be able to use the full power of a specific db engine w/o using "proprietary" code.
You probably do have a reason for wanting PostgreSQL support, and somehow I doubt it's because of writing standards compliant SQL code *only*.
Maybe it's habit, maybe you believe PSQL is better, maybe you like it's "SQL features", maybe it's because your ISP or those of your clients, only provide PostgreSQL servers.
All of this made me use MySQL for some 10+ yrs, depite I am in the lucky position to have access to an environment that'd allow me to run any other db server as well. Unfortunately I can't "pull" every of my clients to this environment; I don't even want to.
Additionally, if 3d Parties would like to use their own database as a backend for their components/modules/whatsoever, it is not a problem! They still can, because it doesn't matter, by means of Joomla! doesn't care about what DB storage components are using, does it?
well, as I regular user I'd consider this indeed a huge problem, if my ISP simply doesn't support the 3PD's choice of server. I'd be realy pi$$ed if my whole site runs fine with MySQL and this one nice-to-have extension would require another engine; why doesn't this 3PD support MySQL, or to stick with your argument, "standards SQL" for that matter?
Joomla! might hypothetically not bother should it support different servers some day in the future, but if there's no such server to connect to, it doesn't help neither that 3pd developer (to sell his extensiion) nor the user (me) who might want to use it.
Lots of ISPs (at least in Germany) provide MySQL only, some PostgreSQL per individual request. MSSQL on the ther hand appears to be a bigger issue for Intranet sites and host running ASP sites.
It's not like each J! user has access to a dedicated server, so their choices are usually pretty limited.
Don't get me wrong, I agree with you, and I see the benefit and a need for this. It's just that I don't happen to have this need.
And for the records: you're preaching to the choir, but you're also barking the wrong tree
There's nothing I can do to change this.