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

Typing: Correctly set types when getting `Record` fields Open

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

MagicStack/asyncpg#1210 · Opened Nov 5, 2024
Custom CursorIterator Open

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

MagicStack/asyncpg#1208 · 2 comments · Opened Nov 4, 2024
unknown function name: set_config(STRING,STRING,BOOLEAN) when using parameters in `CONCAT` function Open

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

MagicStack/asyncpg#1207 · Opened Nov 2, 2024
Compatibility Issue with asyncpg 0.30.0 in Gino 1.0.1 Open

MagicStack/asyncpg#1204 · 1 reaction · 1 assignee · Opened Oct 31, 2024
Return types annotations when Open

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

MagicStack/asyncpg#1201 · Opened Oct 29, 2024
Add equivalent to psycopg2 `register_adapter` Open

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

MagicStack/asyncpg#1186 · 2 comments · Opened Oct 4, 2024
minor suggestion: fetchcol() method Open

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

MagicStack/asyncpg#1183 · Opened Sep 28, 2024
Use UTC for `timestamp without time zone` Open

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

MagicStack/asyncpg#1176 · 2 comments · 1 reaction · Opened Aug 22, 2024
Unexpected/undesirable `CAST` of date string to `VARCHAR` Open

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

MagicStack/asyncpg#1174 · Opened Aug 18, 2024
No rows returned by fetch() when for DELETE rewritten to UPDATE using rule Open

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

MagicStack/asyncpg#1173 · 2 comments · Opened Aug 7, 2024
Not accepting str as value for interval/date columns Open

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

MagicStack/asyncpg#1169 · 2 comments · 3 reactions · Opened Jul 25, 2024
Extremely long delay grabbing type info for string array (and likely other types) on CockroachDB Open

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

MagicStack/asyncpg#1158 · 15 comments · Opened Jun 5, 2024
Terminate function does not work when a stream is cancelled prematurely when in an anyio task group Open

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

MagicStack/asyncpg#1156 · 7 comments · Opened May 23, 2024
Timeout configuration for multi-host config Open

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

MagicStack/asyncpg#1155 · 1 comment · 3 reactions · Opened May 18, 2024
RDS Proxy Pinning Open

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

MagicStack/asyncpg#1153 · 1 comment · 1 reaction · Opened May 16, 2024
Connection secrets displayed in clear text in logs Open

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

MagicStack/asyncpg#1152 · 4 reactions · Opened May 10, 2024
cursor prefetch with bounded lag Open

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

MagicStack/asyncpg#1149 · Opened Apr 29, 2024
insufficient data in buffer Open

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

MagicStack/asyncpg#1147 · 1 comment · Opened Apr 18, 2024
no binary format encoder for type jsonb Open

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

MagicStack/asyncpg#1144 · Opened Apr 10, 2024
Feature request: Support for asynchronous command processing Open

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

MagicStack/asyncpg#1141 · 1 comment · 2 reactions · Opened Mar 21, 2024
invalid input for query argument (can't subtract offset-naive and offset-aware datetimes) Open

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

MagicStack/asyncpg#1139 · 6 reactions · Opened Mar 21, 2024
Error: there is no unique or exclusion constraint matching the ON CONFLICT specification Open

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

MagicStack/asyncpg#1137 · 6 comments · Opened Mar 18, 2024
connect through socks5 proxy Open

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

MagicStack/asyncpg#1136 · 2 comments · Opened Mar 16, 2024
Feature request: Make transaction state public Open

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

MagicStack/asyncpg#1130 · Opened Mar 11, 2024
Not using transactions but receiving errors with: Resetting connection with an active transaction Open

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

MagicStack/asyncpg#1126 · Opened Mar 3, 2024
Support typed prepared statements Open

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

MagicStack/asyncpg#1121 · Opened Feb 21, 2024
Use anyio instead of asyncio for trio compatibility Open

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

MagicStack/asyncpg#1119 · 16 reactions · Opened Feb 15, 2024
Support a Pool `before_connect` callback to be used before a connection is created Open

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

MagicStack/asyncpg#1118 · 2 comments · Opened Feb 14, 2024
Cannot use datetimes before UNIX epoch on Windows Open

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

MagicStack/asyncpg#1115 · Opened Jan 14, 2024
negative interval encoding issues due to python's timedelta implementation details Open

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

MagicStack/asyncpg#1114 · 1 comment · Opened Jan 8, 2024
bug: Incorrect serialization of numeric values Open

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

MagicStack/asyncpg#1113 · 8 comments · 1 reaction · Opened Jan 4, 2024
Late/optional decoding? Open

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

MagicStack/asyncpg#1112 · 3 comments · Opened Jan 2, 2024
Document how to confirm that `INSERT` worked with prepared statement Open

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

MagicStack/asyncpg#1108 · 2 comments · Opened Nov 21, 2023
Asyncpg.pool creates more connections than its max_size Open

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

MagicStack/asyncpg#1107 · 2 comments · 6 reactions · Opened Nov 19, 2023
Inserting multiple values in a row Open

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

MagicStack/asyncpg#1106 · 2 comments · Opened Nov 18, 2023
Test failure in test_executemany_server_failure_during_writes Open

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

MagicStack/asyncpg#1099 · 2 comments · Opened Nov 5, 2023
Many concurrent requests block the event loop Open

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

MagicStack/asyncpg#1092 · 10 comments · 1 reaction · Opened Oct 17, 2023
Feature Request: better support for LISTEN/NOTIFY? Open

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

MagicStack/asyncpg#1089 · 3 comments · Opened Oct 11, 2023
TimeoutError on multiple requests Open

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

MagicStack/asyncpg#1076 · 10 comments · 1 reaction · Opened Sep 6, 2023
Support composite types with fields that are of type `citext` Open

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

MagicStack/asyncpg#1075 · 1 comment · Opened Aug 30, 2023
Support for disabling transactions Open

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

MagicStack/asyncpg#1074 · 4 comments · Opened Aug 25, 2023
Add support for PGOPTIONS environment variable Open

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

MagicStack/asyncpg#1070 · Opened Aug 21, 2023
InternalClientError: cannot switch to state 12 Open

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

MagicStack/asyncpg#1069 · 9 comments · 1 reaction · Opened Aug 21, 2023
Authentication issue with postgres14 : InternalClientError: unexpected error while performing authentication: Incorrect padding Open

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

MagicStack/asyncpg#1066 · 2 comments · 1 reaction · Opened Aug 17, 2023
Difference between bulk update with FROM VALUES and without it? Open

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

MagicStack/asyncpg#1055 · 1 comment · Opened Jul 27, 2023
feat: allow connection with pre-configured socket Open

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

MagicStack/asyncpg#1054 · 7 comments · 1 reaction · Opened Jul 27, 2023
Segfault protocol.cpython Open

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

MagicStack/asyncpg#1033 · 2 comments · Opened May 9, 2023
`TypeError: cannot unpack non-iterable NoneType object` when using docker bridge network Open

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

MagicStack/asyncpg#1030 · 1 comment · Opened May 3, 2023
asyncpg.connect() type is Coroutine[Any, Any, Any] Open

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

MagicStack/asyncpg#1028 · 1 comment · Opened Apr 27, 2023
Memory leak with Pool usage Open

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

MagicStack/asyncpg#1024 · 3 comments · 4 reactions · Opened Apr 19, 2023

MagicStack/asyncpg

Get new issues in your inbox