this post was submitted on 31 Dec 2025
18 points (87.5% liked)

Python

7688 readers
1 users here now

Welcome to the Python community on the programming.dev Lemmy instance!

📅 Events

PastNovember 2023

October 2023

July 2023

August 2023

September 2023

🐍 Python project:
💓 Python Community:
✨ Python Ecosystem:
🌌 Fediverse
Communities
Projects
Feeds

founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] sherbang@chaos.social 1 points 3 weeks ago (2 children)

@hackeryarn It's not clear from this writeup how SQLAlchemy is set up. If you're using a sync postgres driver then you're doing async-to-sync in your code and not testing what you think you're testing.

A test of different async SQLAlchemy configurations would be helpful next to this. Including testing that the SQLAlchemy setup is async all the way through.

[–] logging_strict@programming.dev 2 points 3 weeks ago

I live and breathe this stuff

SQLAlchemy AsyncSession calls greenlet_spawn which wraps a Session sync method. For async dialect+driver, the sqlalchemy dbapi driver will make async connections.

Hey lets make an async call. You mean rewrite the exact code except with dispersed await sprinkled about? Fuck that! Once is enough. Instead wrap the sync call in a greenlet_spawn. And then return to the gulag of static type checking hell forever.

So is it async all the way thru? No. It's async enough™

[–] hackeryarn@lemmy.world 2 points 3 weeks ago

It is using the async driver. I am using FastAPI’s thin wrapper around SQLAlchemy which also does some slight tuning for it to work better with FastAPI in an async mode.