python asyncio, how to prevent the other functions "block" themselves when connecting to db?

This page summarizes the projects mentioned and recommended in the original post on /r/learnpython

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
  • aiomysql

    aiomysql is a library for accessing a MySQL database from the asyncio

  • Well you'll need to make the db connection async as well, using an async db library. The FastAPI docs mention encode/databases, which is a wrapper over SQLAlchemy; if you don't need the ORM then go straight to the underlying db driver which is aiomysql.

  • databases

    Async database support for Python. 🗄

  • No, as I said, async db connection is the key. You can do that with SQLAlchemy using the databases library, but since you are not using SQLAlchemy it makes more sense to use the underlying db driver, aiomysql, directly.

  • 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.

    Scout Monitoring logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Django 4.1 alpha 1 released

    1 project | /r/django | 18 May 2022
  • Best approach for async SQLAlchemy in FastAPI

    1 project | /r/FastAPI | 4 Sep 2021
  • async sqlalchemy question db question

    1 project | /r/FastAPI | 8 Aug 2021
  • What's the point of asyncio if an event loop blocks on IO?

    1 project | /r/learnpython | 9 May 2021
  • เล่นกับ Data type UI & API

    2 projects | dev.to | 22 Nov 2020