Metabase is a DBMS-independent PHP API to access SQL databases. It supports MySQL, PostgreSQL, Oracle, Microsoft SQL server, Microsoft Access, ODBC, Interbase, Informix, MiniSQL, and SQLite. It supports nested transactions, blobs, and prepared queries. It can install database schemas defined in a DBMS independent XML format that describe tables, indexes, primary keys, and auto-increment sequences. It is also able to upgrade a database to a new schema without affecting the data that was stored since it was installed or upgraded for the last time. There is also schema reverse engineering support.
|Tags||Software Development Libraries php classes Database Front-Ends|
|Operating Systems||OS Independent|
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.