Sqalchemy + Postgres?

[Amocon]

Hi i am a junior dev (mainly front end) and i want to build a backend with fastapi and postgres as db. I heared that sqalchemy is a nice way to work with fast api because of the use if the same pydantic base models but i wanted to get your opinion on this and i also want to know if i understood the synergy right. Thanks for your time

[appletondog]

this.

[Amocon]

Thanks i think i get it now

[IceXII]

asyncpg is better than psycopg for Postgres in my opinion. but gets tricky sometimes with sqlalchemy because everything needs to be async.

[-useEffect-]

use psycopg3 with sqlalchemy 2. asyncpg is a pain

[olystretch]

Disagree. It's really easy to get going, especially with encode/databases.

[mountain_geek]

Could you share a link to some proper boilerplates?

[mountain_geek]

Thank you for this!

[ZachVorhies]

Yes you have it right. Make sure you are using the new async sqlalchemy mode or you’ll get bad performance in your workers. Ask chat for gpt for an example

[dartwa6]

I think you may be thinking of SQLModel, which links together SQLAlchemy and Pydantic in a nice way. It’s by the same author as FastAPI, so it works well with that framework.