[Cdeengine-chat] Inital Welcome & Tasking for the Cross Database Engine Team

[Andre v. Z. <an...@sp...>]

Welcome everyone, currently we're a team of 5 and here is how I propose 
we forward the project.

I will be leading the development and help test what everyone is busy 
developing.

Ivan Cat will be heading up the PostGres development  & functionality 
and helping with the releases of the project

Ashraf will be heading up the MySQL development & functionality

Wimpie Vermaak will be doing the SQLite development & functionality

Lukskywalker will be helping out on MSSQL ?

To summarize:

The Cross Database Engine is fairly easy to implement when it comes to 
adding other databases, however this is not the main aim of the project.
The main aim will remain to create or interpret between the different 
database environments so that Developer A developing in Database B with
CDE can safely run his application on Database C without changing his 
code and this means his SQL either.

Our current areas of need are as follows:

1. The various PHP databases need to be encapsulated which is happening 
rather rapidly.
2. The parsesql functionality needs to be discussed and a plan must be 
thought out about how this can work efficiently (this translates the SQL)
3. Blob / Clob / Binary object support needs to be completed for each 
database environment, I've done it for Firebird but do not know how
    it works for the rest.
4. Each area where there is functionality lacking for a particular 
database it needs to be added. For instance Firebird had no support for 
numrows so I added it.
5. There is a new file in the CVS which is called cdetestclass.php which 
I'm going to add some routines to which should work on your database 
environments,
   if they do not work then there is some work to be done in the 
parsesql for the particular environment. (The initial database is SQLite 
which will port to the others)
   Ideas are welcome here about how to test from PostGres to Firebird 
etc ...
6. Date handling is quite a bother between databases, some stuff I test 
in SQLite works but doesn't work in Firebird & MSSQL hence the tran_date 
function, however
    I still have problems with it.
7. Use this list as a forum for sharing information as the public can 
use it as a reference also.

And thats about it for now, lets see if we can tackle these issues and 
work to testing with the cdetestclass.php which will become our standard 
benchmark.

I welcome any ideas to ensure the success of this project and remember 
our work needs to be good as developers will be putting their faith in 
our engine.

Yours sincerely

Andre van Zuydam