Re: [HACKERS] MySQL to PostgreSQL for SugarCRM

2005-08-09 Thread Jake Stride
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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED]
 Sent: Tue 8/2/2005 1:53 PM
 To: Denis Lussier
 Cc: Sergio A. Kessler; pgsql-hackers@postgresql.org;
 [EMAIL PROTECTED]
 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 [EMAIL PROTECTED]

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


Re: [HACKERS] MySQL to PostgreSQL for SugarCRM

2005-08-09 Thread Dave Cramer
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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED]
Sent: Tue 8/2/2005 1:53 PM
To: Denis Lussier
Cc: Sergio A. Kessler; pgsql-hackers@postgresql.org;
[EMAIL PROTECTED]
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 [EMAIL PROTECTED]



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





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


Re: [pgsql-advocacy] [HACKERS] MySQL to PostgreSQL for SugarCRM

2005-08-09 Thread Kenneth Marshall
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 [EMAIL PROTECTED]
 
 ---(end of broadcast)---
 TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [HACKERS] MySQL to PostgreSQL for SugarCRM

2005-08-05 Thread Denis Lussier
Title: 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 Architectand 
Chairman
 http://ww.enterprisedb.com



From: Hannu Krosing 
[mailto:[EMAIL PROTECTED]Sent: Tue 8/2/2005 1:53 PMTo: Denis 
LussierCc: Sergio A. Kessler; pgsql-hackers@postgresql.org; 
[EMAIL PROTECTED]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 
[EMAIL PROTECTED] 




Re: [HACKERS] MySQL to PostgreSQL for SugarCRM

2005-08-04 Thread Sergio A. Kessler

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.
 



---(end of broadcast)---
TIP 6: explain analyze is your friend


Re: [HACKERS] MySQL to PostgreSQL for SugarCRM

2005-08-03 Thread Hannu Krosing
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 [EMAIL PROTECTED]

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings


Re: [HACKERS] MySQL to PostgreSQL for SugarCRM

2005-07-30 Thread Denis Lussier
Title: Re: MySQL to PostgreSQL for SugarCRM






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:[EMAIL PROTECTED]Sent: Sat 7/30/2005 9:05 PMTo: 
Denis LussierCc: pgsql-hackers@postgresql.org; 
[EMAIL PROTECTED]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.  





[HACKERS] MySQL to PostgreSQL for SugarCRM

2005-07-28 Thread Denis Lussier
Title: Re: [pgsql-advocacy] MySQL to PostgreSQL, was ENUM type






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 OctopusLGPL project. 
Thisallows foreasily 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 wecome 
acrossan 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.