Обсуждение: MySQL to PostgreSQL for SugarCRM
From: Sergio A. Kessler [mailto:sak@kessler.com.ar]
Sent: Sat 7/30/2005 9:05 PM
To: Denis Lussier
Cc: pgsql-hackers@postgresql.org; pgsql-advocacy@postgresql.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.
>
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. >
On L, 2005-07-30 at 22:26 -0400, Denis Lussier wrote: > 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). You could also check out Conflux ( http://www.conflux.ee/ ), which is natively built on postgreSQL and mod_python. Like SugarCRM they have both free and commercial versions. I'm not sure how much CRM functionality the have the free (GPL) version, but they have also an up-to-5-user but otherwise unlimited trial of full version. -- Hannu Krosing <hannu@tm.ee>
Compiere also runs on PostgreSQL and has gotten some good press. It previously only support Oracle. Ken On Tue, Aug 02, 2005 at 08:53:52PM +0300, Hannu Krosing wrote: > On L, 2005-07-30 at 22:26 -0400, Denis Lussier wrote: > > 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). > > You could also check out Conflux ( http://www.conflux.ee/ ), which is > natively built on postgreSQL and mod_python. > > Like SugarCRM they have both free and commercial versions. > > I'm not sure how much CRM functionality the have the free (GPL) version, > but they have also an up-to-5-user but otherwise unlimited trial of full > version. > > -- > Hannu Krosing <hannu@tm.ee> > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly