SaaSHub helps you find the best software and product alternatives Learn more →
Top 23 Python ORM Projects
The Web framework for perfectionists with deadlines.Project mention: HStoreField sometimes returns str instead of dict | reddit.com/r/django | 2023-01-26
a small, expressive orm -- supports postgresql, mysql and sqliteProject mention: Top python libraries/ frameworks that you suggest every one | reddit.com/r/Python | 2022-03-28
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.
The Database Toolkit for PythonProject mention: SQLAlchemy 2.0.0 Released | reddit.com/r/Python | 2023-01-26
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
A Python Object-Document-Mapper for working with MongoDBProject 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.
Familiar asyncio ORM for python, built with relations in mindProject mention: Example typescript project repos? | reddit.com/r/typescript | 2022-10-27
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 Object Relational MapperProject mention: This Week in Python | dev.to | 2022-05-20
pony – Pony Object Relational Mapper
GINO Is Not ORM - a Python asyncio ORM on SQLAlchemy core.
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.
A pythonic interface to Amazon's DynamoDB
Automatically generate a RESTful API service for your legacy database. No code required!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.
A slick ORM cache with automatic granular event-driven invalidation.Project mention: Storing frequently used data in django | reddit.com/r/django | 2022-03-28
django-cacheops is a great package https://github.com/Suor/django-cacheops
An async ORM. 🗃 (by encode)
The Orator ORM provides a simple yet beautiful ActiveRecord implementation.
python async orm with fastapi in mind and pydantic validationProject mention: What Python library do you wish existed? | reddit.com/r/Python | 2023-01-15
How about ormar?
Lightweight Python utilities for working with Redis
Asynchronous Python ODM for MongoDBProject 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 Python is an auto-generated and fully type-safe database client designed for ease of useProject mention: Alternatives to SQLAlchemy for your project - Prisma case | dev.to | 2022-08-08
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. 🤣
A fast, user friendly ORM and query builder which supports asyncio. (by piccolo-orm)
Django MongoDB Backend
Sync and Async ODM (Object Document Mapper) for MongoDB based on python type hintsProject 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, ...
Active Record, Django-like queries, nested eager load and beauty __repr__ for SQLAlchemyProject mention: Django or Flask and why? | reddit.com/r/Python | 2022-02-05
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
A database migrations tool for TortoiseORM, ready to production.
A pure Python Database Abstraction Layer
A Python Library for Simple Models and Containers Persisted in Redis
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
Python ORM related posts
SQLAlchemy 2.0.0 Released
2 projects | reddit.com/r/Python | 26 Jan 2023
What are some good useful libraries I can get the hang of?
3 projects | reddit.com/r/learnpython | 18 Jan 2023
What Python library do you wish existed?
6 projects | reddit.com/r/Python | 15 Jan 2023
Looking for a mentor to help me get into Open Source Software contributions
1 project | reddit.com/r/ProgrammingBuddies | 12 Jan 2023
Database Driver and Migration Handling for NodeJS: What are the options?
1 project | reddit.com/r/Database | 8 Jan 2023
Getting Started with a Web Scraping Project
5 projects | dev.to | 7 Jan 2023
starlette-admin: support for Odmantic & many more
5 projects | reddit.com/r/Python | 21 Dec 2022
A note from our sponsor - #<SponsorshipServiceOld:0x00007fea59ac7bf0>
www.saashub.com | 28 Jan 2023
What are some of the best open-source ORM projects in Python? This list will help you: