Countless times I needed to bother with PostgreSQL pecularities. I have nothing against PostgreSQL in a technical manner but neither the market nor our community has the human resources to support it. Let's face it: years come and go and the various PostgreSQL maintainers became busy with something else. This is not different from the outside world -- I can get highly professional MySQL help for a hundred bucks an hour, even our sysadmins know quite enough to get around with it but even when we payed three hundred bucks to the consultancy company one of the authors of pgsql, support still was lacking.
We have a horrible prospect on the horizon: supporting database system which are used by even smaller percentage of our community.
I am now officially against the pipe dream of database abstraction. It does not exist, SQL is just not standard enough despite all appearances. I want Drupal core to work with MySQL and that's it. Do you want to know the truth? This is already the state of affairs just noone admits it. Prove me wrong -- contact me if the number of hours you spent on testing Drupal 6 with PostgreSQL is bigger than twenty. Please be aware that I will probably publish your email.
We need to keep our
db_* functions so if you want to do something different in a contrib database driver, then you can. We might want to use PDO to make the contrib authors' work easier, our system better (by standardizing on placeholders), but I do not want to do any more work because we pretend to support other databases. Use preg_replace on the queries or whatever, I do not want to care any more.
Commenting on this Story is closed.