ADODB 4.93 review

ADOdb is a database abstraction library for PHP. The PHP version currently supports an amazing number of databases, thanks to the

License: GPL (GNU General Public License) File size: 0K Developer: John Lim

0

ADOdb is a database abstraction library for PHP.

The PHP version currently supports an amazing number of databases, thanks to the wonderful ADOdb community: MySQL, PostgreSQL, Interbase, Firebird, Informix, Oracle, MS SQL, Foxpro, Access, ADO, Sybase, FrontBase, DB2, SAP DB, SQLite, Netezza, LDAP, and generic ODBC, ODBTP. The Sybase, Informix, FrontBase and PostgreSQL, Netezza, LDAP, ODBTP drivers are community contributions.

Many popular web applications such as ACID, PostNuke, Xaraya, phpWiki, Mambo, PHP GACL, TikiWiki, eGroupWare and phpLens App Server are using ADOdb as their database abstraction layer.

Here are some key features of "ADODB":
Designed for speed. It is probably the fastest open source database abstraction library available for PHP. See benchmarks.
Provides extensive portability support such as date and type-handling and portable schema creation. See portable sql tips
Support many enterprise features such as database backed sessions (with session expiry notification), SQL code generation, pivot tables, SELECT LIMIT emulation for all databases, performance monitoring.
Easy to learn, especially if you have Window's programming experience, as it uses many ADO conventions.
Extensive QA, every release is unit-tested on Access, MySQL, PostgreSQL, MS SQL, Oracle 9.
Mature, continiously developed since August 2000. Has a large community of users.
Very reasonable licensing terms (BSD). This means that you can incorporate (and even compile) it into your software applications royalty-free without asking the author's permission, provided you include license.txt in your release. Also dual-licensed (Lesser GPL).

Requirements:
Requires Python 2.3 or later. Works fine with Psyco.

What's New in This Release:
Added support for multiple database connections in performance monitoring code (adodb-perf.inc.php). Now all sql in multiple database connections can be saved into one database ($ADODB_LOG_CONN).
Added MetaIndexes() to odbc_mssql.
Added connection property $db->null2null = 'null'. In autoexecute/getinsertsql/getupdatesql, this value will be converted to a null. Set this to a funny invalid value if you do not want null conversion. See http://phplens.com/lens/lensforum/msgs.php?id=15902.
Path disclosure problem in mysqli fixed. Thx Andy.
Fixed typo in session_schema2.xml.
Changed INT in oci8 to return correct precision in
$fld->max_length, MetaColumns(). Thx Eloy Lafuente Plaza.
Patched postgres64 _connect to handle serverinfo(). See http://phplens.com/lens/lensforum/msgs.php?id=15887.
Added pdo fix for null columns. See http://phplens.com/lens/lensforum/msgs.php?id=15889
For stored procedures, missing connection id now passed into mssql_query(). Thx Ecsy (ecsy#freemail.hu).