|
Size: 900
Comment:
|
Size: 2987
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 2: | 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 developmnt versions available?) platforms:: |
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 11: | Line 25: |
=== 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) |
|
| Line 16: | Line 39: |
| platforms:: | platforms:: Unix, win32 |
| Line 18: | Line 41: |
| Last release:: 1.3beta (Feb 10, 2003) | |
| Line 19: | Line 43: |
| ==== Extensions to DB API ==== | DCOracle2 targets Oracle 8i and up. |
| Line 21: | Line 45: |
| ==== Comments ==== | There also is DCOracle (http://www.zope.org/Products/DCOracle/) for the older Oracle 7 and 8 versions, but this is unmaintained. |
| Line 23: | Line 47: |
| === cx_Oracle === | |
| Line 25: | Line 48: |
| URL:: http://www.computronix.com/utilities/ licence:: BSD like: http://www.computronix.com/utilities/License.txt platforms:: Python versions:: 2.0 - 2.2 |
=== mxODBC === |
| Line 30: | Line 50: |
| ==== Extensions to DB API ==== | 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 |
| Line 32: | Line 55: |
| ==== Comments ==== | 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]]. |
| Line 34: | Line 57: |
| == Other Drivers == | === pyodbc === |
| Line 36: | Line 59: |
| === driver name === | 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 |
| Line 38: | Line 64: |
| URL:: licence:: platforms:: Python versions:: |
Actively maintained Open Source project. |
| Line 43: | Line 66: |
| ==== Programming Model ==== | Precompiled binaries are available for Windows. Red``Hat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories. |
| Line 45: | Line 68: |
| ==== Comments ==== | ---- |
| Line 49: | Line 72: |
| * ["Zope"] | * [[Zope]] * an Oracle (DCOracle and DCOracle2) driver exists for [[PyDO]] (Python Data Objects) |
| Line 51: | Line 75: |
| == Pros == | == Web Links == |
| Line 53: | Line 77: |
| == Cons == | [[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]] |
Oracle
- URL
- FAQ
- Wiki
- Wikipedia
- 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
cx_Oracle
- URL
- licence
- platforms
- Unix, win32
- Python versions
- 2.2 - 2.5
- Oracle versions
- 8i - 11g
- Last release
- 5.0.2 (May 21, 2009)
DCOracle2
- URL
- 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
- 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 Oracle Instant Client.
pyodbc
- URL
- 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. RedHat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories.
Supported Python Applications