Best python module for Oracle, but portable to other RDBMSes

[Olivier]

dananrg at yahoo.com a écrit :
> I'm a little confused about what's out there for database modules at:
> 
>   http://python.org/topics/database/modules.html
> 
> What I'd like to do is use Python to access an Oracle 9.X database for
> exporting a series of tables into one aggregated table as a text file,
> for import into a mainframe database. The catch is that I'd like to
> write code that wouldn't need to be changed (much) if we switched from
> Oracle to some other RDBMS (still need to export out as a text file for
> import to the mainframe database.
> 
> Looks like I'd probably want to use something that conforms to the
> DB-API 2.0. 


You want to use cx_Oracle :

http://www.python.net/crew/atuining/cx_Oracle/index.html

which is nowadays the very best python Oracle driver.

	Olivier