Asyncpg Alternatives

Similar projects and alternatives to asyncpg

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better asyncpg alternative or higher similarity.

Suggest an alternative to asyncpg

Reviews and mentions

Posts with mentions or reviews of asyncpg. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2021-11-13.
  • Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service
    7 projects | dev.to | 13 Nov 2021
    Simple query runs long when DB schema contains thousands of tables #186
  • Large database to python - SQL advantageous? (mysql)
    2 projects | reddit.com/r/Python | 4 Oct 2021
    Highly recommend https://github.com/MagicStack/asyncpg.
  • Postgrey - Simple, Fast & Async Library for PostgreSQL
    2 projects | dev.to | 29 Jun 2021
    🐘 Simple, Fast, Async & ORM PostgreSQL database client based on Asyncpg for Python.
  • New major versions of Flask, Jinja, Click, and Werkzeug released!
    9 projects | reddit.com/r/Python | 11 May 2021
    What we get with the async part of this release - If you would like to run an async library or your own async code from a flask route you can do that now. This is super useful, where let's say we have some async code that fetches data from many sources concurrently, or call multiple a few ML prediction endpoints at the same time (as long as they don't time out) using httpx and respond with some sort of outcome, or finally try that cool new async-only database library. A current (v2) limitation is that the you can't make concurrent requests using just the current asyncio implementation (an alternative with Flask API and ASGI: Quart). Typically in production gunicorn or uwsgi + threads/processes/gevent-eventlet is used and this makes Flask behave asynchronously. More here and here if interested.
  • Migrating to SQLAlchemy 2.0
    3 projects | news.ycombinator.com | 18 Feb 2021
    Agreed. I will never recommend an ORM, things simply spiraled out of control for medium to large-ish projects that had more than 2 developers. Even with "best practices", code ended up having a mix of raw SQL and ORM-style queries, and it was hard to reason about the code.

    Since switching to asyncpg [0] these problems have vanished. It commands a deeper knowledge of actual SQL, but I would argue this knowledge is absolutely necessary and one of the disadvantages of an ORM is that it makes the SQL that is eventually run opaque.

    Not sure if there are equivalents to asyncpg for other RDBMS's.

    [0]: https://github.com/MagicStack/asyncpg

  • Piccolo, an async query builder and ORM for Python
    4 projects | dev.to | 10 Jan 2021
    Asyncio makes a lot of sense when you want high throughput applications. Piccolo is built on top of asyncio and a fast database adapter called asyncpg. You can also use Piccolo within a traditional synchronous app too.

Stats

Basic asyncpg repo stats
6
5,251
7.5
5 days ago

MagicStack/asyncpg is an open source project licensed under Apache License 2.0 which is an OSI approved license.

Deliver Cleaner and Safer Code - Right in Your IDE of Choice!
SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.
www.sonarlint.org
Find remote Python jobs at our new job board 99remotejobs.com. There are 7 new remote jobs listed recently.
Are you hiring? Post a new remote job listing for free.