v5:database:feature_comparison
Table of Contents
Feature Comparison Matrix
ADOdb features, by Database Type
Check that the 'Verified' column is checked before relying on information
Driver Support
Tier 1 Support
Tier 1 Drivers are fully supported by members of the ADOdb project, and all contain the full feature list. New feature is available for all drivers on release of feature
Tier 2 Support
Tier 2 Drivers may not be supported by ADOdb project members, or may not contain features (in particular Data Dictionary feature). Drivers may be associated with deprecated or removed PHP drivers.
Compatibility
| Access | Firebird | Frontbase Interbase | IBM DB2 | Informix | Microsoft SQL Server | MySQL | Netezza | ODBC | Oracle | PostgreSQL | SAP DB | SQLite | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Verified | No | No | No | Yes | No | No | No | No | No | No | No | No | No |
| Sequences | Yes | Yes | Yes1) | Emulated | Emulated | Yes | Yes | ||||||
| ADODB_FETCH_BOTH | No | Yes | Yes | Yes | |||||||||
| Transactions | No | Yes | Yes | Yes | Yes | Yes | Yes2) | Yes | Yes | Yes | Yes | Yes | Yes |
| Record Counting | Emulated | Emulated | |||||||||||
| selectLimit() | Emulated3) | Yes | Yes | Yes | |||||||||
| Date Offset Functions | No | ||||||||||||
| MetaTables Masking | No | No | No | No | No | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| rowLock row locking | No | ||||||||||||
| rowLock column locking | No | ||||||||||||
| setCharSet4) | No | No | No | No | No | No | Yes | No | No | No | Yes | No | No |
| setConnectionParameter() | Yes | Yes | Yes | Yes | |||||||||
| Blob Handling | No | No | No | Yes | No | Yes | No | No | No | No | No | No | No |
| Stored Procedures | No | No | No | Yes | No | Yes | No | No | No | Yes | No | No | No |
| Performance Monitoring | No | No | No | Yes | Yes | Yes | Yes | No | No | Yes | Yes | No | No |
1)
Emulated in Server 2008 and lower
2)
Transactional Tables Only
3)
Native if query constructed so that TOP n records can be used
4)
Superseded by setConnectionParameter()
v5/database/feature_comparison.txt · Last modified: by mnewnham