Saffier is an asynchronous Python object-relational mapper built directly on SQLAlchemy 2.x Async. It provides a Python-native model layer with a familiar, Django-inspired interface for defining models and working with relational databases.
The ORM is framework-agnostic and can be integrated with ASGI frameworks including FastAPI, Starlette, Sanic, Quart and Lilya. It supports PostgreSQL, MySQL, MariaDB and SQLite through optional asynchronous database drivers.
This is free and open source software.
Key Features
- Asynchronous database access powered by SQLAlchemy 2.x Async.
- Python-native model and field system.
- Model inheritance, abstract models and metaclasses.
- Custom managers, querysets and field-based filtering.
- Supports one-to-one, foreign-key and many-to-many relationships.
- Bulk create, update and delete operations.
- Native migration system built on Alembic.
- Database indexes, constraints and schema reflection.
- Multi-tenancy and multi-schema support.
- File and image fields with configurable storage backends.
- Optional Pydantic and msgspec model engines.
- Python-native administration interface powered by Lilya.
- Framework-agnostic design suitable for ASGI applications.
- Command-line interface for migrations and administration tasks.
Website: github.com/tarsil/saffier
Support:
Developer: Tiago Silva
License: MIT License
Saffier is written in Python. Learn Python with our recommended free books and free tutorials.
Related Software
| Python Object-Relational Mapping Software | |
|---|---|
| Django | High-level web application framework that has a powerful ORM |
| SQLAlchemy | Python SQL Toolkit and Object Relational Mapper |
| Peewee | Simple, small and expressive Object Relational Mapper. It has few concepts |
| Tortoise | Easy-to-use asyncio ORM inspired by Django |
| Pony | Billed as the smartest Python ORM |
| SQLObject | Forms a part of many applications including TurboGears |
| Storm | Designed to work with thin relational databases and big systems |
Read our verdict in the software roundup.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |
Please read our Comment Policy before commenting.