5 ms·
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 fo
by hultner 8y ago
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.
- bpicolo 8y agoGive peewee-async as shot if you'd like async DB access as well. https://peewee-async.readthedocs.io/en/latest/ 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 https://github.com/fantix/gino
- hultner 8y agoWhile 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+.
- bpicolo 8y agoFor 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 https://github.com/RazerM/sqlalchemy_aio) but for the full ORM there's no option, as far as I know.