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
--
http://mail.python.org/mailman/listinfo/python-list