Thread: 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>

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