MySQL to PostgreSQL for SugarCRM - Mailing list pgsql-advocacy

From Denis Lussier
Subject MySQL to PostgreSQL for SugarCRM
Date
Msg-id B319CFEC3B80D3408CA36F99ADE840940F2A06@edb-dc1.Edb-net.EnterpriseDB.com
Whole thread Raw
Responses Re: MySQL to PostgreSQL for SugarCRM  ("Sergio A. Kessler" <sak@kessler.com.ar>)
List pgsql-advocacy
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.
 

pgsql-advocacy by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: MySQL to PostgreSQL, was ENUM type
Next
From: Robert Bernier
Date:
Subject: schmooing at oscon