I’m almost certain you are wrong. the eventstore postgres client holds a pointer to the sqlx.DB and that thing has a connection pool.
individual http reqs are obviously handled in a new routine but the db instance should be shared across reqs.
ben /
npub100…w7nql
2024-07-31 21:31:31
in reply to nevent1q…2ez4
Author Public Key
npub10000000thpep7auj058803nqtymqlf3rw87lzhe6mkfeywnpxg5sjw7nqlPublished at
2024-07-31 21:31:31Event JSON
{
"id": "dc64e8e244d4cb4b34034a0dee2fa56f0f2b7ff1239972842d5a5012ca0386a3",
"pubkey": "7bdef7bdebb8721f77927d0e77c66059360fa62371fdf15f3add93923a613229",
"created_at": 1722461491,
"kind": 1,
"tags": [
[
"e",
"ad5d6b8d10bd63afddfb34fb1c924e7aa76dd0c2aca5caa8f58334f7ddad502c",
"",
"root"
],
[
"e",
"7a3cc60ba57e0abe2376c9078acfaa4f5b6f5cfb462f3391f24bf09cd6f94f07",
"",
"reply"
],
[
"p",
"4c800257a588a82849d049817c2bdaad984b25a45ad9f6dad66e47d3b47e3b2f"
]
],
"content": "I’m almost certain you are wrong. the eventstore postgres client holds a pointer to the sqlx.DB and that thing has a connection pool.\n\nindividual http reqs are obviously handled in a new routine but the db instance should be shared across reqs.",
"sig": "31d404de626cf6a393b065efd649cc304de88ace4180714acc45cddc85a757ed70b1a9d50712bffa84232ef757cbb87c1df303f7e55ece84b58e27a63d1c76ec"
}