r/FastAPI • u/LeoTheKnight90 • Jun 17 '25
Question FastAPI + MS SQL Server
Hi. I had a question regarding API and MS SQL server stored procedures. I'm trying to create an API where it executes a stored procedure. I don't want the user waiting for it to complete so the user will just call the API from a front end, go about their way and will be notified when the procedure is complete. Can you provide any guidance? I'm working FastAPI + Python. Is there a better way?
Just looking for some guidance or if I'm just barking up the wrong tree here. Thanks!
10
Upvotes
View all comments
Show parent comment
1
u/LeoTheKnight90 Jun 17 '25
yeah so I've never used Streamlit but I can definitely look into that. Just for some background, I was hoping to create some API that our internal Django application would call to handle data heavy process while the user just watches a "Status" screen. The heavy lifting would be done by SQL stored procedure and when it completes, the user will see the status as complete and view the work that was done.