psycopg2 and large queries

[Laszlo Nagy]

> Well, there are plenty of PostgreSQL modules around these days, and
> even if pyPgSQL isn't suitable, I'm sure that there must be one which
> can be made to work on Windows and to support server-side cursors. See
> here for more:
>
> http://wiki.python.org/moin/PostgreSQL
>   
I'm just looking for something that can replace psycopg2, because of the 
bug mentioned in my original post. Here are my options:

- psycopg1: development stalled
- psycopg2: memory bug and/or not db api compilant (see my original post)
- pyPgSQL: looks like that the last release was in mid 2006 (and it 
depends on mxDateTime -> licensing problems)
- mxODBC: commercial
- PyGresSQL: apparently, it does not support fetching one row, only 
fetching all rows (see: 
http://www.pygresql.org/pg.html#getresult-get-query-values-as-list-of-tuples), 
so this is not an option. (Yes, it also has a db api compilant module, 
but it is only a wrapper around pgqueryobject, and it does not support 
server side cursors...)

So there are many options, but do we have one that:

1. supports server side cursors (fetch some rows after opening the 
query, but not all of them)
2. open source, with no licensing problems
3. actively maintained

Thanks,

Laszlo