Asyncpg Alternatives
Similar projects and alternatives to asyncpg
-
-
-
Scout APM
Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.
-
mysql-python
MySQLdb is a Python DB API-2.0 compliant library to interact with MySQL 3.23-5.1 (unofficial mirror)
-
awesome-mysql
A curated list of awesome MySQL software, libraries, tools and resources
-
-
PyPika
PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
-
-
OPS
OPS - Build and Run Open Source Unikernels. Quickly and easily build and deploy open source unikernels in tens of seconds. Deploy in any language to any cloud.
-
-
-
-
sqlitebrowser
Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
-
llvm-project
The LLVM Project is a collection of modular and reusable compiler and toolchain technologies. Note: the repository does not accept github pull requests at this moment. Please submit your patches at http://reviews.llvm.org.
-
-
-
-
-
-
flask-smorest
DB agnostic framework to build auto-documented REST APIs with Flask and marshmallow
-
coronavirus-dashboard
Dashboard for tracking Coronavirus (COVID-19) across the UK
-
flask-rebar
Flask-Rebar combines flask, marshmallow, and swagger for robust REST services.
Reviews and mentions
-
Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service
Simple query runs long when DB schema contains thousands of tables #186
-
Large database to python - SQL advantageous? (mysql)
Highly recommend https://github.com/MagicStack/asyncpg.
-
Postgrey - Simple, Fast & Async Library for PostgreSQL
🐘 Simple, Fast, Async & ORM PostgreSQL database client based on Asyncpg for Python.
-
New major versions of Flask, Jinja, Click, and Werkzeug released!
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
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.
-
Piccolo, an async query builder and ORM for Python
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
MagicStack/asyncpg is an open source project licensed under Apache License 2.0 which is an OSI approved license.
Popular Comparisons
Are you hiring? Post a new remote job listing for free.