Re: MySQL to PostgreSQL for SugarCRM

Thanks, I'll check it out. I didn't see much evidence on the SugarCRM site that they are interested in an DB besides MySQL. But, it is also my hope that the core SugarCRM project will come around to supporting EDB/PostgreSQL (once we have done the port for them and committed to testing and maintaining it).

--Luss

________________________________

From: Sergio A. Kessler [mailto:sak(at)kessler(dot)com(dot)ar]
Sent: Sat 7/30/2005 9:05 PM
To: Denis Lussier
Cc: pgsql-hackers(at)postgresql(dot)org; pgsql-advocacy(at)postgresql(dot)org
Subject: Re: MySQL to PostgreSQL for SugarCRM

dennis, look at vtiger crm (http://www.vtiger.com)

vtiger is a fork of sugarcrm and are 100% commited to open source.
(unlike sugar, who offer the full version only for purchase)

and they actively want to support more databases.

regards,
/sak

Denis Lussier wrote:
> 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.
>