3917
Comment:
|
260
|
Deletions are marked like this. | Additions are marked like this. |
Line 1: | Line 1: |
#pragma section-numbers off = 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 [[http://www.oracle.com/technology//index.html|Oracle Technology Network]]; [[http://www.oracle.com/technology/software/products/database/xe/index.html|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 == * 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:: [[http://cx-oracle.sourceforge.net/LICENSE.txt|BSD like]] platforms:: Unix, win32 Python versions:: 2.5 - 3.2 Oracle versions:: 10i - 11g Last release:: 5.1 (March 19, 2011) === 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.4 - 2.7 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]]. === 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. Red``Hat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories. === OJDBC and JayDeBeApi === URL:: http://pypi.python.org/pypi/JayDeBeApi licence:: LGPL platforms:: Any (requires Java) Python versions:: Tested on CPython 2.6.6 and Jython 2.5.2 Oracle versions:: Any supported by Oracle's JDBC drivers (currently 8.1.7 to 11.2.0.2.0) Last release:: 0.1 (2010-08-16) No InstantClient required. Download an Oracle JDBC driver (the filename will be something like ojdbc6.jar) from the [[http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html|Oracle website]], and set the classpath to include the driver. Note that if not running under Jython, JPype is required. Use code like the following: {{{#!python 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') }}} ---- == Supported Python Applications == * [[Zope]] * an Oracle (DCOracle and DCOracle2) driver exists for [[PyDO]] (Python Data Objects) == Web Links == [[http://www.orafaq.com/forum|Oracle Forum]] Oracle Wiki's: [[http://www.orafaq.com/wiki|English]] [[http://www.oracle-10g.de/oracle-wiki|German]] Oracle Documentation: [[http://www.oracle-doku.de/oracle_10g_documentation/index.htm|10g]] [[http://www.oracle-doku.de/oracle_9i_documentation/index.htm|9i]] [[http://www.oracle-doku.de/oracle_8i_documentation/index.htm|8i]] [[http://www.oracle-doku.de/oracle_7_documentation/index.htm|7]] |
My name: Bret Aiken<<BR>> My age: 34<<BR>> Country: Germany<<BR>> Home town: Mittweida <<BR>> ZIP: 9642<<BR>> Address: Kantstra�e 62<<BR>> <<BR>> Review my blog; [[http://lecliqueboutique.wordpress.com/wp-admin/customize.php|online outlet shopping]] |
My name: Bret Aiken
My age: 34
Country: Germany
Home town: Mittweida
ZIP: 9642
Address: Kantstra�e 62
Review my blog; online outlet shopping