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: 2019/12/28 03:37 by mnewnham