MagicStack/asyncpg

View on GitHub

A fast PostgreSQL Database Client Library for Python/asyncio.

Stars: 8.1k
Forks: 468
Open beginner issues: 0
Indexed issues: 257

Dominant language: Python
License: Apache-2.0
Last GitHub push: Sep 19, 2026
Latest indexed: Sep 19, 2026
Contributing guide: No contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed
PR merge metrics: No merged PRs in 30d

Beginner friendly Everything

Open All

257 open issues indexed

cannot switch to state 15; another operation (2) is in progress Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

MagicStack/asyncpg#784 · 2 comments · 3 reactions · Opened Jul 20, 2021
Unable to use f-string in SqlAlchemy ORM Open

Difficulty 4/5 3-5 days Newbie friendliness 22/100

MagicStack/asyncpg#781 · 1 comment · 2 reactions · Opened Jul 14, 2021
text encoding of composite types error with schema and table name. Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

MagicStack/asyncpg#779 · 1 comment · Opened Jul 2, 2021
column reference X is ambiguous Open

Difficulty 4/5 3-5 days Newbie friendliness 20/100

MagicStack/asyncpg#773 · 1 comment · Opened Jun 19, 2021
decimal.InvalidOperation exception is thrown with AWS Redshift. Open

Difficulty 4/5 3-5 days Newbie friendliness 30/100

MagicStack/asyncpg#766 · 1 comment · 2 reactions · Opened Jun 7, 2021
Segfault with NULL value in cell Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

MagicStack/asyncpg#764 · 1 comment · Opened May 29, 2021
set_type_codec() doesn't work with copy_records_to_table() Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

MagicStack/asyncpg#762 · 1 comment · Opened May 25, 2021
Implement AsyncContextManager for connection Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

MagicStack/asyncpg#760 · 1 comment · 3 reactions · Opened May 24, 2021
advice: best bulk upsert method that still allows to track # of affected rows? Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

MagicStack/asyncpg#755 · 8 comments · 1 reaction · Opened May 6, 2021
Concurrent queries on single connection Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#738 · 6 comments · Opened Apr 10, 2021
asyncpg does not work with "sslmode" query param when called from SQLAlchemy Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#737 · 18 comments · 11 reactions · Opened Apr 8, 2021
LOG: could not receive data from client: Connection reset by peer Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

MagicStack/asyncpg#736 · 2 comments · 3 reactions · Opened Apr 4, 2021
DeprecationWarning: The loop argument is deprecated since Python 3.8, and scheduled for removal in Python 3.10. Open

Difficulty 2/5 1-3 hours Newbie friendliness 45/100

MagicStack/asyncpg#730 · 1 comment · 1 reaction · Opened Mar 29, 2021
Something is setting the result on a completed task? Open

Difficulty 3/5 1-2 days Newbie friendliness 48/100

MagicStack/asyncpg#729 · 5 comments · Opened Mar 29, 2021
AtributeError: 'NoneType' object has no attribute 'resume_reading' Open

MagicStack/asyncpg#726 · 4 comments · 1 reaction · 1 assignee · Opened Mar 26, 2021
asyncpg.exceptions.ReadOnlySQLTransactionError: cannot execute UNLISTEN during recovery Open

Difficulty 3/5 1-2 days Newbie friendliness 38/100

MagicStack/asyncpg#707 · 4 comments · Opened Feb 23, 2021
Long running pool connections go stale and can not be used Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

MagicStack/asyncpg#704 · 1 comment · Opened Feb 17, 2021
set_type_codec encoder to handle numpy/pandas null types not working with copy_records_to_table Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

MagicStack/asyncpg#693 · 3 comments · 1 reaction · Opened Jan 20, 2021
Value yielded by PoolAcquireContext is mistyped by IDEs Open

Difficulty 3/5 1-2 days Newbie friendliness 38/100

MagicStack/asyncpg#685 · 1 comment · 1 reaction · Opened Jan 1, 2021
Impossible to select arbitrary column when using SQLAlchemy Open

Difficulty 3/5 1-2 days Newbie friendliness 25/100

MagicStack/asyncpg#681 · 2 comments · Opened Dec 21, 2020
Explain iterable cursors in the documentation Open

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

MagicStack/asyncpg#677 · 1 comment · Opened Dec 16, 2020
cockroachdb crdb - enums not working with prepared statements Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#658 · 8 comments · 2 reactions · Opened Nov 25, 2020
A weird log line from the asyncio default exception handler: "Resetting connection with an active transaction" Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

MagicStack/asyncpg#652 · 2 comments · 1 reaction · Opened Nov 4, 2020
Cockroachdb copy_records_to_table support? Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#650 · 5 comments · Opened Nov 2, 2020
Can I directly convert query results to orjson? Open

Difficulty 5/5 Over a week Newbie friendliness 20/100

MagicStack/asyncpg#639 · 1 comment · Opened Oct 19, 2020
Implementation of shared mode connection pool. Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

MagicStack/asyncpg#636 · 10 comments · Opened Oct 14, 2020
authentication issue with md5 on postgres 11 Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

MagicStack/asyncpg#626 · 7 comments · Opened Sep 24, 2020
ConnectionDoesNotExistError when releasing Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

MagicStack/asyncpg#624 · 4 reactions · Opened Sep 23, 2020
Feature Request: Retry on failed acquires (timeouterror/connectionerror) Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

MagicStack/asyncpg#620 · 10 reactions · Opened Sep 18, 2020
Feature request: Support client side keepalives Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

MagicStack/asyncpg#606 · 3 comments · Opened Aug 11, 2020
Please add scalable app file structure in documentation. Also is my approach correct? Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

MagicStack/asyncpg#602 · 2 reactions · Opened Jul 26, 2020
How to print the executed SQL Open

Difficulty 2/5 1-3 hours Newbie friendliness 25/100

MagicStack/asyncpg#601 · 1 comment · 2 reactions · Opened Jul 23, 2020
Including asyncpg in PyInstaller-created executable? Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

MagicStack/asyncpg#596 · 8 comments · Opened Jul 6, 2020
execute/executemany are missing from prepared statements Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

MagicStack/asyncpg#592 · 1 comment · 2 reactions · Opened Jun 18, 2020
[BUG] Bare connections cannot be used as context managers Open

Difficulty 3/5 1-2 days Newbie friendliness 35/100

MagicStack/asyncpg#583 · 2 comments · 24 reactions · Opened Jun 3, 2020
asyncpg error: “no pg_hba.conf entry for host” in Heroku Open

Difficulty 5/5 Over a week Newbie friendliness 15/100

MagicStack/asyncpg#582 · 1 comment · Opened May 31, 2020
Cockroachdb unimplemented feature multiple active portals not supported Open

Difficulty 4/5 3-5 days Newbie friendliness 28/100

MagicStack/asyncpg#580 · 19 comments · 2 reactions · Opened May 31, 2020
asyncpg.exceptions._base.InterfaceError: cannot perform operation: another operation is in progress when executing gino processes in parallel Open

Difficulty 4/5 3-5 days Newbie friendliness 30/100

MagicStack/asyncpg#576 · 8 comments · Opened May 18, 2020
Fetching from pgpool-II hangs indefinitely Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#573 · 34 comments · Opened May 13, 2020
[Feature] mypy typings Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

MagicStack/asyncpg#569 · 9 comments · 53 reactions · Opened May 5, 2020
Unimplemented feature for INSERT queries on ARRAY columns with CockroachDB Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#568 · Opened May 5, 2020
In Record complex data coming as string Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

MagicStack/asyncpg#560 · 4 comments · Opened Apr 23, 2020
Ident authentication failed for user "postgres" Open

Difficulty 3/5 1-2 days Newbie friendliness 20/100

MagicStack/asyncpg#558 · 4 comments · Opened Apr 19, 2020
TimeoutError when connecting to server Open

Difficulty 4/5 3-5 days Newbie friendliness 20/100

MagicStack/asyncpg#557 · 5 comments · Opened Apr 17, 2020
Upon postgres segfault, connections in `async for record in conn.cursor` fail to detect loss of connectivity and hang indefinitely Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

MagicStack/asyncpg#549 · 3 comments · Opened Apr 1, 2020
Allow coroutines on add_listener. Open

Difficulty 4/5 3-5 days Newbie friendliness 32/100

MagicStack/asyncpg#546 · 3 comments · 1 reaction · Opened Mar 24, 2020
Unable to set Codec to Custom Type (pguint) Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

MagicStack/asyncpg#545 · 8 comments · Opened Mar 19, 2020
Serializing Connection/Pool/Record objects Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

MagicStack/asyncpg#544 · 1 comment · Opened Mar 19, 2020
import asyncpg locally with compilation error Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

MagicStack/asyncpg#543 · 2 reactions · Opened Mar 18, 2020
Can't add schema name to query in fetch function Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

MagicStack/asyncpg#538 · Opened Mar 11, 2020

MagicStack/asyncpg

Get new issues in your inbox