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

[Andrew S. <and...@pa...>]

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