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.
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:
Show quoted text
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:
Show quoted text
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.
Import Notes
Resolved by subject fallback
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
Show quoted text
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
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>
Import Notes
Resolved by subject fallback
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
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.
Show quoted text
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 SugarCRMOn 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:
Show quoted text
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 SugarCRMOn 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