This wiki is in the process of being archived due to lack of usage and the resources necessary to serve it — predominately to bots, crawlers, and LLM companies. Edits are discouraged.
Pages are preserved as they were at the time of archival. For current information, please visit
.
If a change to this archive is absolutely needed, requests can be made via the
mailing list.
URL
http://www.oracle.com/index.html
FAQ
Wiki
Wikipedia
http://en.wikipedia.org/wiki/Oracle_database
licensecommercial/proprietary; free for development from
;
is free for production and development (and an excellent option all-around)
platformsUnix, Linux, win32, win64 Pros
Reputation for being capable of handling large scale databases
Typically the database system others compare themselves to
Cons
Usually 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
platformsUnix, win32 Python versions2.5 - 3.2 Oracle versions10i - 11g Last release5.1 (March 19, 2011) DCOracle2
URL
http://www.zope.org/Members/matt/dco2
licenceZPL platformsUnix, win32 Python versionsLast release1.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/
LicenceeGenix Commercial License PlatformsWindows, Linux, MacOS X, FreeBSD, Solaris, AIX Python versions2.4 - 2.7 mxODBC is compatible with the Oracle ODBC drivers on Windows and Unix, such as the ones included in the
.
pyodbc
URL
https://github.com/mkleehammer/pyodbc
LicenseMIT PlatformsWindows, Linux, MacOS X, FreeBSD, Solaris, Any (source provided) Python versions2.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.
OJDBC and JayDeBeApi
URL
http://pypi.python.org/pypi/JayDeBeApi
licenceLGPL platformsAny (requires Java) Python versionsTested on CPython 2.6.6 and Jython 2.5.2 Oracle versionsAny supported by Oracle's JDBC drivers (currently 8.1.7 to 11.2.0.2.0) Last release0.1 (2010-08-16) No
required. Download an Oracle JDBC driver (the filename will be something like ojdbc6.jar) from the
, and set the classpath to include the driver. Note that if not running under Jython, JPype is required. Use code like the following:
environ['JAVA_HOME'] = '/usr/lib/jvm/java-6-openjdk/jre'
jpype.startJVM(jpype.getDefaultJVMPath(), '-Djava.class.path=ojdbc6.jar')
conn = jaydebeapi.connect('oracle.jdbc.driver.OracleDriver', 'jdbc:oracle:thin:user/pass@server:1521:dbname')mxODBC Connect
URL
http://www.egenix.com/products/python/mxODBCConnect/
LicenseeGenix Commercial License 1.3.0 PlatformsClient: all Python platforms; Server: Windows, Linux Python versions2.5 - 2.7 mxODBC Connect is a commercial client-server product that allows connecting Python to ODBC compatible databases running on remote servers without requiring an ODBC driver on the client side. The product uses mxODBC on the server side and provides a highly portable Python library for the client side. As such it supports all database backend that mxODBC supports, but allows connecting to these from many different Python-supported platforms.
mxODBC Connect supports asynchronous query execution via the popular
, provides secure certificate based authentication, SSL encrypted database connections, comes with full support for stored procedures, multiple result sets, Unicode, a common interface on all platforms and implements
.
mxODBC Connect Server is compatible with the
ODBC drivers.
———
Supported Python Applications
an Oracle (DCOracle and DCOracle2) driver exists for
(Python Data Objects)
Web Links
Oracle Wiki's:
Oracle Documentation: