Re: about client-side cursors

> On Feb 3, 2021, at 09:41, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> wrote:
> Perhaps client-side cursors were invented to make it possible
> to code to the same API regardless of whether real
> (server-side) cursors are used or not ?

That's definitely part of it.

The name "cursor" for the client-side object is a bit unfortunate, but we need *something* there. The operations are:

1. Send query to server and execute it.
2. Retrieve results from server.

Those are both asynchronous operations, and we need something to encapsulate the state to pass from #1 to #2. You could just have the connection object do that, but then we're declaring forever that we can't run two queries at the same time on the same connection, and that seems unwise.

--
-- Christophe Pettus
xof(at)thebuild(dot)com