Differences between revisions 5 and 29 (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

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 5 as of 2002-10-01 14:47:54 → 
  Size: 1142
  Editor: pD9EB6E6E
  Comment:
+   ← Revision 29 as of 2008-12-08 12:53:59 → ⇥
  Size: 2471
  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 ====

==== 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 37:
-  URL:: http://www.computronix.com/utilities/
  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 40:
-  Python versions:: 2.0 - 2.2
+  Python versions:: 2.2 - 2.5
  Oracle versions:: 8i - 11g
-Line 30:
+Line 43:
-==== Extensions to DB API ====
+=== mxODBC ===
-Line 32:
+Line 45:
-==== 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 50:
-== 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 52:
-=== driver name ===

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

==== Programming Model ====

==== Comments ====
+----
-Line 49:
+Line 56:
- * ["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 59:
-== Pros ==
+== Web Links ==
-Line 54:
+Line 61:
-== 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