On Friday 29 March 2013 10:12:39 am Fred Gleason wrote: > My rationale for MySQL has always been primarily pragmatic -- it works well, > has a large community of users that understand it well and offers key > high-end features --e.g. replication -- that are critical for use in HA > environments. Above all, it has proven itself to be utterly reliable over > 10+ years of use with RD -- I can't recall a single instance of data > corruption over that time that was traceable to bug in it. I honestly don't > know all that much about PostgreSQL and the other alternatives because I've > never needed to -- MySQL 'just works'.
Traditionally, the differences have been.... Postgres had the high end features and reliability, at some expense in speed. MySQL had speed, at the expense of features and reliability. Postgres was cross-platform when MySQL wasn't. In the last ten years or so those differences have blurred considerably. Configure each correctly, ( probably not default ) and there's almost no difference in performance. MySQL has become more reliable, and added features, while Postgres speed has been significantly increased. Today, it's primarily license and preference. Both are commercially supported, Postgres perhaps a little more so. MySQL is GPL, and Postgres is a less limiting BSD, almost public domain. -- Cowboy http://cowboy.cwf1.com "Love is an ideal thing, marriage a real thing; a confusion of the real with the ideal never goes unpunished." -- Goethe _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
