ADOdb
From Wikipedia, the free encyclopedia
ADOdb is a database abstraction library for PHP and Python based on the same concept as Microsoft's ActiveX Data Objects. It allows developers to write applications in a fairly consistent way regardless of the underlying database storing the information. The advantage is that the database can be changed without re-writing every call to it in the application.
From the ADOdb website, it supports the following databases:
- Access
- ActiveX Data Objects*
- DB2
- Firebird
- Foxpro
- FrontBase
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- Oracle
- PostgreSQL
- SAP DB
- SQLite
- Sybase
- Teradata
- generic ODBC and ODBTP
It is important to note that ADOdb uses SQL. Since each database implements SQL slightly differently, the developer will need to be aware of the database-specific features and functions to avoid if they want to maintain portability.
