[ANNOUNCEMENT] DB-1.7.0 (stable) Released.

The new PEAR package DB-1.7.0 (stable) has been released at http://pear.php.net/. Release notes ------------- To view the majority of changes since 1.6.8, see the changelog for Release 1.7.0RC1. all: * __sleep() should not call disconnect(). Also store connection state in the new $was_connected property. This resolves Bug 3594 that was introduced in 1.7.0RC1. fbsql: * Handle more error codes: + 239 => DB_ERROR_TRUNCATED. + 215 => DB_ERROR_NOSUCHFIELD for columns not in both sides of JOIN. ibase: * Change error mapping of "arithmetic exception, numeric overflow, or string truncation" from DB_ERROR_DIVZERO to DB_ERROR_INVALID because it covers much more than division by zero. mssql: * Handle more error codes: + 155 => DB_ERROR_NOSUCHFIELD for columns not in both sides of JOIN. oci8: * Handle more error codes: + 1401 => DB_ERROR_INVALID for strings exceeding column size. odbc: * Handle more error codes: + '22001' => DB_ERROR_INVALID for strings exceeding column size. pgsql: * For getListOf('views'), ignore views in system schemas rather than returning views in the public schema. Request 3595. * Handle more error messages: + invalid input syntax for type numeric + column reference "active" is ambiguous + value too long for type character varying(50) + value "50000" is out of range for type shortint + integer out of range + column "p_id" specified in USING clause does not exist in left table + column p.p_name does not exist * Silence errors in errorNative() when connection doesn't exist. sqlite: * Handle more error messages: + cannot join using column b - column not present in both tables Package Info ------------- DB is a database abstraction layer providing: * an OO-style query API * portability features that make programs written for one DBMS work with other DBMS's * a DSN (data source name) format for specifying database servers * prepare/execute (bind) emulation for databases that don't support it natively * a result object for each query response * portable error codes * sequence emulation * sequential and non-sequential row fetching as well as bulk fetching * formats fetched rows as associative arrays, ordered arrays or objects * row limit support * transactions support * table information interface * DocBook and phpDocumentor API documentation DB layers itself on top of PHP's existing database extensions. Drivers for the following extensions pass the complete test suite and provide interchangeability when all of DB's portability options are enabled: fbsql, ibase, informix, msql, mssql, mysql, mysqli, oci8, odbc, pgsql, sqlite and sybase. There is also a driver for the dbase extension, but it can't be used interchangeably because dbase doesn't support many standard DBMS features. DB is compatible with both PHP 4 and PHP 5. Related Links ------------- Package home: http://pear.php.net/package/DB Changelog: http://pear.php.net/package/DB/download/1.7.0 Download: http://pear.php.net/get/DB-1.7.0.tgz Authors ------------- Stig Bakken <stig@php.net> (developer) Thomas V.V.Cox <cox@idecnet.com> (developer) Daniel Convissor (lead) Lukas Smith <smith@backendmedia.com> (helper)