MySQL vs PostgreSQL vs MS SQL

surreality · #1 (**permalink**) 06-21-09, 10:14

I know that I'm probably opening a can of worms with this thread, but it's really just a simple poll to find out which database system you like best. I originally intended it to contain only MySQL and PostgreSQL, but in the interest of fairness, I added MS SQL into the mix as well. Vote away, and please be sure to explain your vote.

kirkas · #2 (**permalink**) 06-21-09, 12:39

I'll be honest, I'm rather biased here as I've never used MS SQL and have only tried PgSQL a few times, and never seriously. But from what I've tried, PostgreSQL was slower, so MySQL gets my vote.

Martin · #3 (**permalink**) 06-21-09, 13:48

One more vote for MySQL!

I use MySQL, it is simpler and easy to be managed. The reason I vote for MySQL is that any hosting provider offer Unlimited MySQL Databases whereas we have some restriction on the size or number of databases for MSSQL.

PostgreSQL has few more features than MySQL, still I would prefer MySQL only.

Jonathan · #4 (**permalink**) 12-12-09, 15:43

MySQL is always my choice. There is a lot of free scripts that work well with it. I remember back in the day when I had to do some nasty migration from MS SQL to MySQL... from there on its MySQL in my book.

CustomServer · #5 (**permalink**) 12-15-09, 04:24

I like MySQL the best because it works with every script that I use on my sites, which is not the case with MS SQL and PostgreSQL.

Zohann · #6 (**permalink**) 06-23-10, 05:38

I'm not an expert and surely I'm not a database expert but I do know a few tricks with MySQL so that is my weapon of choice.

Crazzy · #7 (**permalink**) 06-23-10, 06:27

Quote:

Originally Posted by Zohann

I'm not an expert and surely I'm not a database expert but I do know a few tricks with MySQL so that is my weapon of choice.

I'm too not an expert but I know what my scripts need.

I don't even think that you need to be an expert to touch up some things because there are tutorials everywhere.

RicherdsFi · #8 (**permalink**) 08-11-10, 14:04

I'll admit, I'm a MySQL lover. I know I should probably expand out and learn more and become a crazy genius, but MySQL does the job, so why switch is my thinking.

Rebecca · #9 (**permalink**) 08-19-10, 23:42

I think most of them prefer mysql only because that is the one they have used. I have read postgreysql has more features when compared with mysql.