Differences between revisions 27 and 30 (spanning 3 versions)
Revision 27 as of 2008-08-07 12:22:33
Size: 2317
Editor: 202
Comment:
Revision 30 as of 2008-12-08 12:54:45
Size: 2510
Comment:
Deletions are marked like this. Additions are marked like this.
Line 9: Line 9:
  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)   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)
Line 33: Line 33:
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.
Line 36: Line 40:
  licence:: [http://www.computronix.com/download/License(cxOracle).txt BSD like]   licence:: [[http://www.computronix.com/download/License(cxOracle).txt|BSD like]]
Line 48: Line 52:
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]. 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 54: 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 59: Line 63:
[http://www.orafaq.com/forum Oracle Forum] [[http://www.orafaq.com/forum|Oracle Forum]]
Line 61: Line 65:
Oracle Wiki's: [http://www.orafaq.com/wiki English] [http://www.oracle-10g.de/oracle-wiki German] Oracle Wiki's: [[http://www.orafaq.com/wiki|English]] [[http://www.oracle-10g.de/oracle-wiki|German]]
Line 63: Line 67:
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] 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]]

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)

Oracle Forum

Oracle Wiki's: English German

Oracle Documentation: 10g 9i 8i 7

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

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