3 ms·
I think MySQL's edge is just that is was initially perceived to be simpler to set up. Perhaps that is true or not, but the perception was created. The result
by jakejake 14y ago
I think MySQL's edge is just that is was initially perceived to be simpler to set up. Perhaps that is true or not, but the perception was created. The result was a massive head start. You now have a huge pool of users, support and knowledge, which makes it a safe choice. (notice I say safe, not necessarily the best)
Outside of the startup community developers don't have such a great appetite for risk, especially with their data.
I'm one of those people - I just know My SQL better. It has nothing to do with ease of installation or building queries. It has to do with troubleshooting. I know how to tune MySQL and troubleshoot. I know how to install and use other systems but it introduces risk for me to put them into production without a very compelling reason.
I would happily use another system if there were a db admin to take responsibility for running the server. In fact my favorite db is Oracle, but I have no experience as DB admin on that platform.
- PaulHoule 14y agoI can say that postgres made overblown claims for their products in the late 90's. They'd use FUD to scare people away from MySQL, but two times I had a "Dude Where's my Data" experience with PostgreSQL which sent me back to MySQL. I was involved with one project with PostgresSQL that was successful around 2005. I did 5 "shootouts" of DBMS alternatives that considered PostgresSQL and other products for various projects and despite having some attractive features, PostgresSQL always lost out. For instance, in mysql I was able to create indexes that could handle Freebase text fields without any "impeadance mismatch and it wasn't clear how to do it with pgsql.