SQLModel is a library for interacting with SQL databases from Python code, with Python objects. It is designed to be intuitive, easy to use, highly compatible, and robust.
peewee
Peewee is a simple and small ORM. It has few (but expressive) concepts, making it easy to learn and intuitive to use.
a small, expressive ORM
python 2.7+ and 3.4+ (developed with 3.6)
supports sqlite,
SanicDB
Description
SanicDB is a simple wrapper around aiomysql that refer to torndb which is in old Tornado (http://www.tornadoweb.org).
Limitations
SanicDB only supports Python 3.5 or newer
Awesome Android Persistence
A curated list of awesome android persistence libraries about SQLite, ORM, Mobile Database, SharedPreferences, etc.
Awesome Repositories
Repository
D
Tortoise ORM
Introduction
Tortoise ORM is an easy-to-use asyncio ORM (Object Relational Mapper) inspired by Django.
Tortoise ORM was build with relations in mind and admiration for the excel
marshmallow: simplified object serialization
marshmallow is an ORM/ODM/framework-agnostic library for converting complex datatypes, such as objects, to and from native Python datatypes.
from datetime import d
GINO - GINO Is Not ORM - is a lightweight asynchronous ORM built on top of SQLAlchemy core for Python asyncio. GINO 1.0 supports only PostgreSQL with asyncpg.
Free software: BSD license
Requires: Pyt
reobject
reobject is an ORM layer for your objects. It allows you to track and query objects at runtime using a familiar query langauge inspired by Django ORM.
Note: reobject is NOT a database ORM. It keeps track
Records: SQL for Humans™
Records is a very simple, but powerful, library for making raw SQL queries to most relational databases.
Just write SQL. No bells, no whistles. This common task can be surprisingly di
DjangoQL
Advanced search language for Django, with auto-completion. Supports logical operators, parenthesis, table joins, and works with any Django model. Tested on Python 2.7, 3.5 - 3.8, Django 1.8 - 3.0. The auto-co
SQLAlchemy mixins
A pack of framework-agnostic, easy-to-integrate and well tested mixins for SQLAlchemy ORM.
Heavily inspired by Django ORM and Eloquent ORM
Why it's cool:
framework-agnostic
easy integration
Orator
The Orator ORM provides a simple yet beautiful ActiveRecord implementation.
It is inspired by the database part of the Laravel framework, but largely modified to be more pythonic.
The full documentation is av
sqlalchemy_aio
sqlalchemy_aio adds asyncio and Trio support to SQLAlchemy core, derived from alchimia.
Getting started
import asyncio
from sqlalchemy_aio import ASYNCIO_STRATEGY
from sqlalchemy i
python-sqlite-orm
A Python object relational mapper for SQLite.
Install
pip install sqlite-orm
Usage
Following a basic tutorial to demonstrate how to use the ORM.
Define a Post model in a
butterdb
Master:
Develop:
Documentation | butterdb on PyPi
butterdb is a library to help you work with Google Spreadsheet data. It lets you model your data as Python objects, to be easily ma
Awesome SQLAlchemy
A curated list of awesome extra libraries and resources for SQLAlchemy. Inspired by awesome-python. (See also other awesome lists!)
Licensed under a Creative Commons Attribution-ShareAlike 4.0 Int
sqlakeyset: offset-free paging for sqlalchemy
Notice: In accordance with Python 2's rapidly-approaching end-of-life date, we've stopped supporting Python 2. If you really need it, the latest version to support Python 2