Repository navigation
Async, upsert get_or_create, helpers #94
Description
First Check
- I added a very descriptive title to this issue.
- I used the GitHub search to find a similar issue and didn't find it.
- I searched the SQLModel documentation, with the integrated search.
- I already searched in Google "How to X in SQLModel" and didn't find any information.
- I already read and followed all the tutorial in the docs and didn't find an answer.
- I already checked if it is not related to SQLModel but to Pydantic.
- I already checked if it is not related to SQLModel but to SQLAlchemy.
Commit to Help
- I commit to help with one of those options 👆
Example Code
# generic question, no code sample.Description
I understand this is still a very very very new project, and that the current documentation is not as well vetted as FastAPI is. So if the following exists, maybe someone can point me to documentation or example and maybe I can help write it up.
- It is not clear if
sqlmodelis async aware or how to use it if it is. - How is sqlmodel different than say ORMAR which is async aware and uses a single shared pydantic model?
- It appears that common helper functions of other ORMs such as
upsertandget_or_createare absent fromsqlmodel, is there a plan to add native support for these options?
Operating System
Linux, macOS
Operating System Details
No response
SQLModel Version
0.0.4
Python Version
3.9.5
Additional Context
No response
Activity
perfecto25 commentedon Jan 12, 2022
I was able to run in async using this tutorial
https://testdriven.io/blog/fastapi-sqlmodel/
perfecto25 commentedon Jan 12, 2022
this repo shows a good way to create an async session
https://github.com/Cedric-Magnan/fastapi-async-sqlmodel/blob/main/app.py
Ensure tags do not duplicate in db
iloveitaly commentedon Apr 9, 2026
👋 I was looking for the exact same helpers, so I built them into a wrapper library! It adds
find_or_create_by(),upsert(), and other rails-like features. It also includes an ORM-like DX, lifecycle hooks, easy session management, and JSONB mutation tracking. Check it out! Would love to hear any feedback and have more contributions to it.