quart VS asyncpg

Compare quart vs asyncpg and see what are their differences.

quart

An async Python micro framework for building web applications. (by pgjones)
Scout Monitoring - Free Django app performance insights with Scout Monitoring
Get Scout setup in minutes, and let us sweat the small stuff. A couple lines in settings.py is all you need to start monitoring your apps. Sign up for our free tier today.
www.scoutapm.com
featured
InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
quart asyncpg
8 17
16 6,766
- 1.4%
0.0 5.9
over 1 year ago 7 days ago
Python Python
MIT License Apache License 2.0
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

quart

Posts with mentions or reviews of quart. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-07-01.
  • Python Flask has no remaining open issues or pull requests
    9 projects | news.ycombinator.com | 1 Jul 2022
  • Question about Synchronous web frameworks
    1 project | /r/learnpython | 6 Jun 2022
    Sorry. It's not Quartz, it's just Quart https://pgjones.gitlab.io/quart/
  • The problem with Flask async views and async globals
    4 projects | dev.to | 2 Aug 2021
    If you're looking for an experience that's very similar to Flask you can use Quart which is inspired by Flask. Quart even has a guide about how to migrate from a Flask application to using Quart! Flask's own documentation for async views actually recommends using Quart in some cases due to the performance hit from using a new event loop per request.
  • New Versions Released! Flask 2.0 with async
    2 projects | news.ycombinator.com | 12 May 2021
    Flask getting async support is a huge step for the asyncio web ecosystem in Python. I wonder how Flask's ASGI support will evolve in parallel with Quart[1] which bills itself as the ASGI version of Flask and is maintained by a member of the Pallets team. One of the maintainers of Werkzeug even recommended using Quart[2]

    [1] https://pgjones.gitlab.io/quart/

    [2] https://github.com/pallets/werkzeug/issues/1322#issuecomment...

  • New major versions of Flask, Jinja, Click, and Werkzeug released!
    9 projects | /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.
  • Create Asynchronous API in Python and Flask
    1 project | /r/flask | 5 May 2021
    For people looking to do async stuff with Flask, there is also Quart! It’s essentially an async port of Flask, with all your favorite, familiar methods!
  • asyncio: We Did It Wrong
    2 projects | /r/Python | 12 Mar 2021
    I agree with the transition issues, Quart has this awkward code to try and get around this.
  • Python developer survey reaction - 6 insights to make you a better dev
    1 project | /r/Python | 25 Feb 2021
    Appreciate the feedback! I forgot to pimp my favorite web framework, Quart, but I can attest to Flask and even Django being great. I always looked down on Django as too big but then I used it for my current company and I realized I was totally wrong. Easy to pick up, lots of functionality if you want it, but it doesn't force it on you.

asyncpg

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 2024-05-30.
  • Psycopg 3.2 released – PostgreSQL driver for Python
    1 project | news.ycombinator.com | 1 Jul 2024
    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.

  • PyPy has been working for me for several years now
    4 projects | news.ycombinator.com | 30 May 2024
  • Ask HN: Is Python async/await some kind of joke?
    4 projects | news.ycombinator.com | 27 Jan 2024
    - SqlAlchemy/asyncpg => you can’t use it if you’re using PgBouncer (necessary most of the time with Postgres) in transaction mode? What?? https://github.com/MagicStack/asyncpg/issues/1058
  • Differences from Psycopg2
    1 project | news.ycombinator.com | 10 Oct 2023
    OK I stand corrected, asyncpg has these two C files:

    https://github.com/MagicStack/asyncpg/blob/master/asyncpg/pr...

    https://github.com/MagicStack/asyncpg/blob/master/asyncpg/pr...

    If you are interested here is a post by the psycopg author about psycopg2 and 3 and performance versus asyncpg.

    https://www.varrazzo.com/blog/2020/05/19/a-trip-into-optimis...

  • Asyncpg – A Fast PostgreSQL Database Client Library for Python/Asyncio
    1 project | news.ycombinator.com | 29 Sep 2023
  • Ruby Outperforms C: Breaking the Catch-22
    4 projects | news.ycombinator.com | 9 Sep 2023
    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 performance was so good. Not sure how related it is to running on the asyncio loop (or which loop they used for benchmarks).

  • PgBouncer is useful, important, and fraught with peril
    2 projects | news.ycombinator.com | 8 Sep 2023
    what a great post, we have had a ton of issues with users using pgbouncer and it's not because things are "broken" per se, it's just the situation is very complicated, and pgbouncer's docs are also IMO in need of updating to be more detailed and in a few critical cases less misleading, specifically the prepared statements docs.

    This blog post refers to this misleading nature at https://jpcamara.com/2023/04/12/pgbouncer-is-useful.html#pre... .

    > PgBouncer says it doesn’t support prepared statements in either PREPARE or protocol-level format. What it actually doesn’t support are named prepared statements in any form.

    That's also not really accurate. You can use a named prepared statement just fine in transaction mode. start a transaction (so you aren't in autocommit), use a named statement, works fine. you just can't use it again in another transaction, because it will be "gone" (more accurately, "unmoored" - might be in your session, might be in someone else's session). Making things worse, when the prepared statement is "unmoored", its name can then conflict with another client attempting to use the same name.

    so to use named prepared statements, you can less ideally name them with random strings to avoid conflicts, or you can DEALLOCATE the prepared statement(s) you used at the end of your transaction. for our users that use asyncpg, we have them use a 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 `server_reset_query`, and then so that happens in transaction mode, also set `server_reset_query_always`, so that it's called at the end of transactions. Where pgbouncer here IMO entirely misleadingly documents this as "This setting is for working around broken setups that run applications that use session features over a transaction-pooled PgBouncer." - which is why nobody uses it, because pgbouncer claims this is "broken". It's not any more broken than it is to switch out the PostgreSQL session underneath a connection that uses multiple transactions. Pgbouncer can do better here and make this clearer and more accommodating of real world database drivers.

  • Library to connect Python to Postgresql
    1 project | /r/learnpython | 4 May 2023
    asyncpg is another great driver if you're using asyncio and want maximum performance (although they also break with DBAPI, but the tradeoff may be worth it).
  • aiopg vs asyncpg vs psycopg3
    3 projects | /r/learnpython | 28 Jun 2022
    asyncpg: 5.5k starts, last commit recently, ~150 issues, some incompatibility, few open PRs, extensive README. Includes benchmark showing it's supposedly 3x faster than aiopg and psycopg2, psycopg3 is not mentioned in the benchmark.
  • Announcing Quart-DB
    3 projects | /r/Python | 12 Apr 2022
    Quart-DB uses asyncpg to manage the connections and buildpg to parse the named parameter bindings.

What are some alternatives?

When comparing quart and asyncpg you can also consider the following projects:

Flask - The Python micro framework for building web applications.

psycopg2 - PostgreSQL database adapter for the Python programming language

fastapi - FastAPI framework, high performance, easy to learn, fast to code, ready for production

aiopg - aiopg is a library for accessing a PostgreSQL database from the asyncio

starlette - The little ASGI framework that shines. 🌟

pymssql - Official home for the pymssql source code.

flask-pydantic - flask extension for integration with the awesome pydantic package

awesome-mysql - A curated list of awesome MySQL software, libraries, tools and resources

uvicorn - An ASGI web server, for Python. 🦄

pgbouncer - lightweight connection pooler for PostgreSQL

httpx - A next generation HTTP client for Python. 🦋

psycopg - New generation PostgreSQL database adapter for the Python programming language

Scout Monitoring - Free Django app performance insights with Scout Monitoring
Get Scout setup in minutes, and let us sweat the small stuff. A couple lines in settings.py is all you need to start monitoring your apps. Sign up for our free tier today.
www.scoutapm.com
featured
InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured