FastAPI, Pydantic, Psycopg3: the holy trinity for Python web APIs

• litestar

  31 5,652 9.6 Python

  Production-ready, Light, Flexible and Extensible ASGI API framework | Effortlessly Build Performant APIs

  

  If I was starting from scratch with Python web API development today, I would probably look more closely at LiteStar, which seems to me to be a better architected and with a better project governance structure.

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• asgiref

  18 1,489 6.8 Python

  ASGI specification and utilities

  

  Note 1: we are only interested in async libraries here, as FastAPI is ASGI.

• tortoise-orm

  10 4,697 9.1 Python

  Familiar asyncio ORM for python, built with relations in mind

  

  TortoiseORM: I personally really like this Django-inspired async ORM; it's clean and nice to use.

• Peewee

  6 11,226 8.3 Python

  a small, expressive orm -- supports postgresql, mysql, sqlite and cockroachdb

  Alternative ORMs: there are many such as peewee, PonyORM, etc.

• PonyORM

  3 3,657 5.3 Python

  Pony Object Relational Mapper

  

  Alternative ORMs: there are many such as peewee, PonyORM, etc.

• databases

  16 3,848 5.4 Python

  Async database support for Python. 🗄

  

  SQLAlchemy Core: the core SQL query builder, without the mapping to objects part. There is also a higher level ORM built on this called databases that looks very nice. I do wonder how actively developed the project is however.

• PyPika

  5 2,541 3.8 Python

  PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.

  

  PyPika: I don't know much about this one.

• asyncpg

  18 7,014 7.8 Python

  A fast PostgreSQL Database Client Library for Python/asyncio.

  

  asyncpg: this was the gold standard async database driver for Postgres, being one of the first to market and most performant. While all other drivers use the C library libpq to interface with Postgres, MagicStack opted to rewrite their own custom implementation and also deviate from Python DBAPI spec. If performance is your main criteria here, then asyncpg is probably the best option.

• psycopg

  9 1,786 9.4 Python

  New generation PostgreSQL database adapter for the Python programming language

  

  psycopg3: well psycopg2 was clearly the king of the synchronous database driver world for Python/Postgres. psycopg3 (rebranded to simply psycopg) is the next, fully async, iteration of this library. This library has really come into it's own in recent years & I wish to discuss it further. See this interesting blog from the author about the early days of psycopg3.

• pydantic

  175 21,335 9.8 Python

  Data validation using Python type hints

  

  Pydantic is bundled with FastAPI and is excellent for modelling, validating, and serialising API responses.

• sqlmodel

  25 14,671 9.0 Python

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

  

  This is exactly the problem the creator of FastAPI tried to solve with the library SQLModel.

• attrs

  13 5,309 9.3 Python

  Python Classes Without Boilerplate

  

  This functionality allows you to map returned database data to any Python object, including standard lib dataclasses, models from the great attrs library, and yes, Pydantic models!

• fmtm

  2 49 9.9 TypeScript

  Field Mapping Tasking Manager - coordinated field mapping.

  

  See the full codebase here. And ⭐ if you found this useful!

Suggest a related project