backend db to PostgreSQL

[sajo]

Hi all,
I want to change the backend database to postgres. how do i change the backend db. need some help .. where do i start. what are things i should care.. please give me suggesions...
looking forward for your replay..
regards
Sajo

[julian]

Hello Sajo,

Look at the ./include/database/ directory, where our abstraction layer exists. Check out these existing threads:

http://www.sugarcrm.com/forums/showt...ght=postgresql
http://www.sugarcrm.com/forums/showt...ght=postgresql
http://www.sugarcrm.com/forums/showt...ght=postgresql

[Deuce]

Sorry to resurrect an old thread....
I've been working on adding postgres support, and have added working pgsqlHelper.php and pgsqlManager.php files to the abstraction layer and postgres support to the installer. I got it to install OK, and can log in, but... One problem I'm running into is that postgres requires the AS keyword when a table or field name is aliased in a query, while in mssql and mysql it is optional. The code is full of queries where field names are aliased, and I found some code that builds the queries in SugarBean.php that looks like it should handle aliases - problem is, it looks like the passed in fild array always has the 'alias' empty. Anyone have an idea where else the alias handling may be taking place?

Edit -- nevermid, I found it. Lots of files to port still and some bugs to fix, but 4.5.0h now runs on PostgreSQL

[rgodoy]

I'm not sure how much progress has done the postgresq project on sugarforge, but your work is promising. I'm also willing to have full postgresql support on SugarCRM, this would really make a full enterprise-ready solution.

I hope Sugar team members take in count this and allow your contribution to be included on the next releases.
Good work!

[Deuce]

Thanks for the kind words. In case anyone's interested, I uploaded the Postgres files in this thread:
http://www.sugarcrm.com/forums/showthread.php?t=20138

[susiewilliams]

Hi Deuce,


Please consider making a SugarForge project out of this code. It would be an excellent candidate for one. You can create the project via this link.

-Susie W.

[Deuce]

Hi Susie,
I considered that, but due to the huge number of core files I had to modify to get it to work, it wouldn't be practical - a Sugar update would likely break everything, and since I don't have much time to support it this would be a disservice to the Sugar community. I was kind of hoping someone would take these files and run with it