Database drivers
Digression: Database portability
There are a number of approaches to insulating software engineers
from various aspects of database systems.
| Technology |
Provides insulation from |
Comments |
| ODBC |
C APIs |
Moderately successful. Each database system still has its own native API.
|
| JDBC |
Java APIs |
Extremely successful. Few database systems have native Java APIs.
|
| DBAPI |
Python APIs |
Somewhat successful. For some database systems there is a good
DBAPI driver. For others, find a native API.
|
| Object-relational mappers (ORM) |
SQL |
Somewhat successful. Makes the easy things easy. Makes the
difficult things nearly impossible. Recommendation: Avoid
|
|