Nican on Nostr: C# Dapper has a `QueryMultiple` method, which allows to run multiple SQL statements ...
C# Dapper has a `QueryMultiple` method, which allows to run multiple SQL statements in a single network round trip. #csharp
https://www.learndapper.com/dapper-query/selecting-multiple-results#dapper-querymultiple
The same can be found with #JS, and from what I can tell, the performance is much better:
https://github.com/brianc/node-postgres/blob/master/packages/pg/test/integration/client/multiple-results-tests.js#L15-L24
But for the life of me, I can not find the same functionality in #Python. I am looking all over asyncpg, or related libraries, and I feel like I am going crazy, because I can not even figure out what part of the Postgres protocol allows for this functionality.
https://github.com/MagicStack/asyncpg
https://www.learndapper.com/dapper-query/selecting-multiple-results#dapper-querymultiple
The same can be found with #JS, and from what I can tell, the performance is much better:
https://github.com/brianc/node-postgres/blob/master/packages/pg/test/integration/client/multiple-results-tests.js#L15-L24
But for the life of me, I can not find the same functionality in #Python. I am looking all over asyncpg, or related libraries, and I feel like I am going crazy, because I can not even figure out what part of the Postgres protocol allows for this functionality.
https://github.com/MagicStack/asyncpg