Hello,
I am pleased to see that the pipeline/batch mode is progressing and it
might be released in pg14: https://commitfest.postgresql.org/30/2724/
psycopg3 uses only async functions, even for seemingly blocking calls,
so I think it is in a good position to make use of it. I don't know
yet if it should be a special operation mode, or the normal way to
work, replacing the lock to coordinate cursor interaction with the
connection with a pair of send/receive queues, if we could make
execute only send and fetch receive (ending up giving the async fetch
a proper I/O use, to reconnect to the recent conversation about it).
However I am getting stretched pretty thinly with different directions
of work: main tasks in my queue are:
- connection pool
- binary numeric/datetime adapters
- server-side cursors
- jsonb binary protocol (something to design server-side too)
so I doubt I will be able to hack on a branch of psycopg and a branch
of the libpq to study and design the pipeline possibilities too.
If anyone would like to take up this research task, or even would like
to collaborate on any other task listed above (or on the project
board: https://github.com/psycopg/psycopg3/projects/1) I would be
grateful!
Cheers!
-- Daniele