[DB-SIG] perl-DBI like module for Python?
misa at redhat.com
Mon May 24 11:57:14 EDT 2004
I am not sure if it was mentioned before on this list.
Is there a module that does what the perl DBI module does?
What I mean by that is: a top-level module that exposes the API defined in the
DB API document, but with the ability to change backend drivers on the fly.
Example: I have my application running against Postgres. I have to be able to
port it to Oracle too. Unfortunately, code that tries to catch
DatabaseException will have to look for the cx_Oracle DatabaseException, not
for the postgres one.
This would be easily solved if a DBI module would provide the base classes
(for things like Database, Cursor, DatabaseException etc.) that the code could
use, and a connect function that could specify the database driver to use
(postgres, cx_Oracle etc). Drivers would inherit their classes from this
jdbc/odbc do the same thing.
Is there such a thing out there?
Misa (re-inventing the wheel)
More information about the DB-SIG