By most measures, PostgreSQL and other members of the Postgres family are superior database management systems to MySQL. They're more functional, more scalable, and easier to program. Even so, MySQL has much more market/mind share than Postgres, and the reasons aren't solely mass insanity.
Let's start by reviewing some of the leading knocks against MySQL:
But there are also some strong plusses on MySQL's ledger:
As for Postgres:
Frankly, I like advanced DBMS features, such as robust support for various kinds of datatype. So whenever it makes reasonable sense, I'd favor using the Postgres family.
Curt Monash is a leading analyst of and strategic advisor to the software industry. Praised by Lawrence J. Ellison for his "unmatched insight into technology and marketplace trends," Curt was the software/services industry's #1 ranked stock analyst while at PaineWebber, Inc., where he served as a First Vice President until 1987. He subsequently co-founded Evernet, Inc., a $40 million networking systems integrator. Since 1990, he has owned and operated Monash Research, an analysis and advisory firm covering software-intensive sectors of the technology industry. In that period he also has been co-founder, president, or chairman of several other technology startups.
Curt has served as a strategic advisor to many well-known firms, including Oracle, Microsoft, SAP, AOL, CA, and Netezza. Curt earned a Ph.D. in mathematics (Game Theory) from Harvard University. He has held faculty positions in mathematics, economics and public policy at Harvard, Yale, and Suffolk universities.