SQLModel: SQL DBs based on Python type hints. The biggest thing I've built since FastAPI and Typer. 😅

This page summarizes the projects mentioned and recommended in the original post on /r/FastAPI

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
  • sqlmodel

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

  • FastAPIQuickCRUD

    Generate CRUD methods in FastApi from an SQLAlchemy schema

    I think it is possible to use it as a crud router generator like this repo Fastapi Quick CRUD

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • geojson-pydantic

    Pydantic data models for the GeoJSON spec

    All I would want from SQLModel right now would be support for a geography column from GeoALchemy and then a validator which converts the EWB to GeoJSON (https://geojson.org/) (As GeoJSON is a standard for most map frameworks to consume and produce spatial data). There is a Pydantic library representing the GeoJSON spec (https://github.com/developmentseed/geojson-pydantic) - it currently doesn't work in FastAPI since it uses tuples for coordinate sequences and Tuples are not supported until OpenAPI schema v3.1 AFAIK.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts