MySQL to PostgreSQL for SugarCRM

From: "Denis Lussier" <denis(at)enterprisedb(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-advocacy(at)postgresql(dot)org>
Subject: MySQL to PostgreSQL for SugarCRM
Date: 2005-07-28 22:52:57
Message-ID: B319CFEC3B80D3408CA36F99ADE840940F2A06@edb-dc1.Edb-net.EnterpriseDB.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers

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.

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Robert Bernier 2005-07-28 23:55:14 schmooing at oscon
Previous Message Joshua D. Drake 2005-07-28 21:56:03 Re: MySQL to PostgreSQL, was ENUM type

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Wong 2005-07-28 23:15:31 Re: [Testperf-general] dbt2 & opteron performance
Previous Message Jim C. Nasby 2005-07-28 22:19:34 Re: [Testperf-general] dbt2 & opteron performance