Metabase is a PHP API that can access SQL databases without the need for a specific DBMS.
This intuitive software supports nested transactions, blobs, and prepared queries, which greatly enhance the efficiency of working with databases. It also enables the installation of database schemas effortlessly, with a DBMS-independent XML format that accurately defines tables, primary keys, indexes, and auto-increment sequences.
Through Metabase, database upgrades can be seamlessly conducted to a new schema without affecting any data that has been stored since the previous upgrade or installation. Moreover, it supports schema reverse engineering, which is particularly useful in gaining an accurate understanding of existing databases.
The latest release of Metabase adds support for nested transactions, which means that transactions can now be started while another transaction is already in progress. Further, the database schema XML parser has been improved to disallow more reserved words in several types of databases.
Overall, Metabase is an excellent tool for anyone who needs to interact with databases. Its robust functionality is enhanced by its ease of use, and the ability to support various databases makes it perfect for businesses that work across multiple platforms.
Version 2008.04.14: N/A