Hello, [EMAIL PROTECTED] wrote: > There doesn't appear to be a standard database access API in PHP. Instead > there's a separate API for each database supported. This is insanity for > anyone that wants to be able to support multiple databases. I know there > are a number of database abstraction APIs available for PHP but I don't > know which one is the best or which one will be continue to be supported in
Maybe you want to try Metabase. It provides true portability to your PHP database applications. This means that if you develop a PHP database application with Metabase, it will run seeminglessly with all supported databases. Metabase portability, includes not only the access to the databases but also the installation and maintenance of database schemas. Metabase lets you define your database schemas in a XML file where you describe your tables, fields, indexes and sequences. Then it can install the schema for you because it knows how to create the different types of fields and tables in each supported database. If you change you schema file, you just need to tell Metabase to update the installed schema and it will figure the changes and install them without affecting the data already stored after the database schema was first installed or was updated for the last time. Metabase supports: MySQL, PostgreSQL, Oracle, MS SQL server, Informix, Interbase and ODBC. It provides the support for the following features portably: direct and prepared queries (queries with parameters), all the important data types (text, integer, decimal, float, boolean, time, date, timestamp and large objects (blobs and clobs), transactions, auto-incremented sequences, etc... Metabase LICENSE is BSD and so it may be freely downloaded from here: http://phpclasses.UpperDesign.com/browse.html/package/20 > the future. Are there plans to address these issues in a future release of > PHP by adopting one of these abstraction APIs into PHP or creating a new > one? I am afraid that will never happen. -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
