SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Python ORM Projects
-
Project mention: HStoreField sometimes returns str instead of dict | reddit.com/r/django | 2023-01-26
https://github.com/django/django/blob/3.2.16/django/contrib/postgres/apps.py#L61 https://github.com/django/django/blob/3.2.16/django/contrib/postgres/signals.py
-
Project mention: Top python libraries/ frameworks that you suggest every one | reddit.com/r/Python | 2022-03-28
peewee
-
InfluxDB
Build time-series-based applications quickly and at scale.. InfluxDB is the Time Series Platform where developers build real-time applications for analytics, IoT and cloud-native services. Easy to start, it is available in the cloud or on-premises.
-
that said, most "pagination" is done for stateless web applications so you would want a strategy that SELECTs only the rows you want in the first place, a good article on that is at https://use-the-index-luke.com/blog/2013-07/pagination-done-the-postgresql-way ; within SQLAlchemy, we have some (older API style, but still general idea works) wiki examples for both a criteria-based solution as well as one that uses window functions: https://github.com/sqlalchemy/sqlalchemy/wiki/RangeQuery-and-WindowedRangeQuery
-
Project mention: Are mongoengine and related projects maintained anymore? Any recommendations for decent ODM | reddit.com/r/Python | 2022-05-20
My biggest issue with mongoengine has been the longstanding issue with poor performance on large documents. This is to a large extent a problem with the underlying data model I've worked with, but it's crazy when deserializing a mongo object takes longer than transferring it from the remote DB.
-
If I was answering this question but for python, I'd recommend something like prefect, boto3, or tortoise-orm -- not extremely complex and with a pretty comprehensible featureset.
-
pony – Pony Object Relational Mapper
-
-
Sonar
Write Clean Python Code. Always.. Sonar helps you commit clean code every time. With over 225 unique rules to find Python bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.
-
-
Project mention: Nocodb: Turns Any MySQL, Postgres, SQLite into a Spreadsheet with REST APIs | news.ycombinator.com | 2022-10-04
https://github.com/jeffknupp/sandman2 works with many different backends including sqlite, but postgrest definitely have the auth flow and security model right for these things.
-
django-cacheops is a great package https://github.com/Suor/django-cacheops
-
-
-
How about ormar?
-
-
Project mention: starlette-admin: Simple and extensible admin interface framework for Starlette/FastApi | reddit.com/r/Python | 2022-09-11
You may want to look at swapping mongoengine for beanie. That supports native pydantic data structures and has async support.
-
prisma-client-py
Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use
Anyway, prisma is a relatively new project, and it is very pleasant to use. I encourage you to give it a try and support the python client (at least a star on GitHub). For me who doesn't like SQL, being able to retrieve models from the database and make queries with prisma is a breath of fresh air. 🤣
-
-
-
Project mention: starlette-admin: support for Odmantic & many more | reddit.com/r/Python | 2022-12-21
Hello u/everyone, the latest releases of starlette-admin add support for Odmantic (an async python ODM) , better support for dynamic list and embedded document, custom batch actions, ...
-
sqlalchemy-mixins
Active Record, Django-like queries, nested eager load and beauty __repr__ for SQLAlchemy
it is more low level, but there are several projects that build Django (active record style) abstraction on top of it. https://github.com/absent1706/sqlalchemy-mixins
-
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
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).
The latest post mention was on 2023-01-26.
Python ORM related posts
- SQLAlchemy 2.0.0 Released
- What are some good useful libraries I can get the hang of?
- What Python library do you wish existed?
- Looking for a mentor to help me get into Open Source Software contributions
- Database Driver and Migration Handling for NodeJS: What are the options?
- Getting Started with a Web Scraping Project
- starlette-admin: support for Odmantic & many more
-
A note from our sponsor - #<SponsorshipServiceOld:0x00007fea59ac7bf0>
www.saashub.com | 28 Jan 2023
Index
What are some of the best open-source ORM projects in Python? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Django | 68,369 |
| 2 | Peewee | 9,716 |
| 3 | SQLAlchemy | 6,580 |
| 4 | MongoEngine | 3,932 |
| 5 | tortoise-orm | 3,339 |
| 6 | PonyORM | 3,116 |
| 7 | GINO | 2,529 |
| 8 | PynamoDB | 2,090 |
| 9 | sandman2 | 1,911 |
| 10 | django-cacheops | 1,754 |
| 11 | orm | 1,687 |
| 12 | Orator | 1,379 |
| 13 | ormar | 1,221 |
| 14 | walrus | 1,062 |
| 15 | beanie | 1,039 |
| 16 | prisma-client-py | 959 |
| 17 | piccolo | 949 |
| 18 | django-mongodb-engine | 860 |
| 19 | odmantic | 745 |
| 20 | sqlalchemy-mixins | 616 |
| 21 | aerich | 612 |
| 22 | pyDAL | 443 |
| 23 | redisco | 436 |
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com