Re: Oracle Data Access in Python

A.M wrote:


"Bill Scherer" <bill.scherer@xxxxxxxxxxxxxxxxxxx> wrote in message
news:mailman.6375.1149096323.27775.python-list@xxxxxxxxxxxxx
> A.M wrote:
>
>> Hi,
>>
>>
>>
>> I am familiar with Perl's DBI programming.
>>
>>
>>
>> In Python, do we access to Oracle by using DBI?
>>
> No.
>
>> Is Oracle DBD driver included with Python distributions?
>>
> No.
>
>> What is the most common strategy for accessing to Oracle data through
>> Python?
>>
> cx_Oracle seems to be the leading module for Oracle access today. It works
> well.
>
> http://www.cxtools.net/default.aspx?nav=cxorlb
>
>
> You'll need the apropriate Oracle client installed for it to work, of
> course. Oracle's "Instant Client" is probably the easiest way to get what
> you need for that.
>
>
> Hope that helps,
>
> Bill

Thanks Bill for help.
I also learned about DCOracle2 at this page:
http://www.python.org/doc/topics/database/modules/

What do you think about DCOracle2? It seems to be based on Python Database
API Specification.

DCOracle was the first on the block. Back in the day it was the only way to speak with the Oracle.
From what I can tell, development of DCOracle has lagged of late.
Try them both and see which works better for you.

PS. Both cx_Oracle and DCOracle, as well as, oh I guess 99% of other Python database modules, are DB API 2.0 compliant.


Thanks again,
Ali



--
http://mail.python.org/mailman/listinfo/python-list

.

Relevant Pages

  • cx_OracleTools 7.4
    ... cx_OracleTools is a set of Python scripts that handle Oracle database ... In ExportObjects, create the directory before any exporting ... Eliminated identical grants made by different users when describing objects. ...
    (comp.lang.python.announce)
  • cx_Oracle 4.3.2
    ... conforms to the Python database API 2.0 specifications with a few ... Fixed support for native doubles and floats in Oracle 10g; ... Added support for autocommit mode as requested by Ian Kelly. ...
    (comp.lang.python.announce)
  • Re: setting v$session.program?
    ... Why on earth? ... They are python programs, ... oracle shows "python.exe" for all programs. ... For security reasons it is practically useless as well, because you can easily change this attribute by simply renaming of executables - works on windows and unix. ...
    (comp.databases.oracle.misc)
  • cx_Oracle 4.1.1
    ... conforms to the Python database API 2.0 specifications with a few ... Add support for dropping a connection from a session pool. ... which work only in Oracle 10g as requested by Egor Starostin. ...
    (comp.lang.python.announce)
  • cx_Oracle 5.0.1
    ... conforms to the Python database API 2.0 specifications with a few ... exceptions. ... Added support for database change notification available in Oracle ...
    (comp.lang.python.announce)