Thread: Re: [HACKERS] MySQL to PostgreSQL for SugarCRM
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>
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. SugarCRM is derived from the Mambo CMS, and we've just ported it to using ADOdb for database abstraction. Gosh it feels good to finally say it! :-D Anywhoo, depending on how early SugarCRM forked from Mambo, we introduced a database class in the 4.5.x series that makes it somewhat straightforward to implement for other databases. I have no idea what SugarCRM has done in this regard, or if they have taken any efforts to consolidate their SQL statements into a class for easier migration. Would be interested in hearing from SugarCRM about their plans in this regard, and will hunt them down next week at LinuxWorld in SFO. -- Mitch Pirtle Mambo Core Developer
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 > >
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>