MagicStack/asyncpg

A fast PostgreSQL Database Client Library for Python/asyncio.

Stars: 8.1k
Forks: 469
Open beginner issues: 2
Indexed issues: 257
Avg merge: 2d 20h
Merged PRs (30d): 9

Dominant language: Python
License: Apache-2.0
Last GitHub push: Sep 20, 2026
Latest indexed: Sep 19, 2026
Contributing guide: No contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed

Beginner friendly Everything

Open All

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
allow name parametr llike this! Open

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

MagicStack/asyncpg#1023 · 2 comments · Opened Apr 18, 2023
When using Redshift - PostgresSyntaxError: syntax error at or near "ORDER" - in query with no "ORDER" Open

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

MagicStack/asyncpg#1009 · 10 comments · Opened Mar 3, 2023
Database timezone ignored for timestamptz Open

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

MagicStack/asyncpg#1006 · 3 comments · Opened Feb 19, 2023
Await connection in debugpy Open

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

MagicStack/asyncpg#1005 · 1 comment · Opened Feb 17, 2023
Continuous memory increase in Sanic web server after calling `loop.start_tls(...)` in `connect_utils._create_ssl_connection` Open

MagicStack/asyncpg#1004 · 2 comments · 1 assignee · Opened Feb 17, 2023
asyncpg does not install with python 3.12-dev Open

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

MagicStack/asyncpg#1003 · 13 comments · 4 reactions · Opened Feb 16, 2023
DEFAULT NOW() WITH TIME ZONE 'UTC' is getting ignored, thus returning a naive datetime when queried. Open

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

MagicStack/asyncpg#1002 · 3 comments · Opened Feb 11, 2023
List[str] parameter treated as text instead of text[] in certain requests Open

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

MagicStack/asyncpg#996 · 2 comments · Opened Jan 28, 2023

Showing the newest 100

This page lists what was indexed most recently. Advanced filter has the whole inventory, narrowed by language, difficulty and how long a task takes.

Open advanced filter

MagicStack/asyncpg

Showing the newest 100

Get new issues in your inbox