Python and Databases ?

[Alex Martelli]

"Frank Z. Gligic" <zGligic at cgocable.net> wrote in message
news:j75Q5.39915$4U6.1953679 at news1.rdc2.on.home.com...
    [snip]
> 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 ?

http://www.python.org/topics/database/DatabaseAPI-2.0.html

You'll find a decent (IMHO) 'SQLish module interface' that does
the hiding you require.  mxODBC, by the way, basically meets this
specification, so you may well be able to use it underneath while
programming to the DB-API.
At http://www.python.org/topics/database/, you'll also get links
to the older 1.0 Db-API, to lists of Python modules written to
the API's or outside them, and other various sundries.

See, also:
http://www.chordate.com/kwParsing/gadfly.html
where you'll find a module that also basically implements the
DB-API (albeit in the previous 1.0 version, not current 2.0,
I think), but is entirely in Python (with optional speedup help
from a C-coded written-for-Python auxiliary module) -- very
handy for small-ish tasks that don't require a RDBMS' full
power but can still profit from handy SQL use...


Alex