Обсуждение: MySQL to PostgreSQL for SugarCRM
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.
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@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.
>
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>
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. >
I'm currently most interested in getting SugarCRM working natively on Postgres. Does anybody know a good CRM package that is BSD all the way through?? It is great that there are many CRM packages that already support the worlds most advanced open source database.
I am sure that SugarCRM is wildly popular these days as an "enterprise-class" open source alternative AND that it is presently only officially supported on MySQL. I believe that Postgres and/or EDB-Postgres ought to be the database of choice for all SugarCRM customers who love their data.
--Denis Lussier
Chief Architect and Chairman
From: Hannu Krosing [mailto:hannu@tm.ee]
Sent: Tue 8/2/2005 1:53 PM
To: Denis Lussier
Cc: Sergio A. Kessler; pgsql-hackers@postgresql.org; pgsql-advocacy@postgresql.org
Subject: Re: [HACKERS] MySQL to PostgreSQL for SugarCRM
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>
Well we have a CRM package that does ERP/project management/ticketing/file sharing etc as well, called EGS http://egs.sourceforge.net. Although the sf.net page is out of date we are about to release 1.0 on 1st september to great fanfare! With a new website et al. It works out of the box on postgres although should work on others becuase of the DB abstraction layer. It is also being used by several companies around the World and is released under the GPL by the company I work for. If anyone is interested I can give you access to our demo/subversion repositry please contact me off list if you do and I can give you details. On 8/5/05, Denis Lussier <denis@enterprisedb.com> wrote: > > > I'm currently most interested in getting SugarCRM working natively on > Postgres. Does anybody know a good CRM package that is BSD all the way > through?? It is great that there are many CRM packages that already support > the worlds most advanced open source database. > > I am sure that SugarCRM is wildly popular these days as an > "enterprise-class" open source alternative AND that it is presently only > officially supported on MySQL. I believe that Postgres and/or EDB-Postgres > ought to be the database of choice for all SugarCRM customers who love their > data. > > --Denis Lussier > Chief Architect and Chairman > http://ww.enterprisedb.com > > > ________________________________ > From: Hannu Krosing [mailto:hannu@tm.ee] > Sent: Tue 8/2/2005 1:53 PM > To: Denis Lussier > Cc: Sergio A. Kessler; pgsql-hackers@postgresql.org; > pgsql-advocacy@postgresql.org > Subject: Re: [HACKERS] MySQL to PostgreSQL for SugarCRM > > > > > 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>
I think the point Denis is trying to make is that postgresql will get much more exposure if SugarCRM works with it out of the box. Not taking away from any of these other great projects, but to get mindshare postgresql needs to work with existing projects. Dave On 9-Aug-05, at 7:55 AM, Jake Stride wrote: > Well we have a CRM package that does ERP/project > management/ticketing/file sharing etc as well, called EGS > http://egs.sourceforge.net. Although the sf.net page is out of date we > are about to release 1.0 on 1st september to great fanfare! With a new > website et al. It works out of the box on postgres although should > work on others becuase of the DB abstraction layer. It is also being > used by several companies around the World and is released under the > GPL by the company I work for. > > If anyone is interested I can give you access to our demo/subversion > repositry please contact me off list if you do and I can give you > details. > > On 8/5/05, Denis Lussier <denis@enterprisedb.com> wrote: > >> >> >> I'm currently most interested in getting SugarCRM working natively on >> Postgres. Does anybody know a good CRM package that is BSD all the >> way >> through?? It is great that there are many CRM packages that >> already support >> the worlds most advanced open source database. >> >> I am sure that SugarCRM is wildly popular these days as an >> "enterprise-class" open source alternative AND that it is >> presently only >> officially supported on MySQL. I believe that Postgres and/or >> EDB-Postgres >> ought to be the database of choice for all SugarCRM customers who >> love their >> data. >> >> --Denis Lussier >> Chief Architect and Chairman >> http://ww.enterprisedb.com >> >> >> ________________________________ >> From: Hannu Krosing [mailto:hannu@tm.ee] >> Sent: Tue 8/2/2005 1:53 PM >> To: Denis Lussier >> Cc: Sergio A. Kessler; pgsql-hackers@postgresql.org; >> pgsql-advocacy@postgresql.org >> Subject: Re: [HACKERS] MySQL to PostgreSQL for SugarCRM >> >> >> >> >> 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 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > >
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