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

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
tests fail in 2032 Open

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

MagicStack/asyncpg#997 · Opened Jan 29, 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
asyncpg.exceptions._base.InterfaceError: cannot call Connection.fetch(): connection has been released back to the pool Open

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

MagicStack/asyncpg#988 · 5 comments · 3 reactions · Opened Dec 20, 2022
Connection methods does not accept classic nor unusual arguments supported in other pgsql connection solution Open

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

MagicStack/asyncpg#979 · 7 comments · Opened Nov 25, 2022
Issuing Advisory Lock Open

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

MagicStack/asyncpg#972 · 1 comment · Opened Oct 28, 2022
Disconnection from postgres-compatible google cloud AlloyDB instance hangs Open

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

MagicStack/asyncpg#962 · 1 comment · Opened Oct 5, 2022
Handle additional InterfaceError types when inside a transaction Open

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

MagicStack/asyncpg#956 · 1 reaction · Opened Sep 29, 2022
Unable to connect to RDS Proxy Open

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

MagicStack/asyncpg#952 · 24 comments · 14 reactions · Opened Sep 6, 2022
Functions with record array paraments Open

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

MagicStack/asyncpg#951 · 1 comment · Opened Aug 29, 2022
Timeout Error on Ubuntu 20.04 LTS. asyncpg.create_pool Open

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

MagicStack/asyncpg#944 · Opened Aug 7, 2022
Support for `WHERE` clause when usng `copy_to_table` method Open

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

MagicStack/asyncpg#939 · 1 comment · Opened Jul 27, 2022
PostgresSyntaxErrror while copy_records_to_table method call Open

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

MagicStack/asyncpg#932 · 1 comment · Opened Jul 5, 2022
Support for Postgres-like Clusters Open

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

MagicStack/asyncpg#931 · Opened Jun 27, 2022
Update documentation to cover testing using pytest Open

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

MagicStack/asyncpg#930 · 1 comment · 5 reactions · Opened Jun 24, 2022
Asyncpg does not seem to clear memory allocated to Pool object after db.disconnect() (possible memory leak) Open

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

MagicStack/asyncpg#929 · 1 comment · 5 reactions · Opened Jun 23, 2022
0.25.0: sphinx warnings `reference target not found` Open

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

MagicStack/asyncpg#928 · Opened Jun 21, 2022
asyncpg + aiogram is not working Open

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

MagicStack/asyncpg#927 · 1 comment · Opened Jun 19, 2022
set value to datetime.time for TIME type is not working Open

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

MagicStack/asyncpg#920 · 1 comment · Opened May 28, 2022
Installing build dependencies ... error Open

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

MagicStack/asyncpg#917 · 1 comment · 4 reactions · Opened May 18, 2022
Feature request: A way to inspect the query string run by asyncpg Open

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

MagicStack/asyncpg#914 · 1 comment · 1 reaction · Opened May 16, 2022
prepared statement get_attributes Open

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

MagicStack/asyncpg#911 · 1 comment · Opened May 12, 2022
Running process as another user causes permission denied error when setting up database connection. Open

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

MagicStack/asyncpg#910 · 11 comments · 7 reactions · Opened Apr 27, 2022
TimeoutError while using PostgreSQL 12+ Open

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

MagicStack/asyncpg#909 · 1 comment · 2 reactions · Opened Apr 27, 2022
UndefinedTableError: relation "pg_temp.session_vars" does not exist Open

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

MagicStack/asyncpg#908 · 3 comments · Opened Apr 19, 2022
copy_from_query output function receives bytearray Open

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

MagicStack/asyncpg#902 · Opened Mar 26, 2022
asyncpg.exceptions.InternalServerError: UNLISTEN is not supported now. Open

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

MagicStack/asyncpg#897 · 1 comment · Opened Mar 24, 2022
Special character in password raise timeout exception Open

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

MagicStack/asyncpg#894 · 1 comment · Opened Mar 2, 2022
Nested custom types in Postgres break `asyncpg.Record` subclassing Open

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

MagicStack/asyncpg#891 · 2 comments · 1 reaction · Opened Feb 25, 2022
Q: disabling codecs while transferring data? Open

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

MagicStack/asyncpg#890 · 11 comments · Opened Feb 17, 2022
Exception when attempting to fetch SSL info Open

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

MagicStack/asyncpg#884 · 1 comment · 3 reactions · Opened Feb 9, 2022
notice callback not awaited Open

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

MagicStack/asyncpg#876 · 1 comment · Opened Jan 15, 2022
Asyncio task fails to cancel with asyncpg, gets stuck in a permanent loop Open

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

MagicStack/asyncpg#873 · Opened Jan 7, 2022
[Bug] Wrong number of columns Error Open

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

MagicStack/asyncpg#841 · 5 comments · Opened Oct 29, 2021
Multihost bug when working with SqlAlchemy Open

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

MagicStack/asyncpg#840 · 5 comments · Opened Oct 25, 2021
PostgreSQL 14+ Pipelining Support Open

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

MagicStack/asyncpg#839 · 8 comments · 3 reactions · Opened Oct 15, 2021
Large Object support Open

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

MagicStack/asyncpg#826 · 1 comment · 1 reaction · Opened Sep 10, 2021
getaddrinfo() error / exception not re-raised? Open

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

MagicStack/asyncpg#825 · 1 comment · Opened Sep 10, 2021
TimeoutError when calling asyncpg.create_pool() Open

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

MagicStack/asyncpg#824 · 12 comments · Opened Sep 7, 2021
Listener callback that accesses database does not complete fetch Open

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

MagicStack/asyncpg#815 · 3 comments · Opened Aug 22, 2021
File py.typed not found Open

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

MagicStack/asyncpg#809 · 5 reactions · Opened Aug 13, 2021
TempCluster() and pytest Open

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

MagicStack/asyncpg#789 · 2 comments · Opened Jul 27, 2021
using notify listener with all-caps channel names Open

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

MagicStack/asyncpg#788 · 1 comment · Opened Jul 27, 2021
asyncpg.exceptions.DataError: invalid input for query argument python Open

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

MagicStack/asyncpg#787 · 3 comments · 1 reaction · Opened Jul 27, 2021

MagicStack/asyncpg

Get new issues in your inbox