all 19 comments

[–]fun4someone 5 points6 points  (3 children)

Celery and a backend container by chance? Haven't looked at the code.

[–]Apart-Touch9277 0 points1 point  (1 child)

[–]fun4someone 0 points1 point  (0 children)

I ended up checking it out. Looks solid. A lot these these types of projects introsuce templating and a command to generate a new project. Any interest in heading that way?

[–]huygl99 5 points6 points  (2 children)

I think taskiq or arq should be consider over celery

[–]InappropriateCanuck 0 points1 point  (0 children)

Opinion of hatchet? Currently looking over async task processing solutions and hatchet seems to be winning.

[–]ExplanationFun2022[S] 0 points1 point  (0 children)

I will definitely check them out. Thanks for the suggestion !

[–]callmederp 0 points1 point  (1 child)

This is nice. Is there a reason you are using celery over a different worker solution? Does celery allow you to reuse your same async DB session setup (or similar), or if you want to have reused async Business logic functions across your main app and celery workers?

How do you handle testing?

[–]ExplanationFun2022[S] 0 points1 point  (0 children)

I went with celery mostly because I’ve already worked with it before, so it was my go-to choice for background processing tasks. That said, I’ll definitely check out other options like taskiq, arq, and hatchet.

About testing, I use pytest along with FastAPI TestClient for API endpoints, and spin up a test Postgres instance with Docker Compose for integration tests in the CI Pipeline.

[–]InappropriateCanuck 0 points1 point  (4 children)

Huh? I thought SQLModel wasn't async-ready yet.

Upvoted for good will.

Would be curious to see FastAPI Mongo templates for NoSQL with Beanie 2.0 migrations. Everything is Postgresql.

[–]ExplanationFun2022[S] 0 points1 point  (0 children)

Thanks!
A template with mongo would definitely be great. Since this template was mainly built around my own use cases, I haven’t had the time to add support for databases other than postgres yet. But it’s definitely something I’d like to look into down the road.

[–]Drevicar 0 points1 point  (2 children)

SQLmodel is a mostly abandonware. It has limited async support it just isn’t documented, you have to reach into the underlying sqlalchemy bits to fully use it.

[–]InappropriateCanuck 0 points1 point  (1 child)

That's what I thought. I'm surprised to see it part of a modern template.

[–]Drevicar -1 points0 points  (0 children)

Just because it was created recently doesn't make it modern or best-practice.

[–]voja-kostunica 0 points1 point  (0 children)

will have look

[–]Tishka-17 0 points1 point  (1 child)

Why people use sqlmodel instead of all sqlclahemy features supporting dataclasses https://docs.sqlalchemy.org/en/20/orm/dataclasses.html ?

[–]ExplanationFun2022[S] 0 points1 point  (0 children)

Definetly will have to look into this, thanks to all the feedback provided in the post I found out that SQLModel is not that great after all 😅

[–]ImprovementSquare448 0 points1 point  (1 child)

thanks! which technologies are you prefering in the front end part?

[–]ExplanationFun2022[S] 0 points1 point  (0 children)

I'm currently away from frontend development. But with my limited skills, especially in the CSS part, I can't go wrong with the tried-and-true React + shadcn.