recommendation for creating a connexion pool

[tahayk]

I have been using clickhouse-driver for the past 2 years and it works perfectly,
But now I need to create a connexion pool for it, by looking online I found different ideas.
Any recommendation about how to do it ?
PS: I'm not using any ORM, and the API I'm creating is built using FastAPI.

Thank you in advance.

[xzkostyan]

Hi.

There is clickhouse-pool package.

I've tried to connect with author of the package for merging pool into uptsream. But didn't get any response.

[tahayk]

Hey @xzkostyan
Thank you for your recommendation, but I think it is not maintained anymore.

[zgpnuaa]

Any progress?
Can clickhouse-pool be integrated into this?Author of clickhouse-pool have no problem with anyone from the community merging the work together but
he do not have time at the moment to do it himself.
clickhouse-pool