> On Feb 4, 2021, at 03:16, Denis Laxalde <denis.laxalde@dalibo.com> wrote:
> But, unless I missed it, the PEP does not state how to implement query
> execution and result fetch operations if the database does not need a
> cursor.
First, any change like this would have to maintain their current API essentially forever, unless psycopg3 represents a
completelyincompatible break with the psycopg2 interface. There is an enormous body of code out there that uses the
currentcursor() interface for client-side cursors.
Second, it would be very unwise to make guarantees about when these operations interact with the database. I think
thatany client application should expect that both cursor.execute() and cursor.fetchone()/.fetchall() are asynchronous
operations,and code appropriately.
--
-- Christophe Pettus
xof@thebuild.com