Add databases support with using async SQLAlchemy

[rszamszur]

• I have searched the issues of this repo and believe that this is not a duplicate.

Feature Request

Draft implementation plan:

Core:

• [Databases support] Implement declarative base Model class #183
• [Databases support] Add support for database migrations. #182
• [Databases support] Implement database configuration file #181
• [Databases support] Implement Session class responsible for managing SQLAlchemy session #180

Generators:

• [Databases support] Implement scaffold generator #79
• [Databases support] Implement model generator #45
• migrations generator?

Extra:

• [Databases support] Implement database seed feature #110

Documentation:

• [Databases support] Add database feature documentation #112

This still needs more research and clarification. Some implementation concepts might change during the development of this feature.

[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

[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 :)