Hacker News new | ask | show | jobs
by awj 4698 days ago
For a long time MySQL was easier to get started with, and the integration with PHP made it a popular choice on shared hosting services. A lot of developers cut their teeth on MySQL, many haven't felt the need to seek out alternatives.
1 comments
_ea1k 4698 days ago
Yeah, for a long time MySQL was completely easy on Windows, and Postgres required Cygwin. Granted, that was years ago now, but I think it hurt adoption significantly.

Also, there has long been a perception that Postgres was slower. I still run into that from time to time today.

link
tracker1 4697 days ago
Sometimes early adoptions in technology establish the trend long term.

Personally, I was rather put off by earlier mySQL versions on windows, that required commercial licenses for windows, but was free on other platforms. Also, the their weird perception of software connecting to mysql needing to be gpl, or commercially licensed (legally or not, it was an f'd up pov).

Each time I used mySQL was an oddity... a binary field would effectively treat the ascii value of a byte as a case-insensitive character... You could use ANSI SQL field quotes for everything but foreign key statements... Curly ticks, not just the ascii apostrophe could break you out of an SQL statement...

Now, these may well all be fixed today, I just find it hard to believe a lot of these issues didn't break MySQL's adoption rates by others.

What surprises me even more than PostgreSQL's lack of broader adoption was that FirebirdSQL didn't see wider adoption all along either. Considering it works in both embedded and stand alone server roles. I really just don't get why people like mySQL... I mean if you are using it as a mostly write dump table (myisam) without the need for foreign keys, sure... but anything with more than 3-4 tables, I just can't see why someone would chose mySQL over many other better, and free options.

Beyond some early adoption along with PHP (another hideous platform imho) that happened to stick, and spread.

link
awj 4697 days ago
Yeah, we're in the process of migrating from MySQL to PostgreSQL now. I don't think any other project at work has kept me up at night as much as this one.
link