Version not match (0.8.0) depends on sqlalchemy (>=1.4.42,<1.5)

[beebeewijaya-tech]

[tool.poetry]
name = "fastapi-learn"
version = "0.1.0"
description = ""
authors = ["Bee Bee Wijaya <[email protected]>"]
readme = "README.md"

[tool.poetry.dependencies]
python = "^3.9"
fastapi = "^0.109.0"
uvicorn = "^0.25.0"
alembic = "^1.13.1"
sqlalchemy = "^2.0.25"
python-decouple = "^3.8"
asyncpg = "^0.29.0"
psycopg2-binary = "^2.9.9"


[build-system]
requires = ["poetry-core"]
build-backend = "poetry.core.masonry.api"

Hi everyone, I encountered this issue, that it's can't be installed when the sqlalchemy version is 2.0.25

Because no versions of databases match >0.8.0,<0.9.0
 and databases (0.8.0) depends on sqlalchemy (>=1.4.42,<1.5), databases (>=0.8.0,<0.9.0) requires sqlalchemy (>=1.4.42,<1.5).
So, because fastapi-learn depends on both sqlalchemy (^2.0.25) and databases (^0.8.0), version solving failed.

Any ideas?

[leohowell]

You have to downgrade your dependency in tool.poetry.dependencies, sqlalchemy = "^2.0.25" to sqlalchemy = "^1.4.42"

[zanieb]

See #530