sqlmodel 0.0.34

SQLModel, SQL databases in Python, designed for simplicity, compatibility, and robustness.

Stars: 17644, Watchers: 17644, Forks: 804, Open Issues: 115

The fastapi/sqlmodel repo was created 4 years ago and the last code push was Yesterday.
The project is extremely popular with a mindblowing 17644 github stars!

How to Install sqlmodel

You can install sqlmodel using pip

pip install sqlmodel

or add it to a project with poetry

poetry add sqlmodel

Package Details

Author

None

License

None

Homepage

None

PyPi:

https://pypi.org/project/sqlmodel/

Documentation:

https://sqlmodel.tiangolo.com

GitHub Repo:

https://github.com/tiangolo/sqlmodel

Classifiers

• Database
• Database/Database Engines/Servers
• Internet
• Internet/WWW/HTTP
• Internet/WWW/HTTP/HTTP Servers

Related Packages

Errors

A list of common sqlmodel errors.

Code Examples

Here are some sqlmodel code examples and snippets.

GitHub Issues

The sqlmodel package has 115 open issues on GitHub

• 📝 Rename Weapon.hero field to Weapon.owner in code example to better reflect meaning
• 📝 Use FastAPI lifespan instead of startup event
• 📝 Fix ambiguous phrasing regarding HeroPublicWithTeam model
• ✨ Add overload for exec method to support text statement
• 📝 Fix async example in session.execute() docstring & deprecation message
• 📝 Fix small typos in the documentation
• 🐛 Fix tuple_ return type annotation
• SQLModel fails to create DB constraints when using Annotated types after Pydantic 2.12.0
• 🐛 Fix support for Annotated fields with Pydantic 2.12+ (alternative)
• 🐛 Fix support for Annotated fields with Pydantic 2.12+
• ✨ Automatically map dictionaries to JSON
• ✨ Add support for Literal types
• 🏷️ Adjust type annotation for Field.sa_type to support instantiated SQLAlchemy types
• ✨ Add IntEnum type that allows storing values of enum as integers in database
• ✨ Add field-level db comments when a field description exists

See more issues on GitHub