0.0.22

Fixes

• 🐛 Fix support for types with Optional[Annoated[x, f()]], e.g. id: Optional[pydantic.UUID4]. PR #1093 by @tiangolo.

Docs

• ✏️ Fix a typo in docs/virtual-environments.md. PR #1085 by @tiangolo.
• 📝 Add docs for virtual environments and environment variables, update contributing. PR #1082 by @tiangolo.
• 📝 Add docs about repo management and team. PR #1059 by @tiangolo.
• ✏️ Fix typo in cascade_delete docs. PR #1030 by @tiangolo.

Internal

• ✅ Refactor test_enums to make them independent of previous imports. PR #1095 by @tiangolo.
• 👷 Update latest-changes GitHub Action. PR #1087 by @tiangolo.
• ⬆ [pre-commit.ci] pre-commit autoupdate. PR #1028 by @pre-commit-ci[bot].
• ⬆ Bump ruff from 0.4.7 to 0.6.2. PR #1081 by @dependabot[bot].
• 🔧 Update lint script. PR #1084 by @tiangolo.
• 👷 Update Python version for coverage. PR #1083 by @tiangolo.
• 🔧 Update coverage config files. PR #1077 by @tiangolo.
• 🔧 Add URLs to pyproject.toml, show up in PyPI. PR #1074 by @tiangolo.
• 👷 Do not sync labels as it overrides manually added labels. PR #1073 by @tiangolo.
• 👷 Update configs for GitHub Action labeler, to add only one label. PR #1072 by @tiangolo.
• 👷 Update labeler GitHub Actions permissions and dependencies. PR #1071 by @tiangolo.
• 👷 Add GitHub Action label-checker. PR #1069 by @tiangolo.
• 👷 Add GitHub Action labeler. PR #1068 by @tiangolo.
• 👷 Update GitHub Action add-to-project. PR #1067 by @tiangolo.
• 👷 Add GitHub Action add-to-project. PR #1066 by @tiangolo.
• 📝 Update admonitions in annotations. PR #1065 by @tiangolo.
• 📝 Update links from github.com/tiangolo/sqlmodel to github.com/fastapi/sqlmodel. PR #1064 by @tiangolo.
• 🔧 Update members. PR #1063 by @tiangolo.
• 💄 Add dark-mode logo. PR #1061 by @tiangolo.
• 🔨 Update docs.py script to enable dirty reload conditionally. PR #1060 by @tiangolo.
• 🔧 Update MkDocs previews. PR #1058 by @tiangolo.
• 💄 Update Termynal line-height. PR #1057 by @tiangolo.
• 👷 Upgrade build docs configs. PR #1047 by @tiangolo.
• 👷 Add alls-green for test-redistribute. PR #1055 by @tiangolo.
• 👷 Update docs-previews to handle no docs changes. PR #1056 by @tiangolo.
• 👷🏻 Show docs deployment status and preview URLs in comment. PR #1054 by @tiangolo.
• 🔧 Enable auto dark mode. PR #1046 by @tiangolo.
• 👷 Update issue-manager. PR #1045 by @tiangolo.
• 👷 Update issue-manager.yml GitHub Action permissions. PR #1040 by @tiangolo.
• ♻️ Refactor Deploy Docs GitHub Action to be a script and update token preparing for org. PR #1039 by @tiangolo.

0.0.21

Features

• ✨ Add support for cascade delete relationships: cascade_delete, ondelete, and passive_deletes. Initial PR #983 by @estebanx64.
  • New docs at: Cascade Delete Relationships.

Docs

• 📝 Update docs . PR #1003 by @alejsdev.

Internal

• ⬆ Bump actions/cache from 3 to 4. PR #783 by @dependabot[bot].
• ⬆ Bump cairosvg from 2.7.0 to 2.7.1. PR #919 by @dependabot[bot].
• ⬆ Bump jinja2 from 3.1.3 to 3.1.4. PR #974 by @dependabot[bot].
• ⬆ Bump pypa/gh-action-pypi-publish from 1.8.11 to 1.9.0. PR #987 by @dependabot[bot].
• ⬆ Bump mkdocstrings[python] from 0.23.0 to 0.25.1. PR #927 by @dependabot[bot].
• ⬆ Bump dorny/paths-filter from 2 to 3. PR #972 by @dependabot[bot].

0.0.20

Features

• ✨ Add official UUID support, docs and tests, internally using new SQLAlchemy 2.0 types. Initial PR #992 by @estebanx64.
  • New docs in the Advanced User Guide: UUID (Universally Unique Identifiers).

Docs

• ✏️ Fix internal link in docs/tutorial/create-db-and-table.md. PR #911 by @tfpgh.
• ✏️ Add missing step in create-db-and-table-with-db-browser.md. PR #976 by @alejsdev.
• ✏️ Fix typo in docs/tutorial. PR #943 by @luco17.
• ✏️ Fix typo in sqlmodel/_compat.py. PR #950 by @Highfire1.
• ✏️ Update pip installation command in tutorial. PR #975 by @alejsdev.
• ✏️ Fix typo in docs/tutorial/relationship-attributes/index.md. PR #880 by @UncleGoogle.

Internal

• ⬆ [pre-commit.ci] pre-commit autoupdate. PR #979 by @pre-commit-ci[bot].
• 🔨 Update docs Termynal scripts to not include line nums for local dev. PR #1018 by @tiangolo.

0.0.19

Fixes

• 🐛 Fix pydantic EmailStr support and max_length in several String subclasses. PR #966 by @estebanx64.
• 🐛 Fix set varchar limit when max_length is set on Pydantic models using Pydantic v2. PR #963 by @estebanx64.

Refactors

• ♻️ Refactor generate select template to isolate templated code to the minimum. PR #967 by @tiangolo.

Upgrades

• ⬆️ Update minimum SQLAlchemy version to 2.0.14 as that one includes TryCast used internally. PR #964 by @tiangolo.

Docs

• ✏️ Fix broken link to @dataclass_transform (now PEP 681) in docs/features.md. PR #753 by @soof-golan.

Internal

• ⬆️ Upgrade Ruff and Black. PR #968 by @tiangolo.
• ⬆ Bump tiangolo/issue-manager from 0.4.1 to 0.5.0. PR #922 by @dependabot[bot].
• 📌 Pin typing-extensions in tests for compatiblity with Python 3.8, dirty-equals, Pydantic. PR #965 by @tiangolo.
• 👷 Update GitHub Actions to download and upload artifacts. PR #936 by @tiangolo.
• 👷 Tweak CI for test-redistribute, add needed env vars for slim. PR #929 by @tiangolo.

0.0.18

Internal

• ✨ Add sqlmodel-slim setup. PR #916 by @tiangolo.

In the future SQLModel will include the standard default recommended packages, and sqlmodel-slim will come without those recommended standard packages and with a group of optional dependencies sqlmodel-slim[standard], equivalent to sqlmodel, for those that want to opt out of those packages.

• 🔧 Re-enable MkDocs Material Social plugin. PR #915 by @tiangolo.

0.0.17

Refactors

• ♻️ Refactor types to properly support Pydantic 2.7. PR #913 by @tiangolo.

Docs

• 📝 Update ModelRead to ModelPublic documentation and examples. PR #885 by @estebanx64.
• ✨ Add source examples for Python 3.10 and 3.9 with updated syntax. PR #842 by @tiangolo and @estebanx64.

Internal

• ⬆ Bump actions/setup-python from 4 to 5. PR #733 by @dependabot[bot].
• 🔨 Update internal scripts and remove unused ones. PR #914 by @tiangolo.
• 🔧 Migrate from Poetry to PDM for the internal build config. PR #912 by @tiangolo.
• 🔧 Update MkDocs, disable cards while I can upgrade to the latest MkDocs Material, that fixes an issue with social cards. PR #888 by @tiangolo.
• 👷 Add cron to run test once a week on monday. PR #869 by @estebanx64.
• ⬆️ Upgrade Ruff version and configs. PR #859 by @tiangolo.
• 🔥 Remove Jina QA Bot as it has been discontinued. PR #840 by @tiangolo.

0.0.16

Features

• ✨ Add new method .sqlmodel_update() to update models in place, including an update parameter for extra data. And fix implementation for the (now documented) update parameter for .model_validate(). PR #804 by @tiangolo.
  • Updated docs: Update Data with FastAPI.
  • New docs: Update with Extra Data (Hashed Passwords) with FastAPI.

0.0.15

Fixes

• 🐛 Fix class initialization compatibility with Pydantic and SQLModel, fixing errors revealed by the latest Pydantic. PR #807 by @tiangolo.

Internal

• ⬆ Bump tiangolo/issue-manager from 0.4.0 to 0.4.1. PR #775 by @dependabot[bot].
• 👷 Fix GitHub Actions build docs filter paths for GitHub workflows. PR #738 by @tiangolo.

0.0.14

Features

• ✨ Add support for Pydantic v2 (while keeping support for v1 if v2 is not available). PR #722 by @tiangolo including initial work in PR #699 by @AntonDeMeester.

0.0.13

Fixes

• ♻️ Refactor type generation of selects re-order to prioritize models to optimize editor support. PR #718 by @tiangolo.

Refactors

• 🔇 Do not raise deprecation warnings for execute as it's automatically used internally. PR #716 by @tiangolo.
• ✅ Move OpenAPI tests inline to simplify updating them with Pydantic v2. PR #709 by @tiangolo.

Upgrades

• ⬆️ Add support for Python 3.11 and Python 3.12. PR #710 by @tiangolo.

Docs

• ✏️ Fix typo, simplify single quote/apostrophe character in "Sister Margaret's" everywhere in the docs. PR #721 by @tiangolo.
• 📝 Update docs for Decimal, use proper types. PR #719 by @tiangolo.
• 📝 Add source examples for Python 3.9 and 3.10. PR #715 by @tiangolo.

Internal

• 🙈 Update gitignore, include all coverage files. PR #711 by @tiangolo.
• 🔧 Update config with new pymdown extensions. PR #712 by @tiangolo.
• 🔧 Update docs build setup, add support for sponsors, add sponsor GOVCERT.LU. PR #720 by @tiangolo.
• ⬆ [pre-commit.ci] pre-commit autoupdate. PR #697 by @pre-commit-ci[bot].
• 🔧 Show line numbers in docs during local development. PR #714 by @tiangolo.
• 📝 Update details syntax with new pymdown extensions format. PR #713 by @tiangolo.