Database connect / PDO

[Jon Franz]

Yes, an underlying DBAPI driver is required, and mxODBC works...
mostly (see below).
I might recommend the adodbapi driver for use on the windows platform,
but that still leaves mxODBC for linux.

I may be wrong, but I think mxODBC module still doesn't provide all
the values for the DBAPI .description fields - I know the field name
is provided, but I don't know if the size info will be correct, or if a
non-None value will be available for the other attributes.
Thus, some of the Field object's member variables may be meaningless
when used with mxODBC on your project.

Does anyone know offhand when mxODBC will add this info?  I think
its the last (or one of the few) things holding it back from true DBAPI
2.0 compliance.

~Jon Franz
NeuroKode Labs, LLC


----- Original Message ----- 
From: "SectorUnknown" <secun at yahoo.com>
To: <python-list at python.org>
Sent: Monday, November 24, 2003 3:47 PM
Subject: Re: Database connect / PDO


> I've been looking through the documentation for PDO, but it sounds like
> you still need mxODBC. Is this correct?
>
> See: http://sourceforge.net/docman/display_doc.php?docid=20024&group_id=
> 86244#supported
>
> In article <mailman.1029.1069699121.702.python-list at python.org>,
> jfranz at neurokode.com says...
> > > Another possibility is to see if an OR-thingie like PDO/SQLObject/...
> > > actually helps for database abstraction. I suppose they'll get really
> > > "fun" to use once you need advanced queries, though. Does anybody have
> > > any real-life experience with any of these Python OR mappers?
> >
> > I have lots of experience with PDO - but it is not an OR mapper.
> > It's an abstraction layer on top of the DB-API that adds functionality
> > and attempts to make it easier to write your application to a single
> > API.  I guess you could say its the n-1th abstraction layer.
> >
> > PDO might be useful for SectorUnknown's needs.
> >
> > ~Jon Franz
> > NeuroKode Labs, LLC
> >
> >
> >
>
>