4 ms·
MySQL is easier to install, much simpler to use, easier to manage and most importantly every little issue has been solved online many, many times over. It's a k
by taligent 14y ago
MySQL is easier to install, much simpler to use, easier to manage and most importantly every little issue has been solved online many, many times over. It's a known quantity.
Fact is that simplicity is more important than features for most people.
- bbwharris 14y agoInstallation? All modern Linuxes have package managers that make installation a headache of the past. Configuration is a different story. When you are done with a Postgres config you have a more secure setup. They don't allow you to shoot yourself in the foot by default. Honestly, installation as a differentiator between databases is a seriously weak argument. If you're going to troll pick something a little more technical like acid compliance or something else that nobody seems to care about.
- taligent 14y agoYou don't like my argument so I am trolling ? Nice. And you ignored Windows, Mac as well as the huge number of LAMP based installers. Being able to quickly get the entire stack up and running very much helped the popularity of MySQL.
- bbwharris 14y agoI agree with you on the development setup. Production setup is about the same. Meant no offense. Seemed trollish but when you factor in development setup then yes MySQL is slightly easier. I think heroku is doing a good job making Postgres a snap.
- snupples 14y agoYou keep saying this, but in my recent experience, postgres had been fantastically easy to get up and running on both Windows and Linux (debian and ubuntu to be precise. don't know about Mac). So this argument only applies possibly to its distant past. It's simply not relevant now. It's worth keeping an open mind.
- jeltz 14y agoInstallation of PostgreSQL are in my experience no harder than for MySQL. As for management and usage I would say PostgreSQL is simpler because it has a much better command line with excellent error messages and good tab completion. The backslash commands of psql are a bit confusing at first, but so are MySQL's SHOW commands and once you get used to the backslash commands they are very powerful.
- jeffdavis 14y agoRegarding installation and ease of use, can you be more specific? I see this complaint frequently but, as a postgresql user, it's hard for me to see where the difficulty for new users is and what should be done about it.