|
Size: 2317
Comment:
|
Size: 2987
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 5: | Line 5: |
| URL:: http://www.oracle.com/index.html FAQ:: http://www.orafaq.com/ Wiki:: http://www.orawiki.com/ |
URL:: http://www.oracle.com/index.html FAQ:: http://www.orafaq.com/ Wiki:: http://www.orawiki.com/ |
| 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 26: | Line 26: |
| === 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 32: | Line 41: |
| Last release:: 1.3beta (Feb 10, 2003) | |
| Line 33: | Line 43: |
| === cx_Oracle === | DCOracle2 targets Oracle 8i and up. |
| Line 35: | Line 45: |
| 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 |
There also is DCOracle (http://www.zope.org/Products/DCOracle/) for the older Oracle 7 and 8 versions, but this is unmaintained. |
| Line 46: | Line 53: |
| Python versions:: 2.1 - 2.5 | Python versions:: 2.1 - 2.6 |
| Line 48: | Line 55: |
| 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 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. |
| Line 54: | Line 72: |
| * ["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 77: |
| [http://www.orafaq.com/forum Oracle Forum] | [[http://www.orafaq.com/forum|Oracle Forum]] |
| Line 61: | Line 79: |
| 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 81: |
| 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
- 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