Metabase: PHP Database abstraction layer RDBMS independent

Recommend this page to a friend!

Download

Info

Documentation

Screenshots

Files

Install with Composer

Download

Reputation

Support forum

Blog

Links

Last Updated		Ratings				Unique User Downloads		Download Rankings
2024-06-29 (7 months ago)		74%				Total: 32,028		All time: 15 This week: 31

Version		License		PHP version		Categories
`metabase` 1.0.14		BSD License		4		XML, Databases

Description

Author

Manuel Lemos

Package of classes that provide DBMS independent access and management of databases.

Currently it features:

o BSD style license.

o Dual API call forms:
* Direct driver class object calls
* Global function calls

o Set of functions that call the selected DBMS driver objects functions supporting when possible:
* Database connection setup with support for connection strings
* Operation error handling
* Query constant data conversion
* Direct queries
* Prepared queries
* Query result rows random access
* Retrieve a limit range of rows of a SELECT query.
* Nested transactions
* Large object fields (BLOBs - storing files in the database)
* Database object creation (tables, indexes, sequences)
* DBMS driver supported feature query

o DBMS Drivers classes that support the most important databases being used on the Web.

o Driver conformance test suite to verify if the driver classes are working and features are properly implemented.

o A parser class that is able to interpret DBMS independent database schemas file defined in a custom XML format supporting the following types of objects:
* Tables with fields of the types: text, integer, boolean, date, time, timestamp, decimal, float, character large objects (CLOBs) and binary large objects (BLOBs), auto-increment.
* Primary keys
* Indexes
* Auto incremented sequences

o A manager class that is able to:
* Install a new database from a schema description interpreted by the parser class.
* Ability to compare a previously installed schema with a new schema and only install the changes without affecting data stored after the previous installation or update.
* Dump database structure and contents in the same XML format handled by the parser allowing for moving data between databases of different DBMS vendors.
* Reverse engineer schemas of already installed databases

o Driver classes for multiple databases:

* MySQL using the traditional MySQL extension or MySQLi
* PostgreSQL
* Oracle using oci extension
* Microsoft SQL server using the mssql extension
* SQLite
* Generic ODBC base driver
* MS Access using ODBC
* Interbase
* Informix
* MiniSQL

Manuel Lemos

Performance

Level

Level 3

Recommendations

Good and simple MySQL wrapper
What MySQL wrapper should I go with?

MSAccess data to MySQL
Fetch MSAccess data and store into MySQL

Portable database access
Database access compatible with MySQL and SQLite

What is the best PHP database schema abstraction class?
Applications Database Schema

Connect to MS Access database with ODBC
ODBC Connection to MS Access

Connect to informix database
Need to connect and retrieve data from informix database

PHP and Progress Openedge ODBC
I need to interrogate an Openedge database using PHP

Documentation

Details

Metabase is a database abstraction package for developing portable database
applications in PHP.

You may find more information about Metabase at:

http://www.phpclasses.org/metabase

Screenshots (1)

Files (52)

File	Role	Description
`documentation` (4 files)
`editplus` (4 files)
`autoincrement.schema`	Data	Driver conformance database schema for testing auto-increment fields
`configuration.php`	Aux.	Example configuration values
`driver_test.php`	Test	Driver class conformance test script.
`driver_test.schema`	Data	Driver class conformance test database schema description.
`driver_test_config.php`	Conf.	Driver class conformance test configuration script.
`get_database.php`	Aux.	Utility script to reverse engineer installed database schemas to Metabase XML definition
`LICENSE`	Lic.	BSD style license
`lob_test.schema`	Data	Database schema to test large object fields.
`manager_database.php`	Class	Base class for database schema management extensions
`manager_ibase.php`	Class	Interbase schema management extension class
`manager_ifx.php`	Class	Informix schema management extension class
`manager_msql.php`	Class	Mini-SQL schema management extension class
`manager_mssql.php`	Class	Microsoft SQL server schema management extension class
`manager_mysql.php`	Class	MySQL schema manager extension class
`manager_mysqli.php`	Class	Metabase schema management driver extension class for MySQL database using the MySQLi extension
`manager_oci.php`	Class	Oracle OCI schema management extension class
`manager_odbc.php`	Class	ODBC schema management extension class
`manager_odbc_msaccess.php`	Class	Microsoft Access schema management extension class
`manager_pgsql.php`	Class	PostgreSQL schema management extension class
`manager_sqlite.php`	Class	SQLite schema management extension class
`metabase.xsl`	Data	XML style sheet to render database schemas in Metabase XML format contributed by Stefano Locati
`metabase_audit_queries_plugin.php`	Class	Plugin class to perform auditing operations on SQL queries that execute
`metabase_database.php`	Class	DBMS driver base class.
`metabase_ibase.php`	Class	Driver class for Interbase contributed by Meir kriheli
`metabase_ifx.php`	Class	Driver class for Informix contributed by Pierre-henri Delaval
`metabase_interface.php`	Aux.	Database interface function library
`metabase_lob.php`	Class	Large object fields handler classes
`metabase_manager.php`	Class	Database manager class.
`metabase_msql.php`	Class	Driver class for Mini-SQL
`metabase_mssql.php`	Class	Driver class for Microsoft SQL server
`metabase_mysql.php`	Class	Driver class for MySQL
`metabase_mysqli.php`	Class	Metabase interface class with MySQL database using the MySQLi extension
`metabase_oci.php`	Class	Driver class for Oracle using the OCI
`metabase_odbc.php`	Class	Driver class for ODBC
`metabase_odbc_msaccess.php`	Class	Microsoft Access driver class via ODBC contributed by Svemir Brkic
`metabase_parser.php`	Class	Schema definition parser class.
`metabase_pgsql.php`	Class	Driver class for PostgreSQL
`metabase_sqlite.php`	Class	SQLite flat file database API driver contributed by Jeroen Derks
`metabase_template.php`	Class	Template driver class.
`README.txt`	Doc.	Information about the project
`setup_test.php`	Example	Test database setup script.
`test.schema`	Data	Test database schema definition in Metabase XML format
`test_audit_queries_plugin.php`	Aux.	Example script to show how to perform auditing operations on SQL queries that execute

File	Role	Description
`faq.html`	Doc.	Metabase Frequently Asked Questions
`metabase.html`	Doc.	Metabase manual in HTML format
`tutorial-pt.html`	Doc.	Portuguese version of Metabase tutorial in HTML format
`tutorial.html`	Doc.	Metabase tutorial in HTML format

File	Role	Description
`metabase.acp`	Data	EditPlus template file for editing Metabase schemas Contribution by Aral Balkan.
`metabase.ctl`	Data	EditPlus template file for editing Metabase schemas Contribution by Aral Balkan.
`metabase.stx`	Data	EditPlus template file for editing Metabase schemas Contribution by Aral Balkan.
`template.schema`	Data	EditPlus template file for editing Metabase schemas Contribution by Aral Balkan.

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.

Install with Composer

	metabase-2024-06-29.zip 217KB
	metabase-2024-06-29.tar.gz 183KB
	Install with Composer

Needed packages

Class	Download	Why it is needed	Dependency
Generic XML parser class	.zip .tar.gz	If it is used the schema management support, this class is used to parse the XML schema definitions	Conditional

Version Control

Reuses

Unique User Downloads

Download Rankings

90%

Total:	32,028
This week:	0

All time:	15
This week:	31

User Ratings

User Comments (3)

	All time
Utility:	88%
Consistency:	84%
Documentation:	76%
Examples:	74%
Tests:	68%
Videos:	-
Overall:	74%
Rank:	89

39 errors in a single file 3 years ago (Dharman)	0%
good 8 years ago (muabshir)	85%
Excellent 15 years ago (kishore kumar)	90%

Applications that use this package


Metastorage is a PHP Object-Relational mapping (ORM) code generator tool. It generates PHP classes of persistent objects that use Metabase API to install the schema and access many types of databases with the same code.
The PHP Classes Repository site uses Metabase to install and access to the database that holds all the information related with classes hosted in the site.
NeoAssist is a suite for providing intelligent help to the users of a site generating automatic answers to questions submitted online. Metabase assured fast deployment of NeoAssist while it allowed to be implemented in a large number of platforms with different types of databases without further effort. This made possible for Vem.Ca, NeoAssist developer company, to sell licenses to a broader market.
Framework for developing full featured Web sites. Metabase was used because of its capability to abstract every database access operation including table creation.
Web interface to manipulate data stored in a database. It uses Metabase to achieve database independence, so it will work with many database systems.
I-Know is the name of technology developed to implement knowledge bases. It was used in the site «É na Net» to implement a service that is able to answer questions about the Internet based on extracts of the book «Estar na Internet».
Obliquid is a PHP and XML based framework for building groupware Web portals. It provides "Lego bricks" that may be composed to build an Internet application. Metabase was chosen after experiencing database portability problems with others database abstraction layers. Metabase is also used also to install the database schema.
Database independent Web hit counter and manager.
phpSecurityAdmin is a package for managing user accounts and access rights. Metabase was used due to its extensive database driver support and its API that is meant to provide portability to the database packages like this.
Wanadoo is an European ISP. Pierre-henri Delaval developed the Informix driver for Metabase when he worked on Wanadoo portal.

If you know an application of this package, send a message to the author to add a link here.

Other classes that need this package

Class	Why it is needed	Dependency
Database access class	Database independent abstraction layer used to access many SQL databases	Required
PHP Forms Class with HTML Generator and JavaScript Validation	Used by the custom linked select plug-in class that retrieves groups of options from many SQL databases	Conditional
Query result table display class	Database independent abstraction layer used to access many SQL databases	Required

Related pages


Beta version of Metabase source unreleased files
Do you want to help promoting Metabase? Use this banner and make it point to this page.
Mailing list for the development and support for Metabase users
If you are looking for other Metabase drivers that are not available here, go to this page to tell which drivers are you looking for.
Did you like this PHP package? Rate it at Zend.com PHP application.