Subject Re: [firebird-php] Re: Firebird Extensions, CDE & PHP
Author Andre van Zuydam
Hi Lester

The objectives of ADOdb and CDE are very similar. CDE is however only for
PHP but does work in an object method however it tends to lean toward
fetching the data into memory rather than having to do next or fetch. This
does have some limitations for large record sets but in most cases one
doesn't want to pull the whole database into memory to output it on a web

In a nutshell, CDE offers the following:

- Connections to different databases in a uniform manner
- SQL translation between database dialects (WIP = work in progress :) )
- Blob handling - uniform across all dbs
- Creation of update and insert statments based on form vaiables (uniform
naming needed - ie prefix edtNAME)
- Reporting to PDF and CSV using fpdf library from a single SQL statement
- Return of field types , widths etc for HTML use as metadata based on
last / current query - easy to make HTML forms from data provided.
- Caching of Queries and Result sets
- Uniform field return types - Uppercase convention with Object and Array
type support
- Full database metadata extraction into array format
- Small single file input
- Comprehensive error handling (in fact I use CDE error handling for my
PHP projects - able to pinpoint exact line numbers where errors occur within
called libraries)

That said, I'm impressed with scope of ADOdb from what I have seen and I
have a lot to learn in terms of the features offered there.

On Tue, Aug 16, 2011 at 10:20 AM, Lester Caine <lester@...> wrote:

> **
> Andre van Zuydam wrote:
> > I will need to look into what adodb provides, but thanks for your
> feedback,
> > it may be that both projects do the same thing:)
> > But this is what I need to look at.
> ADOdb also has a 'datadict' package which allows us to build and update
> databases from a single 'description' of the database. A little difficult
> to
> master if you want it to work across ALL database, but it works well on the
> range of databases that normally get used.
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact -
> L.S.Caine Electronic Services -
> EnquirySolve -
> Model Engineers Digital Workshop -
> Firebird -

Andre van Zuydam
Spiceware Software (Pty) Ltd
Email: andre@...
Tel: +27 83 646 4535
Fax: +27 86 682 6944

[Non-text portions of this message have been removed]