Add databases support with using async SQLAlchemy

[fastapi-mvc]

Add databases support with using async SQLAlchemy

[rszamszur]

@jeanlst To be honest, I've initially chosen SQLModel since it combines pydantic and SQLAlchemy which is exactly what I wanted to do. Also since tiangolo has a lot of followers I assumed this project will gain a decent amount of contributors quickly, So I would end up implementing the same solution but heavily outnumbered 😆. Lastly, I guess I wanted to go the easy way.

However, you're right in terms of maturity and release frequency. Also from what I've seen async session is not fully implemented, so no performance advantage (yet). Async SQLAlchemy it is then :) Thanks for the input!

Have a good one!

[jeanlst]

Nice! I'm keeping tabs on the project and you have been doing a great job so far! I'm still getting into all this stuff so I haven't been that helpful yet, bot hopefully in the future!

[rszamszur]

@jeanlst just wanted to let you know, that this feature is next in line to implement. I don't know the ETA since there is some degree of unknown regarding how this will be implemented exactly. But this and few other issues combined will be a whole deal:

• Databases support (this particular issue)
• Generating models and migrations
• Generate whole resource scaffold (meaning controller + model + migrations + tests)
• Depending on chosen DB engine, add database HA cluster deployment in K8s (similar to Redis in make dev-env) but also I want to create another script for just deploying application stack in Kubernetes. It'll be probably a generator as well. I guess something like fastapi-mvc generate k8s-deployment [OPTIONS] [ARGS] in which you can choose what to include.

In the meantime controller and generator generators feature is already available with 0.11.0 release. It's not fully documented, but documentation itself got an upgrade too, and there is a basic howto on controller generator. Any feedback is always welcome :)

[jeanlst]

@rszamszur why not use async sqlalchemy? SQLModel seems pretty good so we but I feel it's not really that mature yet and the releases are taking a lot of time. Also SQLAlchemy is kinda of a staple I feel like