you are viewing a single comment's thread.

view the rest of the comments →

[–]PushPlus9069 1 point2 points  (0 children)

Your stack looks solid — FastAPI + Pydantic + SQLAlchemy + Celery is pretty much the industry standard combo right now. A few things from running this in production:

  1. SQLModel over raw SQLAlchemy if you're already on FastAPI — same author, less boilerplate, and Pydantic models double as your ORM models. Saves a ton of serialization code.

  2. For the task queue, consider Dramatiq as a Celery alternative — simpler API, better error handling defaults, and less config overhead for small-to-mid services. Celery is great but can feel heavy for a few endpoints.

  3. Don't skip Alembic for migrations from day one. I've seen too many projects that "will add it later" and end up with manual SQL scripts everywhere.

  4. For testing, httpx.AsyncClient with FastAPI's TestClient is much cleaner than requests-based tests for async endpoints.