[DB-SIG] New take on PostgreSQL bindings for Python

[Carsten Haese]

On Thu, 2006-09-07 at 19:25, Cristian Gafton wrote:
> On Thu, 7 Sep 2006, Ricardo Bugalho wrote:
> > DB-API's cursors have always been supposed to be based server side
> > cursors. That's the whole point about having cursors.
> > If some bindings don't use server side cursors when they're available,
> > it's their own problem.
> 
> Well, then it should be spelled out in that fashion.

http://www.python.org/dev/peps/pep-0249/ says:

"""
.cursor()
          
            Return a new Cursor Object using the connection.  If the
            database does not provide a direct cursor concept, the
            module will have to emulate cursors using other means to
            the extent needed by this specification.
"""

The fact that server-side cursors should be used whenever possible is
not stated in so many words, but it is very much implied in the above.

-Carsten