Date: Fri, 5 Feb 2021 10:41:21 +0100
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: psycopg@lists.postgresql.org, psycopg@postgresql.org
Subject: Re: about client-side cursors
Message-ID: <YB0SwZapH8LujF6O@hermes.hilbert.loc>
Mail-Followup-To: psycopg@lists.postgresql.org, psycopg@postgresql.org
References: <20210203161548.vkhu3qkpvmgvyhik@dalibo.com>
 <CA+mi_8a1ery2xvb+AdxMtVXydOdGC7wRMnfXNAvk8v73HsLFyw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CA+mi_8a1ery2xvb+AdxMtVXydOdGC7wRMnfXNAvk8v73HsLFyw@mail.gmail.com>
Ma_X_il-Followup-to: d
Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net
Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net
X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net
X-Pri_X_ority: 2 (High)
Sender: <karsten.hilbert@gmx.net>
X-Provags-ID: V03:K1:fKY44silTXv7b3twvFuaA/nB0tKyowZxX0+AOh5Q6+SnpQh2Ud+
 4mCfbXC5n//6lhDEAUBaRm8wyHKo50Q1fpbSvE35BJPL+VVbWq97WFtiX5lzgb8flCQt9Ip
 88LlDq2/VMJnYzvRxeGQOTJg4SjDaBKTdjZIVOQ2U+PAK8URKufLRCQ83mZQfOy4CtcLIw+
 ziaZMP+n6FOaQai4NaTpA==
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:6JcMehK6FRM=:HJZ+xf7vRIRDQs4JZ4/SFt
 PALTtyf7WVdBiNRVmK4t3bm3iaszE2s5c7A/2iaWtLiY21ZaHFv/kd59Ux16tD52M24giSNYe
 1lfMzCtyjmPMcxhf+/O4jQwDuC7rNQCo0Gu7EPYrU3aKdlE5N/GmvEI8UzO56AdX1DBMG7cbN
 q8ru6Zvfg/GN5yL9rEn2N/n7Fwel+ieqNPb8K/pQz4jpITZ6c8sgdHiwB5PcWmlChHN8uWDbr
 wlVbRixXP6HtjQF3tmIk/RXj1fuwweY0TIlU1ErQ7bg3VEG5clXg2DJZFk7rUBPWdkDYubCKE
 pob5DYA7OWzK1iv7EnDaooJsYxinUdCXTHQ4liBvOylKHnyIf6qPB0fg/Y0/SUWx31qSlLhsz
 Lz/uq66JUokp/P5t4xdtzplR1Y5IIwRXHgfeuXVarWiGypZHMr0hBSXNPmdBze3o5fxGFb1cs
 dJy0dzOsK4sjXA8fQ7t+SCMJgYxGo8PjlzYPD+qgLrsBXM8e148a9WOrF3uAV6jzTVZPRo/4B
 vsotveo0/Y2kLyNohG0SMl2l05voNMhcXXWwZe2tJ+a+wCve4ID8J92c4TUg7KEBvBN/Aj98m
 9O8P2ii/pILF8sFGJgcPyRbzq1prs0X5w5MmfKcMy1oeNjmLJs3GSl+ad575DQZx1+7W9fmeG
 AuRx9NXCFiuGH3dfex/P/U8fzJFb7c5dThSCq4QUCKMPRXo0C2877+4307OeDiEsvCXlHx65k
 xOrTjTLX5DWYDk1bzE2ISPydnkExHEjql+PtsC/advVOeFtRYUX60TEHePaXasi7EE0hH6daD
 uoFpnBp23e1q5YNJ0YUfvGjCTbGZvwpFpsrRd7D+WVnWzykrF3lnDkxcQp/euwrJbLWuujIYC
 2XTqSShig3896cSc4dVQ==
Content-Transfer-Encoding: quoted-printable
List-Id: <psycopg.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:psycopg@lists.postgresql.org>
List-Owner: <mailto:psycopg-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/psycopg>
Precedence: bulk

Am Wed, Feb 03, 2021 at 06:44:33PM +0100 schrieb Daniele Varrazzo:

> Yes, that's correct: the name comes from the dbapi. The dbapi cursor
> does two different things indeed: it runs queries and manages results.
> I understand that the overlap is sort of weird and everyone who has
> said "psycopg sucks: let me write my own driver" have used the mental
> model - much more familiar - of "I ask a query to a connection which
> gives me a result". So usually what is created is something which can
> be used as:
>
>     result =3D conn.execute(query, vars)
>     for record in result:
>         ...
>
> This is understandable, so much that in psycopg3 I've added
> conn.execute, which is implemented as:
>
>     def execute(self, query, vars)
>         cur =3D self.cursor()
>         cur.execute(query, vars)
>         return cur
>
> and allow you to use the cursor only to iterate on the data returned,
> ignoring the execute*() methods.

Given that people interested in using conn.execute() don't
seem to want to concern themselves with cursors at all (until
there's an explicit need, at which point they would seem to
want a server-side cursor, and use conn.cursor()), and the
fact that conn.execute() is outside the DB-API anyway, I
wonder whether this

	class connection:
	     def execute(self, query, vars)
	         cur =3D self.cursor()
	         cur.execute(query, vars)
	         return cur.fetchall()

makes even more sense ?

Perhaps even reconsider naming it "execute".

> The Server versions have I/O done on fetch*() and on close(). So the
> first three objects might have non-async fetch(). I was preferring to
> give all them an uniform interface

+1

Karsten
=2D-
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B