ORM for FastAPI+PostgreSQL, Tortoise or Sqlalchemy? what would you choose and why?

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

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

    Full stack, modern web application template. Using FastAPI, React, SQLModel, PostgreSQL, Docker, GitHub Actions, automatic HTTPS and more.

  • mro

    An Object Relational Mapping (ORM) but in reverse, create classes from the database schema not the usual way round. Sometimes referred to as reverse ORM, database introspection and database reflection.

  • We use https://github.com/Dark-Bob/mro which is a reverse ORM that works via database reflection, which makes migration much simpler than if you define your database in code.

  • 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.

    WorkOS logo
  • fastapi-backend-base

    Discontinued :globe_with_meridians: A base project I use for building fastapi backends

  • Fully agree. I have a production ready FastAPI backend base project OP can use for reference https://github.com/nickatnight/fastapi-backend-base

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