At EnterpriseDB we're doing a
little project along these lines. In our lab, and soon for our
company, we are running SugarCRM on EDB-Postgres. Alas you say, but
SugarCRM only supports MySQL:
EDB ships a nifty java based ETL tool with
our product that is 99.5% based on the Enhydra Octopus LGPL project.
This allows for easily converting schema and data from a populated
MySQL SugarCRM database into Postgres. Then we hacked the PHP code
of SugarCRM for a couple days and it is now working just fine on
EDB-Postgres.
I think that whenever we come
across an Open Source (or even a commercial\proprietary product) out there
that supports MySQL, but not PostgreSQL... We need to work collectively as
a group to make it shamefully simple for the project to work with PostgreSQL
also. SugarCRM has 250,000 downloads and every single one of those
customers is guaranteed to be introduced to MySQL and only MySQL.
--Luss
PS1 Yes, we are going to try and work with
the SugarCRM folks and get Postgres supported natively without customers having
to hack the way we did to get it working.
PS2 I've hired many interns for summer and/or
co-op jobs over the years. The trick is to give them something interesting
to do AND pay them a little more than they can make flipping
burgers.
