(Follow the links to learn more about each backend.)
| Oracle | PostgreSQL | MySQL | SQLite3 | ODBC | |
|---|---|---|---|---|---|
| Binding by Name | YES | YES (>=8.0) | YES | YES | YES |
| Dynamic Binding | YES | YES | YES | YES | YES |
| Bulk Operations | YES | YES | YES | YES | YES |
| Transactions | YES | YES | YES (with servers that support them, usually >= 4.0) | YES | YES |
| BLOB Data Type | YES | YES | NO | YES | NO |
| RowID Data Type | YES | YES | NO | NO | NO |
| Nested Statements | YES | NO | NO | NO | NO |
| Stored Procedures | YES | YES | NO (but stored functions, YES) | NO | NO |
| Previous (Rationale FAQ) |
Copyright © 2004-2008 Maciej Sobczak, Stephen Hutton