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. …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
  6. 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
  7. …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
  8. …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
  9. …[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
  10. …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
  11. …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?
  12. …/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?
  13. …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
  14. …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
  15. …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
  16. …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
  17. …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
  18. …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
  19. …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)
  20. …`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
  21. …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
  22. 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
  23. …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
  24. 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