Hacker GitHub

← All repos

MagicStack/asyncpg

View on GitHub ↗ ★ 8,118 Python

A fast PostgreSQL Database Client Library for Python/asyncio.

29 mentions on Hacker News by 23 people: 5 stories, 24 comments · first 2016-07-19 · latest 2024-08-18

Mentions per year 29 mentions · busiest year 2016 (6)
20082026
AllStoriesComments NewestTopOldest
  1. …https://github.com/janbjorge/PgQueuer/blob/main/src/PgQueuer... asyncpg/tests/test_listeners.py: https://github.com/MagicStack/asyncpg/blob/master/tests/test... /? sqlite LISTEN NOTIFY: https://www.google.com/search?q=sqlite+listen+notify…
    comment by westurner · 2024-08-18 · in Show HN: PgQueuer – Transform PostgreSQL into a Job Queue
  2. Thanks! The testing here though shows asyncpg is a lot faster https://github.com/MagicStack/asyncpg Not sure there is a compelling reason to stay with psycopg3 then if asyncpg exists.
    comment by odie5533 · 2024-07-04 · in Psycopg 3.2 released – PostgreSQL driver for Python
  3. If you are operating in an environment with asyncio check out asyncpg - https://github.com/MagicStack/asyncpg Performance charts speak for themselves. This lib uses the binary protocol while most are using text based comms.
    comment by whalesalad · 2024-07-01 · in Psycopg 3.2 released – PostgreSQL driver for Python
  4. There's also https://github.com/MagicStack/asyncpg
    comment by leadingthenet · 2024-05-30 · in PyPy has been working for me for several years now
  5. ▲ 8
    Ask HN: Is Python async/await some kind of joke?
    story by nbrad · 2024-01-27 · 3 comments
  6. …asyncpg is not pure Python. asyncpg has these two C files and also uses Cython as far as I can see. https://github.com/MagicStack/asyncpg/blob/master/asyncpg/pr... https://github.com/MagicStack/asyncpg/blob/master/asyncpg/pr... If you are…
    comment by andrewstuart · 2023-10-10 · in Differences from Psycopg2
  7. ▲ 2
    Asyncpg – A Fast PostgreSQL Database Client Library for Python/Asyncio
    story by gjvc · 2023-09-29 · 0 comments
  8. This pure Python library claims quite fabulous performance: https://github.com/MagicStack/asyncpg I believe it because that team have done lots of great stuff but I haven't used it, I just remembered thinking it was interesting the…
    comment by danmur · 2023-09-09 · in JIT-optimized Ruby can outperform a C extension
  9. …uuid for prepared statements to avoid these name conflicts (asyncpg added this feature for us here: https://github.com/MagicStack/asyncpg/issues/837 ). however, they can just as well use DEALLOCATE ALL, set this as their…
    comment by zzzeek · 2023-09-08 · in PgBouncer is useful, important, and fraught with peril
  10. …too. I have a rough Python proof-of-concept, will need to find time to finish and publish it. [1] https://github.com/MagicStack/asyncpg/pull/295
    comment by RedCrowbar · 2021-07-10 · in EdgeDB: EdgeQL
  11. …[0] https://github.com/nackjicholson/aiosql [1] https://news.ycombinator.com/item?id=24130712 [2] https://github.com/MagicStack/asyncpg [3] https://pydantic-docs.helpmanual.io/ [4] https://fastapi.tiangolo.com/
    comment by polyrand · 2021-02-19 · in 12 requests per second: A realistic look at Python web frameworks
  12. …that is eventually run opaque. Not sure if there are equivalents to asyncpg for other RDBMS's. [0]: https://github.com/MagicStack/asyncpg
    comment by swagonomixxx · 2021-02-18 · in Migrating to SQLAlchemy 2.0
  13. …it much easier to use its advanced features) through raw SQL statements without problems. [1] https://github.com/MagicStack/asyncpg
    comment by takeda · 2020-08-15 · in Django Async: What's new and what's next?
  14. …/www.postgresql.org/docs/12/libpq-async.html https://www.psycopg.org/docs/advanced.html#green-support https://github.com/MagicStack/asyncpg
    comment by zzzeek · 2020-08-14 · in Django Async: What's new and what's next?
  15. …for the async database operations, even though asyncpg is (allegedly) a whole lot faster. 1. https://github.com/MagicStack/asyncpg
    comment by nik_s · 2020-06-12 · in Async Python is not faster
  16. …know what you're doing. If you want to explore types, these resources[2][3] were useful for me. [1] https://github.com/MagicStack/asyncpg [2] https://mypy.readthedocs.io/en/stable/ [3] https://docs.python.org/3/library/typing.htm
    comment by takeda · 2020-04-30 · in Rob Pike interview
  17. …and column names) and provide highlighting, removing all the advantages that ORM provided. [1] https://github.com/MagicStack/asyncpg
    comment by takeda · 2020-01-10 · in Httpx: A next-generation HTTP client for Python
  18. …ORM will be refactored to optionally support async and will supply an adaptor for asyncpg. 1. https://github.com/MagicStack/asyncpg 2. https://magicstack.github.io/asyncpg/current/
    comment by gonational · 2019-12-02 · in Django 3
  19. …how asyncpg can outperform[1] some libraries that you normally would think was not possible. [1] https://github.com/MagicStack/asyncpg
    comment by takeda · 2019-12-02 · in Django 3
  20. …mature enough. If so, I hope libraries like this and little_pger will switch to it or support it! https://github.com/MagicStack/asyncpg https://gitlab.com/pgjones/quart
    comment by benatkin · 2019-05-29 · in Show HN: PugSQL, a Python Port of HugSQL
  21. …a flask clone called Quart ( http://pgjones.gitlab.io/quart/ ) and an async postgres client ( https://github.com/MagicStack/asyncpg ). It works very similar to JavaScript, with async and await keywords. I think it should provide speed and…
    comment by benatkin · 2019-03-24 · in Why I Switched from Python to Clojure (2016)
  22. …`asyncpg`, which at least as they're presented do indicate a significant difference in throughput. https://github.com/MagicStack/asyncpg They're both incredibly experienced developers, and I don't have any good steer on the discrepancy.…
    comment by tomchristie · 2018-04-23 · in Show HN: HTTP/2 Python-Asyncio Web Microframework
  23. …I've become a fan... works well with asyncpg[2] too. [1]: https://github.com/channelcat/sanic [2]: https://github.com/MagicStack/asyncpg
    comment by mephitix · 2017-09-06 · in Show HN: Ice – WSGI microframework to develop small web applications in Python
  24. ▲ 2
    Asyncpg – A Fast PostgreSQL Database Client Library for Python/asyncio
    story by rbanffy · 2016-12-22 · 0 comments
  25. MagicStack has already taken the initiative. https://github.com/MagicStack/asyncpg
    comment by napperjabber · 2016-10-15 · in Sanic – Python 3.5+ web server that's written to go fast
  26. ▲ 3
    A fast PostgreSQL client library for Python: 3x faster than psycopg2
    story by arjun27 · 2016-09-25 · 1 comment
  27. …spent decoding rows (in [1]). The rest is spread over interpreter overhead, GC in particular. [1] https://github.com/MagicStack/asyncpg/blob/master/asyncpg/pr...
    comment by RedCrowbar · 2016-08-05 · in Show HN: 1M rows/s from Postgres to Python
  28. I meant a doc explaining roughly the components at https://github.com/MagicStack/asyncpg/tree/master/asyncpg/pr... and how they interact with each other at a high level as it doesn't seem to have comments. Thanks for the link though, I'll…
    comment by Keats · 2016-08-04 · in Show HN: 1M rows/s from Postgres to Python
  29. ▲ 2
    A Fast PostgreSQL Database Client Library for Python/asyncio
    story by mafro · 2016-07-19 · 1 comment