[DB-SIG] Experiences with DB-API2.0

Tom Jenkins tjenkins@devis.com
20 Jun 2002 15:19:44 -0400


On Thu, 2002-06-20 at 15:13, Gerhard H=E4ring wrote:
> * Tom Jenkins <tjenkins@devis.com> [2002-06-20 12:27 -0400]:
> > well, if i need to i use dtuple
> > (http://www.lyra.org/greg/python/dtuple.py) which does what you want.=20
> > Sometimes i just don't need a resultset object, and the returned tuple
> > is just fine (not to mention faster).
> >=20
> > this btw caused a bit of trouble, pyscopg returns tuples, but pypgsql
> > returns there own result object unless you set a flag.  dtuple expects =
a
> > tuple (iirc) so that was another change i had to set <wink>
>=20
> Interesting. Does dtuple still have advantages over pyPgSQL's
> PgResultset in version 2.1? (I've optimized PgResultSet a lot for 2.1)
> And I hope I can optimize cursor fetches a lot more by splitting the
> current Cursor class into several mixins a la MySQLdb.
>=20

well, i do a bunch of pg -> access; access -> pg stuff and i use dtuple
with odbc, ado and pg drivers.  since i share alot of the code between
the pg and odbc/ado,  PgResultSet does not help me at all.

--=20

Tom Jenkins
Development InfoStructure
http://www.devis.com