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