Differences between revisions 35 and 39 (spanning 4 versions)
Revision 35 as of 2009-11-05 13:31:47
Size: 2987
Editor: 217
Comment:
Revision 39 as of 2013-09-03 05:49:08
Size: 260
Editor: 66
Comment:
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 ==

 * 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://www.computronix.com/download/License(cxOracle).txt|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 [[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.

----

== 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

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

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