undefined | Better HN

0 pointshultner7y ago0 comments

I’ve looked at quart and it looks interesting but is there much point to running an async webserver for APIs mainly reliant on db-access if we use SQLAlchemy for database connections?

I’m under the impression that since the db stuff still is sync/blocking we won’t win much by running an asgi server instead of WSGI.

0 comments

3 comments · 1 top-level

bpicolo7y ago· 2 in thread

Give peewee-async as shot if you'd like async DB access as well.

https://peewee-async.readthedocs.io/en/latest/

Looks like Gino is a new project trying to bake asyncio ORM on top of sqlalchemy core: https://github.com/fantix/gino

hultnerOP7y ago

While interesting for greenfield development and experiments I'd say that it's most often a to big of a leap to change both ORM (with all db-access-code) and microframework at the same time for a well established project at 20KLOC+.

bpicolo7y ago

For sure, definitely not a good path for an existing app :) You can use the sqlalchemy-core via async via a few projects (https://github.com/RazerM/sqlalchemy_aio) but for the full ORM there's no option, as far as I know.

j / k navigate · click thread line to collapse