Python and Databases ?

[Dale Strickland-Clark]

"Frank Z. Gligic" <zGligic at cgocable.net> wrote:

>Hi Folks:
>
>This is my very first posting.  In fact, it was only a couple of nights ago
>that I ended up spending some 5 hours in a book store and all of it, for the
>very first time, flipping through 4 Python books.  Well, I fell in love.
>Being relatively new and still feeling  a bit intimidated by OOP, I ended up
>buying "Learning Python" by Lutz & Ascher from O'Reilly.  I have also been
>skipping around Guido's tutorial and most of it makes sense.
>
>I have also been lurking around this news group in a bit of a confusion.  My
>main interests are the good old business applications, which live and die
>mostly by the strength (speed and robustness) of their database integration.
>So far, I have noticed postings that mention some ODBC modules as well as
>something called DCOracle.  I have looked at neither and mostly because I am
>still at the 'tutorial' stage.
>
>I am hoping that going forward to Python does not mean going backward to
>ODBC.  DCOracle sounds nice.  ;)
>
>However, what I am really, really hoping for is a set of modules that are
>'SQLish' and that hide the 'native' integration to at least the commercial
>beasts (: Oracle, Sybase, SQL Server, Progress, etc :) and maybe even mySQL
>and PostgreSQL.
>
>Could somebody please point me to something/anything to read that would give
>me at least a good overview of the state of things, when it comes to Python
>and databases ?
>
>Regards,
>Frank
>We are all prisoners of our own experience(s)
>
>

I'm assuming you are on Win32. If not some of this isn't relevant.

mxODBC is very popular and if you search back over this ng, you will find much good said about it. I
haven't tried it yet as I'm reasonably happy using ADO through COM. ADO is very fast and flexible
and really easy to drive with Pyton, as long as you understand COM.

If you are on Win32, then Python Programming on Win32 by Hammond and Robinson is essential. It
covers both the above options in sufficient detail to get results.


--
Dale Strickland-Clark
Out-Think Ltd
Business Technology Consultants