|
Size: 2236
Comment: Updated Python versions for cx_Oracle from the given URL, added Oracle versions
|
Size: 2317
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/ | URL:: http://www.oracle.com/index.html |
| Line 8: | Line 7: |
| licence:: commercial (free development versions available on http://technet.oracle.com/) platforms:: Unix, win32 |
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 20: | Line 33: |
| ==== Extensions to DB API ==== ==== Comments ==== |
|
| Line 26: | Line 35: |
| URL:: http://www.computronix.com/utilities.shtml | URL:: http://cx-oracle.sourceforge.net/ |
| Line 29: | Line 38: |
| Python versions:: 2.2 - 2.4 Oracle versions:: 8i - 10g |
Python versions:: 2.2 - 2.5 Oracle versions:: 8i - 11g |
| Line 32: | Line 41: |
| ==== Extensions to DB API ==== | === mxODBC === |
| Line 34: | Line 43: |
| ==== 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 36: | Line 48: |
| While trying to install the cx_Oracle Python utility, I encounter the following error: | 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 38: | Line 50: |
| sh-2.05b# python setup.py build running build running build_ext building 'cx_Oracle' extension gcc -pthread -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -fPIC -I/devtools/oracle/product/8.1.5/rdbms/demo -I/devtools/oracle/product/8.1.5/rdbms/public -I/devtools/oracle/product/8.1.5/network/public -I/usr/local/python2.4/include/python2.4 -c cx_Oracle.c -o build/temp.linux-i686-2.4/cx_Oracle.o -DBUILD_TIME="January 21, 2005 11:19:47" cx_Oracle.c:10: xa.h: No such file or directory error: command 'gcc' failed with exit status 1 Where can I find the xa.h file? The only package I could find online that provides any such file is a cd i/o library, and that doesn’t seem right. I am running a 2.4 linux kernel, trying to install cx_Oracle-4.0.1 on top of Python 2.4. I have tried the beta package which should be more 2.4 compatible, but still no luck. Any help is appreciated. Thanks! == Other Drivers == === driver name === URL:: licence:: platforms:: Python versions:: ==== Programming Model ==== ==== Comments ==== |
---- |
| Line 80: | Line 57: |
| == Pros == | == Web Links == |
| Line 82: | Line 59: |
| == 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] |
Oracle
- URL
- FAQ
- Wiki
- Wikipedia
- 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
DB API 2.0 Drivers
DCOracle2
- URL
- licence
- ZPL
- platforms
- Unix, win32
- Python versions
cx_Oracle
- URL
- licence
[http://www.computronix.com/download/License(cxOracle).txt BSD like]
- platforms
- Unix, win32
- Python versions
- 2.2 - 2.5
- Oracle versions
- 8i - 11g
mxODBC
- URL
- 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 [http://www.oracle.com/technology/tech/oci/instantclient/index.html Oracle Instance Client].
Supported Python Applications
- ["Zope"]
- an Oracle (DCOracle and DCOracle2) driver exists for ["PyDO"] (Python Data Objects)
Web Links
[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]