Re: PEAR DB abstraction layers

Stephan Schmidt wrote:

Hi, I think it would be great to highlight _all_ differences and show the simple usage of MDB2 as most of the users probably are not aware how MDB works.

Ok as I have said MDB2 can do everything DB can (if I missed a feature let me know .. shouldnt be a problem since after all its all opensource) However MDB2 has the following: - is faster - option datatype abstraction - full LOB support - optional buffered result set emulation (which for example makes nonsequential row fetching possible in Oracle and similar RDBMS) - unbuffered result set support - allows changing of the DSN after connect - creates connections on demand - provides methods to read and manage the database schema from the rdbms - provides an XML based schema format to allow rdbms independant schema definitions - can automatically alter a database based on different versions of a given xml schema file - provides a modular approach_ manager - schema management reverse - reading metadata from the rdbms schema datatype - type abstraction native - in order to expose features which cannot be abstracted across all supported RDBMS extended - additional convinience methods This was done to keep the memory footprint small, to prevent compiling of unneeded code and to make customizing easier - allows setting what result class should be used (this can be used in conjuntion with the iterator interface to get all result sets as PHP5 compatible iterator instances for example) - simple sub select emulation - SQL REPLACE emulation hmm I will ponder some more if I forgot something The current list of supported RDBMS is shorter than DB though: MDB2: MySQL PostGreSQL Oracle Frontbase Querysim Interbase/Firebird MSSQL SQLite DB: dbase, fbsql, interbase, informix, msql, mssql, mysql, mysqli, oci8, odbc, pgsql, sqlite and sybase. regards, Lukas Smith smith@backendmedia.com _______________________________ BackendMedia www.backendmedia.com berlin@backendmedia.com Linn Zwoch Smith GbR Pariser Str. 44 D-10707 Berlin Tel +49 30 83 22 50 00 Fax +49 30 83 22 50 07