| 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. |