[WindyCity-pm] WindyCity-pm Digest, Vol 29, Issue 2

[Jeremy Glick]

Message: 1
Date: Wed, 6 May 2009 11:36:05 -0500
From: Joseph He <joseph.he.2008 at gmail.com>
Subject: [WindyCity-pm] Which one to go with, PostgreSQL and mySQL?
To: windycity-pm at pm.org
Message-ID:
	<9c39a2a90905060936t19fa7554g932cef6abb9b2689 at 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
To answer your question about PostgreSQL...  I think it is very well supported.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.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 http://www.askmonty.org ).  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.Another project to check out is Drizzle (see http://launchpad.net/drizzle ).  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.


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/windycity-pm/attachments/20090506/cb35af46/attachment.html>