Oracle Data Access in Python

[Bill Scherer]

A.M wrote:

>
> "Bill Scherer" <bill.scherer at verizonwireless.com> wrote in message
> news:mailman.6375.1149096323.27775.python-list at python.org...
> > 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
>