asyncpg
asyncpg copied to clipboard
A fast PostgreSQL Database Client Library for Python/asyncio.
Hi, and thanks for all the work on asyncpg! 👋 I’ve noticed that fresh connections usually emit introspection queries even for statements involving simple arrays of integers. Looking at the...
## Summary Improves type inference in `async with pool.acquire()` by: 1. Adding `-> connection.Connection` return type to `PoolAcquireContext.__aenter__` 2. Renaming internal attribute `self.connection` to `self._conn` to avoid confusion and help...
I love `asyncpg`, been using it for years. However recently came across some unexpected behavior with v 0.30.0. It goes a little something like this. Initialize a pool with a...
Hello, I noticed I can't create a type codec for a composite type if it has a field of type `json`, a `jsonb` or a `geometry` type. Why is so...
hey all, SQLAlchemy guy here, we have a user who submitted a complex deadlock example using asyncpg, and after much effort I've managed to eliminate all of SQLAlchemy as a...
when using `Connection.copy_from_query` I had a statement which eventually resolved to something like: ```sql COPY ( select 1 from field_year_crop_variety_layer fycvl cross join filters join field_meta fm on fm.field_id =...