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

1. litestar

   1 34 7,781 9.4 Python

   Light, flexible and extensible ASGI framework | Built to scale

   

   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.

2. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

3. asgiref

   2 22 1,602 7.2 Python

   ASGI specification and utilities

   

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

4. tortoise-orm

   3 12 5,416 8.0 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.

5. Peewee

   4 6 11,883 7.2 Python

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

   

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

6. PonyORM

   5 3 3,824 3.4 Python

   Pony Object Relational Mapper

   

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

7. databases

   6 18 3,932 5.4 Python

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

8. PyPika

   7 5 2,857 7.0 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.

9. Stream

   getstream.io featured

   Stream - Scalable APIs for Chat, Feeds, Moderation, & Video. Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.

   

10. asyncpg

    8 18 7,843 6.2 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.

11. psycopg

    9 9 2,232 9.6 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.

12. pydantic

    10 183 26,209 9.8 Python

    Data validation using Python type hints

    

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

13. sqlmodel

    11 26 17,360 9.5 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.

14. attrs

    12 13 5,686 9.0 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!

15. field-tm

    13 3 74 9.9 TypeScript

    Field Tasking Manager - coordinated field mapping.

    

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

Suggest a related project