Re: about client-side cursors

Поиск
Список
Период
Сортировка
Искать
От
Christophe Pettus
Тема
Re: about client-side cursors
Дата
Msg-id
D5AD2540-1414-4C13-9794-28282C8F5620@thebuild.com
Ответ на
Список
Дерево обсуждения
about client-side cursors Denis Laxalde <denis.laxalde@dalibo.com>
Re: about client-side cursors Christophe Pettus <xof@thebuild.com>
Re: about client-side cursors Karsten Hilbert <Karsten.Hilbert@gmx.net>
Re: about client-side cursors Christophe Pettus <xof@thebuild.com>
Re: about client-side cursors Daniele Varrazzo <daniele.varrazzo@gmail.com>
Re: about client-side cursors Denis Laxalde <denis.laxalde@dalibo.com>
Re: about client-side cursors Christophe Pettus <xof@thebuild.com>
Re: about client-side cursors Denis Laxalde <denis.laxalde@dalibo.com>
Re: about client-side cursors Christophe Pettus <xof@thebuild.com>
Re: about client-side cursors Denis Laxalde <denis.laxalde@dalibo.com>
Re: about client-side cursors Christophe Pettus <xof@thebuild.com>
Re: about client-side cursors Daniele Varrazzo <daniele.varrazzo@gmail.com>
Re: about client-side cursors Daniele Varrazzo <daniele.varrazzo@gmail.com>
Re: about client-side cursors Daniele Varrazzo <daniele.varrazzo@gmail.com>
Re: about client-side cursors Karsten Hilbert <Karsten.Hilbert@gmx.net>
Re: about client-side cursors Daniele Varrazzo <daniele.varrazzo@gmail.com>
Re: about client-side cursors Karsten Hilbert <Karsten.Hilbert@gmx.net>
Re: about client-side cursors Daniele Varrazzo <daniele.varrazzo@gmail.com>
Re: about client-side cursors Denis Laxalde <denis.laxalde@dalibo.com>


> On Feb 3, 2021, at 09:41, Karsten Hilbert  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@thebuild.com



В списке psycopg по дате отправления
От: Daniele Varrazzo
Дата:
Сообщение: Re: about client-side cursors
От: Daniele Varrazzo
Дата:
Сообщение: Re: about client-side cursors
FAQ