Release Notes: This release adds support to retrieve a whole result set into a bidimensional array on which the row indexes are set to a given column value of the respective row. The database access errors may include now contextual information like query name or the time a query took to execute when it failed. Support was added for setting the character set of a database when it is created. PHP strict warnings are avoided.
Release Notes: This release adds support for setting the query result column types and name, so the result rows are returned as associative arrays using the given column names, thus provding a database independent solution to name query result columns. It now only uses PCRE regular expression functions instead of the deprecated POSIX regular expression functions in preparation for PHP 6.
Release Notes: This release adds support for nested transactions, i.e. transactions that can be started when another transaction is already in progress. The database schema XML parser portability was enhanced to disallow more table and field names that are reserved words in several types of databases. Several minor bugs were fixed.
Release Notes: The Metabase API was enhanced to provide database independent escaping of % and _ in SQL LIKE expressions that may need to take these and other wildcard characters literally. Several functions were added to build patterns that match expressions that begin, end, or contain a given text, along with another function for composing any other kind of pattern.
Release Notes: The SQLite driver was updated to support native auto-increment fields, primary keys, and binary data escaping stored in BLOB fields. This driver also supports table renaming and column adding when using the SQLite 3 library. The MySQL and PostgreSQL drivers were updated to create tables using native fixed point decimal fields. The decimal field emulation using large integer fields became an option to support legacy versions. The debug output buffer that records all queries and driver activity is now flushed every time it is retrieved by an application.
Release Notes: This release implements the ability to insert rows on tables while omitting the values of auto-increment columns. The MS-SQL driver was enhanced to support native auto-increment fields, primary keys, rename tables, drop columns, fixed index dropping, and fixed adding columns. The Oracle driver was enhanced to create tables with a special trigger that sets the value of auto-increment columns when its value is omitted or set to NULL. The test suite script was enhanced to test omitting the auto-increment column value in conjunction with tables with fields set to NULL, integer values, and float values.
Release Notes: This release adds support for installation of table primary keys and access to auto-increment fields, even for databases that do not support these kind of fields natively. The Oracle and PostgreSQL drivers were enhanced to support more complex table schema alterations than in previous releases. The main reference manual and the tutorial were updated to detail these enhancements. A new FAQ document was added to clarify aspects such as performance matters, missing features, and the Metabase project details.
Release Notes: The schema manager class was fixed to dump values of tables fields in the Metabase XML schema format encoding the & characters correctly. The script to dump reverse engineered database schemas in Metabase XML format was fixed to work properly when dumping databases with tables with BLOB/CLOB fields.
Release Notes: A workaround was added to the MySQL driver class to avoid a bug in the PHP mysql_query function that under certain circumstances may return a true value instead of a valid result set handle when executing SQL SELECT queries that fail.
Release Notes: The default value for sequence auto-incremented fields was dropped in the MySQL schema manager class, as it is no longer supported under MySQL 4.1. The determination of the debug callback function was fixed for when the schema manager database setup arguments are passed as a connection string. PHP warnings are suppressed when a schema file name is incorrect. A few regular expressions used in the schema parser class were fixed.