Re: [Core-lan-org-devel] MySQL on Core-Lan-Org

[Dennis F. <de...@co...>]

Hi Andrew,

Whoa great work!

Um, why not create a CVS branch, stabilize it and then we'll merge the 2.

Do you agree ?

Thanks for the work!,
Dennis


----- Original Message ----- 
From: "Andrew Simpson" <and...@pa...>
To: <cor...@li...>
Sent: Monday, October 28, 2002 2:20 AM
Subject: [Core-lan-org-devel] MySQL on Core-Lan-Org


> Hi all,
> 
> I've been having a go at getting Core to run on MySQL, and I think I'm
> mostly there.
> 
> Firstly, I made database abstraction layers for pgsql and mysql, and
> converted the main code to suit (Sorry Dennis, I didn't use your
> excellent work in the end).  Then I had to change some of the SQL
> queries to suit both MySQL and PostgreSQL - that bit hasn't been
> straightforward.  Big problems were subqueries and date manipulation in
> SQL.   Also the lack of OID in MySQL.  Used some SQL simplification and
> additional PHP code as workarounds.
> 
> I have converted the Core version that I use at work.  This is a mixture
> of released versions 1.11 and 2.02.  Notable differences to version 2.02
> are time estimation removed, and the database uses zero's instead of
> 'null'.
> 
> Both database types are up and running, and I estimate that I've fixed
> 95 % of the bugs (I hope).
> 
> If Dennis is agreeable I'll port my coding across to ver 2.02 in the CVS
> (I'm a bit suspicious on how MySQL is handling 'null' values though). 
> Alternately, I can dump my present version (1.11/2.02 hybrid) as a
> separate directory in CVS, for others to have a look at.
> 
> If anyone wants a copy in the interim, I can email the code to them.
> 
> Andrew       
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: ApacheCon, November 18-21 in
> Las Vegas (supported by COMDEX), the only Apache event to be
> fully supported by the ASF. http://www.apachecon.com
> _______________________________________________
> Core-lan-org-devel mailing list
> Cor...@li...
> https://lists.sourceforge.net/lists/listinfo/core-lan-org-devel
>