Khalid Baheyeldin wrote:
>> 'The minority' is something I am hearing all the
time. Do we have
>> numbers that can give us any statistics about the
amount of systems
>> using drupal and postgresql? Because I suspect that
they are not as few
>> as some would like them to be.
>>
>
> This is what we have. You can see it is quite a
minority.
>
> http://groups.drup
al.org/node/6164
>
> Even if the above data was not available, and
PostgreSQL is a majority, it
> it is still a moot point.
>
> Every year, we have a new maintainer, then he
disappears. I don't think we
> even have one at present.
>
> The fact that it is a challenge to get people to test
and push PostgreSQL
> patches
> through the patch queue is the big hindrance.
Well, if we could say that the data in this page "What
DB drives your
Drupal?" is representative, a 11% of the users is a
minority, but we are
talking about around 66.000 (11% of 600.000 downloads)
websites if the
data in http://buytaert.ne
t/tag/statistics is also representative.
You don't know neither what kind of users are these 60.000.
Are they
running large, corporate or intratet sites or small local
websites at
home? I have the feeling that we are not talking about small
systems here.
My point is that I think that stopping supporting postgresql
is a bad,
bad idea and it would get many supporters/users upset.
You already have a database abstraction layer. The only
problem here is
the different SQL statements send to the database. More use
of standard
SQL insteed of MySQL specific statements will help to
minimize the
differents between the two databases regarding the code. We
could even
use other ways of interacting with the database, like stored
procedures,
but this is another discussion.
I am also sure that many postgresql DBAs will help with this
issue if it
gets easier to do this. For example, I do not have time to
learn the
internals of Drupal's code (I am a DBA), but it will be a
pleasure to
help if I could get a list with all SQL statements send to
the database
and a test-case database with test data. It would take us
very little
time to find out and fix specific MySQL SQL statements that
will have
problems running on postgresql.
My 5 cents ..... Let's make a great product like Drupal even
better
insteed of destroying his good reputation.
regards
--
Rafael Martinez, <r.m.guerrero usit.uio.no>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
|
