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