Repository navigation
Please support latest SQLAlchemy or pin it #2996
Description
Hi @tiangolo, fastapi tests are currently failing and therefore causing pydantic tests to fail.
See pydantic/pydantic#2584, fastapi is not compatible with the v1.4 of SQLAlchemy which was released earlier in March, I've had to pin to SQLAlchemy==1.3.23
Please could we fix fastapi (the incompatibility looks like it might be trivial) or pin the dependency?
Once master of fastapi is fixed, we'll need to remember to also remove the hack from pydantic.
Activity
Kludex commentedon Mar 26, 2021
@samuelcolvin This comes from
encode/databases. @PrettyWood created a PR there: encode/databases#299If this is not solved, @tiangolo will probably fix this in the next weeks.
PrettyWood commentedon Mar 26, 2021
https://github.com/encode/databases/releases/tag/0.4.3 is out! @samuelcolvin No need for your fix anymore!
gjask commentedon Apr 12, 2021
Also it seems to me, that SQLAlchemy 1.4 has started to support async for its ORM. It would be great to have it available in fastapi.
https://docs.sqlalchemy.org/en/14/orm/extensions/asyncio.html#synopsis-orm
rinckd commentedon Jun 26, 2021
Michael Kennedy goes over async SQLAlchemy with FastAPI in one of his latest courses: https://github.com/talkpython/web-applications-with-fastapi-course/tree/main/code/ch8-async-databases
It's definitely interesting to play around with, but the SQLAlchemy asyncio extension is still considered beta software until the 2.0 release.
