ADOdb is a database abstraction library for PHP. The PHP version currently supports an amazing number of databases, thanks to the wonderful ADOdb community: MySQL, PostgreSQL, Interbase, Firebird, Informix, Oracle, MS SQL, Foxpro, Access, ADO, Sybase, FrontBase, DB2, SAP DB, SQLite, Netezza, LDAP, and generic ODBC, ODBTP. The Sybase, Informix, FrontBase and PostgreSQL, Netezza, LDAP, ODBTP drivers are community contributions. Some reasons why ADOdb is popular include:
- Designed for speed. It is probably the fastest free software database abstraction library available for PHP. See benchmarks.
- Provides extensive portability support such as date and type-handling and portable schema creation. See portable sql tips
- Support many enterprise features such as database backed sessions (with session expiry notification), SQL code generation, pivot tables, SELECT LIMIT emulation for all databases, performance monitoring.
- Easy to learn.
- Extensive QA, every release is unit-tested on Access, MySQL, PostgreSQL, MS SQL, Oracle 9.
- Mature, continuously developed since August 2000. Has a large community of users.
- Powerful Active Record support. See docs.
- Very reasonable licensing terms (BSD). This means that you can incorporate (and even compile) it into your software applications royalty-free without asking the author's permission, provided you include license.txt in your release.
Documentationhttp://phplens.com/lens/adodb/docs-active-record.htm and http://phplens.com/lens/adodb/docs-adodb.htm and http://phplens.com/lens/adodb/docs-perf.htm and http://phplens.com/lens/adodb/docs-session.htm
released on 10 February 2009
|License||Verified by||Verified on||Notes|
|LGPLv2.1||Kelly Hopkins||10 February 2009|
|BSD 3Clause||Kelly Hopkins||10 February 2009|
Leaders and contributors
Resources and communication
This entry (in part or in whole) was last reviewed on 10 February 2009.