Why do so many sites and apps still use MySQL when PostgreSQL is also free and, in many if not most respects, better?
I don't know much about postgres, but with MySQL, you can do clustering, replication and is more industry standard than postgres.
MySQL is much more widely installed on standard (i.e. cheap) virtual server web hosting. I think that's because, for a while around ten years ago, MySQL was actually more advanced and stable than Postgres.
+1
Though I hear that Postgress is enjoying a bit of a revival due to Oracle messing with MySQL, I am also seeing more use of Hadoop based databases, with additions to allow it to hold and manipulate structured data.

Jeez, I didn't know Oracle had taken over MySQL
*I have heard it said many times that postgesql is the faster one but the tools set up for postgresql were pretty crap if I am being honest. I have a comfort zone with using GUIs on the database rather than going commando with command line. THe more advaned the gui is probably one of my main judgment crireria for DB technology.
Now, when mySQL was taken on by SUN it was a natural fit, when mySQL went into proper database teritory with stored procs I honestly believe that Oracle shat a brick and bought SUN to hinder mySQL, what with plenty of big start ups going on about using mySQL.
THe old mySQL GUI was a great, then they upgaded it to a pile of cack. was that down to oracle?
I have heard it said many times that postgesql is the faster one but the tools set up for postgresql were pretty crap if I am being honest. I have a comfort zone with using GUIs on the database rather than going commando with command line. THe more advaned the gui is probably one of my main judgment crireria for DB technology.
Now, when mySQL was taken on by SUN it was a natural fit, when mySQL went into proper database teritory with stored procs I honestly believe that Oracle shat a brick and bought SUN to hinder mySQL, what with plenty of big start ups going on about using mySQL.
THe old mySQL GUI was a great, then they upgaded it to a pile of cack. was that down to oracle?