#asyncpg

[ follow ]
#fastapi #postgresql #asyncio #connection-pooling #sqlmodel #sqlalchemy
fromhttps://daniel.feldroy.com
2 days ago

Using Asyncpg with FastAPI and Air

Asyncpg is the connector for PostgreSQL and asyncio-flavored Python. Here's how to use it without other libraries on FastAPI and Air projects. Recently I've been on a few projects using PostgreSQL where SQLAlchemy and SQLModel felt like overkill. Instead of using those libraries I leaned on writing SQL queries and running those directly in [asyncpg](https://pypi.org/project/asyncpg/) instead of using an ORM powered by asyncpg. Here's how I got it to work
Python
Web frameworks
fromhttps://daniel.feldroy.com
1 month ago

TIL: Using SQLModel Asynchronously with FastAPI (and Air) with PostgreSQL

Use SQLModel with both asyncpg and psycopg2-binary, plus greenlet, to enable asynchronous and synchronous PostgreSQL operations in FastAPI applications.
[ Load more ]