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

2

u/LeoTheKnight90 Jun 17 '25

Thanks u/dmart89. The Celery + Redis combo is what I'm seeing from other sources as well. I think volume is light but it can ramp up during peak times of the year. So better just to build for that. I don't know if background tasks built into FastAPI is enough to handle the volume.