Thread

1. Re: MySQL to PostgreSQL for SugarCRM

   Denis Lussier <denis@enterprisedb.com> — 2005-07-31T02:26:41Z

   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. 
   >  
   
   

2. Re: [HACKERS] MySQL to PostgreSQL for SugarCRM

   Hannu Krosing <hannu@tm.ee> — 2005-08-02T17:53:52Z

   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>
   
   

3. Re: [HACKERS] MySQL to PostgreSQL for SugarCRM

   Kenneth Marshall <ktm@it.is.rice.edu> — 2005-08-05T12:20:02Z

   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