{"library":"sqlmodel","type":"library","category":null,"description":"SQLModel is a Python library that unifies SQLAlchemy's ORM capabilities with Pydantic's data validation, simplifying interaction with SQL databases. It aims to reduce code duplication by using a single class definition for both database models and data schemas. SQLModel is currently in version 0.0.38 and maintains an active development cadence with frequent releases, often including bug fixes, dependency updates, and sometimes breaking changes.","language":"python","status":"active","version":"0.0.38","tags":["orm","sqlalchemy","pydantic","fastapi","database","sql","async"],"install":[{"cmd":"pip install sqlmodel","imports":["from sqlmodel import SQLModel","from sqlmodel import Field","from sqlmodel import Session","from sqlmodel import create_engine","from sqlmodel import select","from sqlalchemy.ext.asyncio import create_async_engine","from sqlalchemy.ext.asyncio import AsyncSession"]},{"cmd":"pip install sqlmodel[asyncpg]","imports":[]},{"cmd":"pip install sqlmodel[aiosqlite]","imports":[]}],"homepage":"https://sqlmodel.tiangolo.com","github":"https://github.com/fastapi/sqlmodel","docs":"https://sqlmodel.tiangolo.com","changelog":"https://sqlmodel.tiangolo.com/release-notes/","pypi":"https://pypi.org/project/sqlmodel/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":4.8,"avg_import_s":1.16,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/sqlmodel/compatibility"},"provenance":{"verified_status":"passing","verified_at":"Sun Jun 28","last_verified":"Sun Jun 28","next_check":"Tue Jul 28","install_tag":"verified"}}