GINO

GINO - GINO Is Not ORM - is an extremely simple Python ORM, using SQLAlchemy core to define table models, and asyncpg to interact with database.
GINO tries to stay in the middle between ORM and non-ORM:
GINO operates database rows with "plain old Python objects" - a rollback doesn't magically change their values. Any database operations are explicit. There are no dirty models, no sessions, no magic. You have concrete control to the database, through a convenient object interface.
GINO depends on asyncpg, which means it works only for PostgreSQL and asyncio, so Python 3.6 is required. Based on SQLAlchemy, gate to its ecosystem is open - feel free to use e.g. Alembic to manage your schema changes. And we specially designed a few candies for the Sanic server.

Tags

Alembic asynchronous asyncio asyncpg orm python python36 Sanic sql sqlalchemy SQLAlchemy