Hello!
Right now I'm trying out the AsyncSession in the SQLAlchemy@1.4 which uses asyncpg under the hood and as it turns out that specific configuration does not work well with pgbouncer even if you disable statement caching both in asyncpg and SQLAlchemy.
As discussed in the corresponding issue — sqlalchemy/sqlalchemy#6467 — SQLAlchemy uses Connection.prepare() regardless of user's decision on whether or not to use prepared statements. It is required to fetch the query attributes.
It looks like if there would be an ability to fetch attributes of the query without preparing it first, the issue could be mitigated. Therefore, I wanted to ask if there is a way to fetch those attributes without calling Connection.prepare() first?
cc @zzzeek
Hello!
Right now I'm trying out the
AsyncSessionin theSQLAlchemy@1.4which usesasyncpgunder the hood and as it turns out that specific configuration does not work well withpgbouncereven if you disable statement caching both inasyncpgandSQLAlchemy.As discussed in the corresponding issue — sqlalchemy/sqlalchemy#6467 —
SQLAlchemyusesConnection.prepare()regardless of user's decision on whether or not to use prepared statements. It is required to fetch the query attributes.It looks like if there would be an ability to fetch attributes of the query without preparing it first, the issue could be mitigated. Therefore, I wanted to ask if there is a way to fetch those attributes without calling
Connection.prepare()first?cc @zzzeek