Using asyncpg pool to get data from crateDB database

Dear Community

How could I use a asyncpg connection pool to query data from a database within streamlit? I know async functions are a bit tricky in streamlit, but there are some solutions mentioned here

I am a bit concerned how connections will be handled across multiple users and if the whole thing doesn’t collapse at a certain point.

As far as my understanding reaches the st.connection works similar to a connection pool, but I wasn’t able to establish an connection for my crateDB cluster. The listed drivers are documented here. Does everybody have experience to create this connection type? To be honest I am a bit lost. :face_with_spiral_eyes:

Regards Schabi