Re: [SQLObject] PyPgSQL support?

[Edmund L. <el...@in...>]

Ian Bicking wrote:

> I chose psycopg because it was there -- I'm not up enough on Postgres to
> know what drivers are best, though psycopg seems to be one of the more
> actively maintained.

I've used it. It is pretty good and is actively maintained. In my 
benchmarks, psycopg was faster. But, pyPgSQL uses a Python style license 
whereas psycopg uses the GPL. May or may not be important.

pyPgSQL does wrap results in a class that allows access to columns via 
attribute style access, but it's not real important if you're layering 
SQLObject on top of it. Support for Python datatypes seems better than 
in psycopg

To get last OID, use cursor.oidValue. It isn't standard across 
PostgreSQL drivers. Oh, one other thing--cursor.rowcount doesn't return 
anything unless a fetch is performed first, unlike psycopg.

...Edmund.