Differences between revisions 6 and 30 (spanning 24 versions)

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

DCOracle2

URL: http://www.zope.org/Members/matt/dco2
licence: ZPL
platforms: Unix, win32
Python versions

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.

cx_Oracle

URL: http://cx-oracle.sourceforge.net/
licence: BSD like
platforms: Unix, win32
Python versions: 2.2 - 2.5
Oracle versions: 8i - 11g

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.5

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

Supported Python Applications

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

Web Links

Oracle Forum

Oracle Wiki's: English German

Oracle Documentation: 10g 9i 8i 7

-  ⇤ ← Revision 6 as of 2003-03-20 16:28:36 → 
  Size: 1147
  Editor: grossetto
  Comment: fixed url
+   ← Revision 30 as of 2008-12-08 12:54:45 → ⇥
  Size: 2510
  Editor: MarcAndreLemburg
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 2:
-[[TableOfContents]]
-Line 4:
+Line 3:
-== Masthead ==
+= Oracle =
-Line 6:
+Line 5:
-  URL:: http://www.oracle.com/ip/deploy/database/oracle9i/
  licence:: commercial (free development versions available on http://technet.oracle.com/)
  platforms:: Unix, win32
+  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

----
-Line 19:
+Line 33:
-==== Extensions to DB API ====
+DCOracle2 targets Oracle 8i and up.
-Line 21:
+Line 35:
-==== Comments ====
+There also is DCOracle (http://www.zope.org/Products/DCOracle/) for the older Oracle 7 and 8 versions, but this is unmaintained.
-Line 25:
+Line 39:
-  URL:: http://www.computronix.com/utilities.shtml
  licence:: BSD like: http://www.computronix.com/utilities/License.txt
+  URL:: http://cx-oracle.sourceforge.net/
  licence:: [[http://www.computronix.com/download/License(cxOracle).txt|BSD like]]
-Line 28:
+Line 42:
-  Python versions:: 2.0 - 2.2
+  Python versions:: 2.2 - 2.5
  Oracle versions:: 8i - 11g
-Line 30:
+Line 45:
-==== Extensions to DB API ====
+=== mxODBC ===
-Line 32:
+Line 47:
-==== Comments ====
+  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.5
-Line 34:
+Line 52:
-== Other Drivers ==
+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]].
-Line 36:
+Line 54:
-=== driver name ===

  URL:: 
  licence::
  platforms::
  Python versions::

==== Programming Model ====

==== Comments ====
+----
-Line 49:
+Line 58:
- * ["Zope"]
 * an Oracle (DCOracle and DCOracle2) driver exists for ["PyDO"] (Python Data Objects)
+ * [[Zope]]
 * an Oracle (DCOracle and DCOracle2) driver exists for [[PyDO]] (Python Data Objects)
-Line 52:
+Line 61:
-== Pros ==
+== Web Links ==
-Line 54:
+Line 63:
-== Cons ==
 * Requires bloated Oracle client installation on any machine that the app will run on
+[[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]]

Page

User