Differences between revisions 34 and 35
Revision 34 as of 2009-05-28 17:20:24
Size: 2988
Editor: tkbn103153
Comment: DCOracle2 looks umaintained: putting cx_Oracle first. Adding last release fields, which is relevant for driver choice.
Revision 35 as of 2009-11-05 13:31:47
Size: 2987
Editor: 217
Comment:
Deletions are marked like this. Additions are marked like this.
Line 55: Line 55:
mxODBC is compatible with the Oracle ODBC drivers on Windows and Unix, such as the ones included in the [[http://www.oracle.com/technology/tech/oci/instantclient/index.html|Oracle Instance Client]]. mxODBC is compatible with the Oracle ODBC drivers on Windows and Unix, such as the ones included in the [[http://www.oracle.com/technology/tech/oci/instantclient/index.html|Oracle Instant Client]].

Oracle

URL

http://www.oracle.com/index.html

FAQ

http://www.orafaq.com/

Wiki

http://www.orawiki.com/

Wikipedia

http://en.wikipedia.org/wiki/Oracle_database

license

commercial/proprietary; free for development from Oracle Technology Network; Oracle XE is free for production and development (and an excellent option all-around)

platforms
Unix, Linux, win32, win64

Pros

  • Reputation for being capable of handling large scale databases
  • Typically the database system others compare themselves to

Cons

  • Requires bloated Oracle client installation on any machine that the app will run on
  • Frequently the subject of migration discussions (to alternatives), usually for reasons of cost


DB API 2.0 Drivers

cx_Oracle

URL

http://cx-oracle.sourceforge.net/

licence

BSD like

platforms
Unix, win32
Python versions
2.2 - 2.5
Oracle versions
8i - 11g
Last release
5.0.2 (May 21, 2009)

DCOracle2

URL

http://www.zope.org/Members/matt/dco2

licence
ZPL
platforms
Unix, win32
Python versions
Last release
1.3beta (Feb 10, 2003)

DCOracle2 targets Oracle 8i and up.

There also is DCOracle (http://www.zope.org/Products/DCOracle/) for the older Oracle 7 and 8 versions, but this is unmaintained.

mxODBC

URL

http://www.egenix.com/products/python/mxODBC/

Licence
eGenix Commercial License
Platforms
Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
Python versions
2.1 - 2.6

mxODBC is compatible with the Oracle ODBC drivers on Windows and Unix, such as the ones included in the Oracle Instant Client.

pyodbc

URL

http://code.google.com/p/pyodbc

License
MIT
Platforms
Windows, Linux, MacOS X, FreeBSD, Solaris, Any (source provided)
Python versions
2.4 - 2.6

Actively maintained Open Source project.

Precompiled binaries are available for Windows. RedHat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories.


Supported Python Applications

  • Zope

  • an Oracle (DCOracle and DCOracle2) driver exists for PyDO (Python Data Objects)

Oracle Forum

Oracle Wiki's: English German

Oracle Documentation: 10g 9i 8i 7

Oracle (last edited 2017-08-07 18:24:13 by MaximilianFuxjaeger)

Unable to edit the page? See the FrontPage for instructions.