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
Nican /
npub1xa…zslar
2023-12-09 19:32:33
Author Public Key
npub1xa4rsexhlh332u4sea85rcyezln6v3c3gksdf597mkn6w6a74e2qrzslarPublished at
2023-12-09 19:32:33Event JSON
{
"id": "dc57fc7384a12413fb67c0de3206487c413bb4d9d4f4912ca84243e8177fe5b0",
"pubkey": "376a3864d7fde31572b0cf4f41e09917e7a6471145a0d4d0bedda7a76bbeae54",
"created_at": 1702146753,
"kind": 1,
"tags": [
[
"t",
"csharp"
],
[
"t",
"js"
],
[
"t",
"python"
],
[
"proxy",
"https://furry.engineer/users/nican/statuses/111551889665951450",
"activitypub"
]
],
"content": "C# Dapper has a `QueryMultiple` method, which allows to run multiple SQL statements in a single network round trip. #csharp \n\nhttps://www.learndapper.com/dapper-query/selecting-multiple-results#dapper-querymultiple\n\nThe same can be found with #JS, and from what I can tell, the performance is much better:\n\nhttps://github.com/brianc/node-postgres/blob/master/packages/pg/test/integration/client/multiple-results-tests.js#L15-L24\n\nBut 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.\n\nhttps://github.com/MagicStack/asyncpg",
"sig": "c1f149bbffc04b93776aac5e706fe0d2d8ecf1cf854d159497b2d2e92f024eee827d3268babf099b649a4a049c8f09e05a0a0370bc3661d967b717a6c9feba9a"
}