From: Andrew S. <and...@pa...> - 2002-10-28 01:20:30
|
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 |
From: Dennis F. <de...@co...> - 2002-10-28 20:10:55
|
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 > |
From: Andrew S. <and...@pa...> - 2002-10-29 04:48:58
|
Hi all, Yes, sounds like a good plan. Just loaded the files into CVS (directory is org-mysql). There is a README file that gives some info on various things - and a bug list of bugs that I know of. None of them are too serious :-) Andrew On Mon, 28 Oct 2002 20:48:51 +0100 "Dennis Fleurbaaij" <de...@co...> wrote: > 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 > > |
From: Dennis F. <de...@co...> - 2002-10-29 08:24:56
|
Hi Andrew, Err that wasn't exactly what I meant I suppose :-) A branch is uploaded to the org release. I'll see if I can fix it but it might be a good idea to read the CVS braching notes ;-) Great stuff btw :) Cheers, Dennis ----- Original Message ----- From: "Andrew Simpson" <and...@pa...> To: "Dennis Fleurbaaij" <de...@co...>; <cor...@li...> Sent: Tuesday, October 29, 2002 5:48 AM Subject: Re: [Core-lan-org-devel] MySQL on Core-Lan-Org > Hi all, > > Yes, sounds like a good plan. > > Just loaded the files into CVS (directory is org-mysql). There is a > README file that gives some info on various things - and a bug list of > bugs that I know of. None of them are too serious :-) > > Andrew > > > On Mon, 28 Oct 2002 20:48:51 +0100 > "Dennis Fleurbaaij" <de...@co...> wrote: > > > 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 > > > > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > Core-lan-org-devel mailing list > Cor...@li... > https://lists.sourceforge.net/lists/listinfo/core-lan-org-devel > |