> On Feb 4, 2021, at 03:16, Denis Laxalde <denis.laxa...@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 completely incompatible break
with the psycopg2 interface. There is an enormous body of code out there that
uses the current cursor() interface for client-side cursors.
Second, it would be very unwise to make guarantees about when these operations
interact with the database. I think that any client application should expect
that both cursor.execute() and cursor.fetchone()/.fetchall() are asynchronous
operations, and code appropriately.
--
-- Christophe Pettus
x...@thebuild.com
