Release Notes: This version implements a cross-platform SQL performance monitoring and database health check module for MySQL, PostgreSQL, Oracle, DB2, MSSQL, and other databases. You can optionally log all SQL executed, and this SQL can be analysed for invalid, expensive, and suspicious queries. This is very useful for optimizing queries and tuning the database.
Release Notes: In this version, the recordset pager now shows ten link pages when $pager->showPageLinks is set to true. Recordset filters were added to convert data fields to another format dynamically, and a major bug in session expiry in adodb-sessions.inc.php was fixed.
Release Notes: This release adds the ability to generate SQL to create cross-tabulations (pivot tables) using the new PivotTableSQL function. Some Microsoft SQL Server compatibility problems have been fixed.
Release Notes: New caching functions were added: CacheGetOne, CacheGetRow, CacheGetAll. A new function for scheduling appointments portably was added. $conn->OffsetDate($dayFraction,$date=false) can be used to generate SQL that calculates date offsets. Portability when handling joins was improved. The "leftOuter" and "rightOuter" connection properties were added for left and right outer join operators, and "ansiOuter" was added to indicate that ANSI outer joins are supported. The "mssqlpo" portable MSSQL driver was added. This allows you to write portable SQL, using "||" for string concatenation, and have it automatically converted to "+" when you switch to MSSQL.
Release Notes: This release has $db->Replace() to perform an update or insert if the record is not found, and a data pager class that generates HTML to display data in a nice table with a navigation bar for scrolling. The session handler has been optimized by using crc32 on the data and updating only when the session variables change. The ADO driver now uses client cursors. Quote() now checks for magic quotes automatically.
Release Notes: In this version, emulated RecordCount() is now stable. There is improved blob support, RowLock() now supported in most databases, and there is support for PHP 4.2.0 ODBC API changes. The CommitTrans($ok) function now allows the setting of the $ok parameter to false to rollback. There are new OCI805, Informix72 and Postgres64 drivers, and new sysDate and sysTimeStamp properties for portable date and timestamp creation. There are also miscellaneous bugfixes.
Release Notes: RecordCount() now works in all databases that previously did not support it. The bind parameter API was unified for oci8 and mssql stored procedures. Informix SELECT FIRST support and Interbase Prepare/Execute support were added. UnixTimeStamp() and UnixDate() were added to ADOConnection(). Miscellaneous fixes and speedups were made.
Release Notes: A new directory structure is now used. All the test scripts have been moved to adodb/tests, and database-specific code is now in adodb/drivers. A new Sybase SQL Anywhere driver (using ODBC) was developed. The Informix and mssql drivers were improved. Lastly, the recordset caching algorithm should scale better now.
Release Notes: In this release, a new beta Informix driver was added, it still requires metadata and ISO date support. Some miscellaneous bugs were fixed.
Release Notes: Error handling enhancements were made. It is now possible to throw an error with trigger_error(), log a message, or call PEAR_Error when a connection or query error occurs. The performance of Insert/Update/Delete operations was improved.