[Vtigercrm-developers] vtiger contribution question

[Jens Hamisch]

Hi,

please have a look at the 5.1_jens branch at first! This is
a 5.0.3 release sucessfully running on postgresql. 
This version is stable. The database fixes were introduced in
an early 5.0 prerelease. I'm running vtiger on postgres since
then.

Part of the patches were already implemented in 5.0GA. The rest
was posted to Richie/Don about 3 weeks ago.

JenS

On Wed, May 02, 2007 at 01:13:36PM +0200, Enrico Weigelt wrote:
> * Jens Hamisch <jens at Strawberry.COM> schrieb:
> 
> Hi,
> 
> > I already did a port to postgresql and have contributed my patches to
> > Don and Ritchie so far. I do not agree that the $adb->query_results are
> > broken as I'm running on postgresql since 5.0rc1 ...
> 
> well, I can only speak for the latest release and my trunk checkout 
> of last week.
> 
> a) several things in schema create needed to be fixed
> b) schema update (ie. ALTER TABLE ...) was totally broken
> c) the adodb Move() method was completely missing in the postgres driver
> 
> And the $adb->query_results() thing: 
> Well, it's and really bad idea (even if pgsql->Move() would work). 
> Too much complexity in- and outside, too long codepathes, too inefficient.
> 
> I've introduced some new query functions: 
> 
> * $adb->run_query_allrecords($query) 
>   -> returns the result in an array/list records (associative arrays)
> 
> * $adb->run_query_record($query)     
>   -> returns only the first record.
> 
> * $adb->run_query_field($query,$field) 
>   -> returns given field from the first record
> 
> * $adb->run_query_list($query,$field) 
>   -> returns an list of the values from given field.
> 
> Now I'm in the process of rewriting the calls to query_result() 
> to an appropriate of the new functions.
> 
> 
> cu
> -- 
> ---------------------------------------------------------------------
>  Enrico Weigelt    ==   metux IT service
> 
>   phone:     +49 36207 519931         www:       http://www.metux.de/
>   fax:       +49 36207 519932         email:     contact at metux.de
>   cellphone: +49 174 7066481
> ---------------------------------------------------------------------
>  -- DSL ab 0 Euro. -- statische IP -- UUCP -- Hosting -- Webshops --
> ---------------------------------------------------------------------
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com 

-- 

--------------------------------------------------------------------------------

         s t r a w b e r r y      e d v - s y s t e m e      g m b h

     SSSSSSSSS       Am Flosskanal 7            Jens Hamisch
   SSSSSSSSSSSSS     D-82515 Wolfratshausen     Geschaeftsfuehrer/CEO
  SSSSS-----SSSSS                               
 ---SSSSS---------   fon (+49 8171) 41805-0     
 -----SSSSSSS-----   fax (+49 8171) 41805-59    
 ---------SSSSS---   info at strawberry.com        jens.hamisch at strawberry.com
  SSSSS-----SSSSS                               mobil: (+49 172) 8104162
   SSSSSSSSSSSSS     Geschaeftsfuehrer/CEO      
     SSSSSSSSS       Jens Hamisch               
  
   a g   m u e n c h e n   H R B   9 3 2 8 7  -  D E   1 2 9  4 6 7  5 1 8