<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><BR>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid"><PRE>Message: 1
Date: Wed, 6 May 2009 11:36:05 -0500
From: Joseph He <joseph.he.2008@gmail.com>
Subject: [WindyCity-pm] Which one to go with, PostgreSQL and mySQL?
To: windycity-pm@pm.org
Message-ID:
<9c39a2a90905060936t19fa7554g932cef6abb9b2689@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Good day.
My feeling is that compare with PostgreSQL, mySQL is widely supported and
deployed by Perl hackers. Correct me if I am wrong.
With the recent drama, mySQL will be part of Oracle, so far the single
'dangerous' monopoly candidate in Database, which makes me have to
consider
which one to go with for new development. I don't have any PostgreSQL
experience and I don't care much about the 'benchmark', my concern
is among
Perl community, whether PostgreSQL is well supported as mySQL?
All advice is appreciated.
Joe
</PRE><PRE>To answer your question about PostgreSQL... I think it is very well supported.</PRE><PRE>As far as MySQL, I wouldn't rule it out just yet. I'd look at the available storage engines and compare them to PostgreSQL and pick what will work best for you.</PRE><PRE>MySQL is open source. There's a lot of really smart people in the MySQL community who will keep things moving in the right direction. One interesting project you may want to look at is MariaDB (see <A href="http://www.askmonty.org">http://www.askmonty.org</A> ). Monty is the original founder of MySQL. He left Sun a few months ago. Before he left, he had been working on a new storage engine called Maria. He's continued his development since leaving and actually has created a fork of MySQL called MariaDB. MariaDB is basically just MySQL with the maria storage engine. What's interesting though is that he has programmers working for
him and has stated that MariaDB will be much more stable than MySQL. I could definately see the community following MariaDB and that may be the future.</PRE><PRE>Another project to check out is Drizzle (see <A href="http://launchpad.net/drizzle">http://launchpad.net/drizzle</A> ). Some people call this a lightweight version of MySQL, but it's much more than that. Also, it's 100% developed by the community. It probably won't be production ready until next year, but it's worth checking out.</PRE></BLOCKQUOTE></td></tr></table><br>