The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

import-bot (20211) [Avatar] Offline
#1
[Originally posted by pmann]

Thanks for your informative, and very readable, book. It helped me get
started with Python and produce a number of useful little tools for processing
ascii data.

I have programming experience, but not object-oriented programming, and am
hoping that Python will be a good way to understand OO. Unfortunately, I have
to do this in my spare time because Python has not yet been accepted at my
workplace.

It would help to get it accepted if I could demonstrate the usefulness of
Python in working with Oracle databases. I understand Computronix provides a
facility, cx_Oracle, for doing this. However, I am still pretty much a
'newbie' with Python and don't understand well how to get from available
facilities like this and the Database API to actually producing useful
programs.

From your book, I would say that explaining how to produce useful programs is
something you do well. So any help you can give me here would be very much
appreciated.

Thanks,
Philip Mann
import-bot (20211) [Avatar] Offline
#2
Re: Python and Oracle
[Originally posted by daryl harms]

> Thanks for your informative, and very readable, book. It helped me get
> started with Python and produce a number of useful little tools for processing
> ascii data.
>
> I have programming experience, but not object-oriented programming, and am
> hoping that Python will be a good way to understand OO. Unfortunately, I have
> to do this in my spare time because Python has not yet been accepted at my
> workplace.
>
> It would help to get it accepted if I could demonstrate the usefulness of
> Python in working with Oracle databases. I understand Computronix provides a
> facility, cx_Oracle, for doing this. However, I am still pretty much a
> 'newbie' with Python and don't understand well how to get from available
> facilities like this and the Database API to actually producing useful
> programs.
>
> From your book, I would say that explaining how to produce useful programs is
> something you do well. So any help you can give me here would be very much
> appreciated.
>
> Thanks,
> Philip Mann

Hi Philip,

Thanks for your comments. I've never worked with Python and Oracle myself so
can only give you pointers to other information.

The two best options for this appear to be cx_Oracle (which you have already
found) and DCOracle (http://www.zope.org/Products/DCOracle). However cx_Oracle
is newer, so is probably the better choice.

Following is the Python DB API version 2.0 specification (which is what
cx_Oracle implements):
http://www.python.org/topics/database/DatabaseAPI-2.0.html

The following article will hopefully get you started in general with using the
API: http://www.amk.ca/python/writing/DB-API.html

Daryl