Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By cnelson on
My agency is getting ready to implement Drupal as a replacement for our PHP/PostNuke solution. I am a network engineer by design... but will be supporting this solution (Windows server with apache) We also have a windows SQL database server available...so my question is this.
Which database should we use for Drupal? I know MySQL, MS SQL, and PostGRESQL, claim to be supported... but which once will be easiest to implement and maintain with Drupal? What levels of community support and resources are available ?
Please advise and thanks,
Chris
Comments
M is for MySQL
I am not a DBA, nore do I know much about databases. But most drupal installs are based on LAM(p). So if the number of people using it in a way, is a criteria, I would say go for Linux, Apache and MySQL. If your IT department has less knowledge about Linux, Windows with apache (or even IIS) might be considered.
The advantags of using a comon environment (Linux, MySQL) are that most problems have been delt with by other people and most deveolpment is tested on it.
,--
groets
bertb
--
groets
bert boerland
IIS and Windows work just fine
Drupal works out of the box on Windows and IIS .... To answer the original question, I would definately go for MySQL. There are few contributed modules which are known to work with Postgres and even fewer with MSSQL.
If you ask thirty different p
If you ask thirty different people this question, you'll get thirty different answers. It's relatively equivalent to "vi or emacs?!", "mac or windows?!", etc., etc. With that said, some comments. If you're looking for community support, stay away from MS SQL - most Drupal users are LAMPers. As for PostgreSQL and MySQL, you'll probably find more community support for MySQL, though PostgresSQL is often considered "better" (in the same way that Pepsi tastes "better" to richer people than Coca Cola). You'll often hear a lot of people say that PostgreSQL scales better for heavy installations, and that PostgreSQL has more database features (technically, it does, but Drupal doesn't use any of them), but Yahoo! seems to be getting along just fine with their MySQL installation (in fact, one of the guy's who works at Yahoo! with MySQL recently released an O'Reilly book called "High Performance MySQL"). If it were up to me, I'd say MySQL.
http://disobey.com/
http://gamegrene.com/
http://www.disobey.com/
MS SQL isn't supported anymor
MS SQL isn't supported anymore.
--
Drupal services
My Drupal services
+1 for MySQL. The basic ques
+1 for MySQL. The basic question for most Drupal installations is between MySQL and PostgreSQL. PostgreSQL, from my experience, has a higher learning curve, and most module developers in this community support MySQL primarily, and PostgreSQL secondarily. Additionally, Drupal doesn't use any of the features that you would normally choose PostgreSQL for.
E is for Enlightened....
Thanks everyone...... I think I will recommend MySQL in the absence of any glaring problems.