Python and databases

[John Bell]

Harry George wrote:

> It is only a "problem" if you need every nuance of DBI 2.0.  You can
> get a whole lot of work done using what is available in, e.g., psycopg
> (for Postgresql) and MySQl-python (for MySQL).

I think this is missing the key point (in a practical sense) of the
standard.  If you're going to take a significant body of code from one DB
to another  or support multiple databases for different customer needs
then you are much better off with standard interfaces.  Unless you're in
the unusual position of being able to dictate technology choices to your
customer this is an important issue in S/W businesses.

John

>
>
> "Alex Martelli" <aleaxit at yahoo.com> writes:
>
> > "Pieter Laeremans" <pieter at kotnet.org> wrote in message
> > news:991557251.316332 at seven.kulnet.kuleuven.ac.be...
> > > Hi,
> > >
> > > Does python has something like perl 's DBI?
> > > I can 't find any documentation about it in the python docs.
> >
> > http://www.python.org/topics/database/
> >
> > The problem may be finding complete implementations of
> > the current (release 2.0) DB-API spec, but that depends on
> > a lot of factors: are you going to make commercial use of
> > it, and in that case do you have funding -- for non-commercial
> > use, OR for pay in the case of commercial use, you can get
> > Lemburg's excellent mxODBC implementation (if ODBC is
> > what you want to use).  You can also get implementations
> > for quite a few specific database engines.
> >
> >
> > Alex

--

Regards,
John Bell