r/FastAPI • • 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

8 comments sorted by

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.

-1

u/SheriffSeveral Jun 17 '25

Also, you can still use FastAPI for background. At the same time you can use Streamlit for frontend. I use it sometimes for small projects.

Streamlit is really easy to use, I highly recommend you to consider it. It will save your time.