I’m stacking a few days in some developing issue.
The environment is a docker image that deploys on eks cluster
The docker image is ‘python3.10-slim.
I tried to develop a connector class which responsible for making async communication between FastAPI(Uvicorn ASGI based on) and mssql.
I tried to use pymssql+aiodbc, it works fine, but in the first load, the app is stuck and holds the connection with the db and prevents the client from accessing to app (the same API that open sesaion vs the db).
I solved that issue by increasing the number of pods but I want to make a better solution.
It would be great if some hero could share with me initial template which implements an async connector with mssql and some examples (1-2 entry points).
To using aiodbc+pymssql with async engine.
Idantok is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.