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 |
| SQLModel | Combines database models with type-safe data validation |
| Tortoise | Easy-to-use asyncio ORM inspired by Django |
| Pony | Billed as the smartest Python ORM |
| Piccolo | Async-first database toolkit with migrations and a powerful query API |
| SQLObject | Forms a part of many applications including TurboGears |
| ormar | Build expressive async database models with minimal boilerplate |
| Edgy | Modern async database layer focused on simplicity and flexibility |
| Saffier | Lightweight async data modelling with support for multiple databases |
| Storm | Designed to work with thin relational databases and big systems |
Read our verdict in the software roundup.
 LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README. |
Please read our Comment Policy before commenting.