By pcorbett on

I'm curious to know who uses PostgreSQL vs. MySQL vs. MSSQL? I'm assuming that since the current DB abstraction layer includes mysql, mysqli and pgsql that there should be a somewhat even distribution?

⋅ Categories: Drupal 5.x

Comments

davidkyte’s picture

davidkyte commented

I have a dedicated server - couple of years old - mysql 3.xx postgres 7.3
I use postgres not mysql because of the vast difference in the two products
at thse version levels. Drupal works on ver of postgres noy on vers of mysql.

I have such large installations that I can't spend time hoping between latest
os versions on linux

just my 2c worth ;-)

newz2000’s picture

newz2000 commented

I'd switch to postgres instead of mysql if I knew it would have the same level of module support as mysql does.

Postgres has a number of advantages and I use it for almost everything else I do. Only drupal and my blog use mysql.

newz2000 on freenode

Lyal’s picture

Lyal commented

Some of the larger installs that I've worked with have been on Postgres - (true or not) there's a perception of stronger enterprise level performance and functionality.

Also, some users who integrate with other applications that depend on Postgres often want to use it - quite a few applications in the transaction space are Postgres enabled.

Outcome3 Drupal Services
Vancouver Technology Guy

pcorbett’s picture

pcorbett commented

Just strange that PostgreSQL is included in the abstraction layer but MSSQL isn't... (well, for now anyway)