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

Trying to debug `asyncpg.exceptions._base.InterfaceError: cannot perform operation: another operation is in progress` Open

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

MagicStack/asyncpg#537 · 7 comments · 6 reactions · Opened Mar 2, 2020
FR: cluster connection pool with fail-over Open

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

MagicStack/asyncpg#532 · 1 comment · Opened Jan 24, 2020
copy_from_query fails without uvloop Open

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

MagicStack/asyncpg#529 · 2 comments · 9 reactions · Opened Jan 17, 2020
NOTIFY/LISTEN and connection loss Open

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

MagicStack/asyncpg#519 · 7 comments · 3 reactions · Opened Jan 6, 2020
connection error Open

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

MagicStack/asyncpg#513 · 3 comments · 3 reactions · Opened Dec 5, 2019
passing a list\set as an argument failing Open

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

MagicStack/asyncpg#511 · 5 comments · Opened Nov 29, 2019
FAQ, statement_cache_size=0... Open

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

MagicStack/asyncpg#507 · 5 comments · Opened Nov 24, 2019
Fix test_adversity to work on Windows/Python 3.8 Open

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

MagicStack/asyncpg#505 · Opened Nov 20, 2019
connection.close is throwing protocol error Open

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

MagicStack/asyncpg#490 · 8 comments · 2 reactions · Opened Oct 24, 2019
Application name with pgbouncer Open

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

MagicStack/asyncpg#479 · 1 comment · Opened Sep 24, 2019
README missing Database Port number in the example. Open

Difficulty 1/5 Under an hour Newbie friendliness 35/100

MagicStack/asyncpg#469 · 1 comment · Opened Jul 24, 2019
ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: EE certificate key too weak Open

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

MagicStack/asyncpg#466 · 5 comments · 1 reaction · Opened Jul 16, 2019
backpressure on LISTEN? Open

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

MagicStack/asyncpg#463 · 5 comments · 1 reaction · Opened Jul 8, 2019
cannot stream cursor on very large table Open

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

MagicStack/asyncpg#462 · 15 comments · Opened Jul 6, 2019
Prepared_stmt.fetch() should explicitly either return None or an empty list Open

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

MagicStack/asyncpg#459 · 4 comments · Opened Jun 28, 2019
TypeError: can't set attributes of built-in/extension type 'asyncpg.Record' Open

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

MagicStack/asyncpg#452 · 2 comments · Opened Jun 6, 2019
cant pickle asyncpg.record Open

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

MagicStack/asyncpg#451 · 5 comments · 1 reaction · Opened Jun 5, 2019
Client not reconnecting after postgres restarting Open

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

MagicStack/asyncpg#447 · 3 comments · Opened May 23, 2019
Infinite hang on leaving conn.transaction() block Open

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

MagicStack/asyncpg#442 · 5 comments · Opened May 13, 2019
Document exceptions Open

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

MagicStack/asyncpg#441 · 9 reactions · Opened May 8, 2019
Note which kwargs are safe to pass to Pool.set_connect_args Open

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

MagicStack/asyncpg#439 · 1 comment · Opened May 7, 2019
How i can return all rows without fetch method? Because this method returns a Record instance, and i can't get values from rows. Open

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

MagicStack/asyncpg#430 · 1 comment · Opened Apr 6, 2019
How are Postgres server restarts handled? Open

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

MagicStack/asyncpg#421 · 2 comments · Opened Mar 22, 2019
Cannot use custom codec for non-scalar type Open

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

MagicStack/asyncpg#413 · 5 comments · Opened Mar 8, 2019
OverflowError: date value out of range Open

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

MagicStack/asyncpg#412 · 5 comments · Opened Feb 18, 2019
[Question] Generate Record from Record subset of keys? Open

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

MagicStack/asyncpg#407 · 1 comment · Opened Feb 7, 2019
BC dates result in error running the query Open

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

MagicStack/asyncpg#404 · 3 comments · Opened Jan 29, 2019
notified on shutdown Open

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

MagicStack/asyncpg#403 · 1 comment · Opened Jan 28, 2019
Best way to spread query over multipule asyncio tasks? Open

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

MagicStack/asyncpg#395 · 3 comments · Opened Dec 29, 2018
asyncpg.exceptions.UndefinedFunctionError: function pg_listening_channels() does not exist Open

need more info

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

MagicStack/asyncpg#394 · 4 comments · Opened Dec 25, 2018
Type hints Open

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

MagicStack/asyncpg#387 · 1 comment · 32 reactions · Opened Nov 10, 2018
check if the pool has a free connection Open

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

MagicStack/asyncpg#381 · 2 comments · Opened Oct 24, 2018
Support using pre-hashed passwords Open

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

MagicStack/asyncpg#378 · 12 comments · Opened Oct 22, 2018
How to remove log listeners for a pool:ed connections. Open

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

MagicStack/asyncpg#377 · 8 comments · Opened Oct 21, 2018
asyncpg __del__ methods call asyncio APIs directly, which isn't guaranteed to work and indeed, doesn't work Open

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

MagicStack/asyncpg#376 · 1 comment · Opened Oct 13, 2018
fails to compile under pypy Open

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

MagicStack/asyncpg#369 · 7 comments · 8 reactions · Opened Sep 25, 2018
Share connections from a pool with different databases in the same PG server Open

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

MagicStack/asyncpg#368 · 6 comments · Opened Sep 21, 2018
no decoder for composite type element in position _ of type OID _ Open

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

MagicStack/asyncpg#360 · 8 comments · 2 reactions · Opened Sep 12, 2018
Get number of rows in cursor ? (equivalent to psycopg2#cursor.rowcount) Open

question

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

MagicStack/asyncpg#359 · 5 comments · Opened Sep 10, 2018
Is it possible to specify multi hosts dsn for connection pool? Open

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

MagicStack/asyncpg#352 · 19 comments · 1 reaction · Opened Aug 29, 2018
Does COPY FROM gaurentee no partial rows? Open

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

MagicStack/asyncpg#344 · 2 comments · Opened Aug 17, 2018
greenplum->copy_records_to_table support needed Open

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

MagicStack/asyncpg#333 · 1 comment · Opened Jul 30, 2018
connection was closed in the middle of operation Open

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

MagicStack/asyncpg#309 · 29 comments · 15 reactions · Opened Jun 6, 2018
Making pool connection cycling async Open

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

MagicStack/asyncpg#255 · 5 comments · 5 reactions · Opened Feb 5, 2018
Pool connect ignores DNS ttl Open

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

MagicStack/asyncpg#254 · 4 comments · Opened Feb 5, 2018
AttributeError: 'NoneType' object has no attribute 'cancelled' Open

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

MagicStack/asyncpg#240 · 12 comments · Opened Jan 9, 2018
DuplicatePreparedStatementError not solved for Pgbouncer behind ha settings Open

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

MagicStack/asyncpg#239 · 4 comments · Opened Jan 1, 2018
PyPy3 support? Open

enhancement

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

MagicStack/asyncpg#224 · 7 comments · 7 reactions · Opened Nov 5, 2017
Feature request: copy_records_to_file Open

enhancement

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

MagicStack/asyncpg#171 · Opened Jul 13, 2017
Feature Request: Middleware Open

enhancement

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

MagicStack/asyncpg#152 · 3 comments · 5 reactions · Opened Jun 9, 2017

MagicStack/asyncpg

Get new issues in your inbox