Python ORM

Open-source Python projects categorized as ORM
Edit details
Topics: Python Database Asyncio Sqlalchemy NoSQL Databases
Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
Sponsored

Top 23 Python ORM Projects

  • Django

    The Web framework for perfectionists with deadlines.

    • Project mention: AutoCodeRover resolves 22% of real-world GitHub in SWE-bench lite | news.ycombinator.com | 2024-04-09

    >As an example, AutoCodeRover successfully fixed issue #32347 of Django.

    This bug was fixed three years ago in a one-line change.[0] Presumably the fix was already in the training data.

    [0] https://github.com/django/django/pull/13933

  • Peewee

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

    • Project mention: Any Python ORMs worthy of production? | news.ycombinator.com | 2023-12-18

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo

  • SQLAlchemy

    The Database Toolkit for Python

    • Project mention: Xz/liblzma: Bash-stage Obfuscation Explained | news.ycombinator.com | 2024-03-31

    OK -

    can we start considering binary files committed to a repo, even as data for tests, to be a huge red flag, and that the binary files themselves should instead be generated at testing time by source code that's stated as reviewable cleartext. This would make it much harder (though of course we can never really say "impossible") to embed a substantial payload in this way.

    when binary files are part of a test suite, they are typically trying to illustrate some element of the program being tested, in this case a file that was incorrectly xz-encoded. Binary files like these weren't typed by hand, they will always ultimately come from something plaintext source.

    Here's an example! My own SQLAlchemy repository has a few binary files in it! https://github.com/sqlalchemy/sqlalchemy/blob/main/test/bina... oh noes. Why are those files there? well in this case I just wanted to test that I can send large binary BLOBs into the database driver and I was lazy. This is actually pretty dumb, the two binary files here add 35K of useless crap to the source, and I could just as easily generate this binary data on the fly using a two liner that spits out random bytes. Anyone could see that two liner and know that it isn't embedding a malicious payload.

    If I wanted to generate a poorly formed .xz file, I'd illustrate source code that generates random data, runs it through .xz, then applies "corruption" to it, like zeroing out the high bit of every byte. The process by which this occurs would be all reviewable in source code.

  • tortoise-orm

    Familiar asyncio ORM for python, built with relations in mind

    • Project mention: How to Connect a FastAPI Server to PostgreSQL and Deploy on GCP Cloud Run | dev.to | 2023-05-26

    To do this, we can use the Tortoise-ORM. Begin by installing the package:

  • MongoEngine

    A Python Object-Document-Mapper for working with MongoDB

  • PonyORM

    Pony Object Relational Mapper

  • GINO

    GINO Is Not ORM - a Python asyncio ORM on SQLAlchemy core.

  • 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

  • PynamoDB

    A pythonic interface to Amazon's DynamoDB

  • django-cacheops

    A slick ORM cache with automatic granular event-driven invalidation.

  • sandman2

    Automatically generate a RESTful API service for your legacy database. No code required!

  • beanie

    Asynchronous Python ODM for MongoDB

    • Project mention: Ask HN: Where do I find good code to read? | news.ycombinator.com | 2023-08-24

    I recently came across Beanie. A Python ORM for MongoDb. A pleasure to work with and integrates well with FastAPI, the tests document the code well, and at this point it’s only as complicated as it needs to be.

    https://github.com/roman-right/beanie

  • orm

    An async ORM. 🗃 (by encode)

  • prisma-client-py

    Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use

  • ormar

    python async orm with fastapi in mind and pydantic validation

  • Orator

    The Orator ORM provides a simple yet beautiful ActiveRecord implementation.

  • piccolo

    A fast, user friendly ORM and query builder which supports asyncio. (by piccolo-orm)

    • Project mention: Piccolo, a Lightweight and Async Pydantic V2 Python ORM | news.ycombinator.com | 2023-11-07

  • walrus

    Lightweight Python utilities for working with Redis

  • odmantic

    Sync and Async ODM (Object Document Mapper) for MongoDB based on python type hints

    • Project mention: Is there mongoose alternative in Python? (A NoSQL ORM) | /r/learnpython | 2023-05-14

  • django-mongodb-engine

    Django MongoDB Backend

  • aerich

    A database migrations tool for TortoiseORM, ready to production.

  • sqlalchemy-mixins

    Active Record, Django-like queries, nested eager load and beauty __repr__ for SQLAlchemy

  • pyDAL

    A pure Python Database Abstraction Layer

  • μMongo

    sync/async MongoDB ODM, yes. (by Scille)

  • SaaSHub

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

    SaaSHub logo
NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020).

Python ORM related posts

Index

What are some of the best open-source ORM projects in Python? This list will help you:

Project Stars
1 Django 76,672
2 Peewee 10,785
3 SQLAlchemy 8,750
4 tortoise-orm 4,224
5 MongoEngine 4,156
6 PonyORM 3,514
7 GINO 2,635
8 PynamoDB 2,371
9 django-cacheops 2,028
10 sandman2 1,983
11 beanie 1,785
12 orm 1,754
13 prisma-client-py 1,596
14 ormar 1,573
15 Orator 1,421
16 piccolo 1,266
17 walrus 1,136
18 odmantic 973
19 django-mongodb-engine 864
20 aerich 779
21 sqlalchemy-mixins 717
22 pyDAL 476
23 μMongo 442

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com