ormar is an asynchronous object-relational mapper for Python, designed with FastAPI and Pydantic integration in mind. It lets developers use a single model for database mapping, data validation, and FastAPI request and response schemas.
The ORM uses SQLAlchemy for query construction and asynchronous database access. It supports PostgreSQL, MySQL, and SQLite, together with relationships, transactions, signals, migrations, and a comprehensive QuerySet API.
This is free and open source software.
Key Features
- Asynchronous database access suitable for FastAPI, Starlette, and other async frameworks.
- Uses Pydantic models for data validation and serialization.
- Uses SQLAlchemy for query building and cross-database support.
- Supports PostgreSQL, MySQL, and SQLite databases.
- Provides asynchronous create, read, update, and delete operations.
- Supports foreign key and many-to-many relationships.
- Offers filtering, sorting, joins, subqueries, pagination, and aggregations.
- Returns model instances or raw database data.
- Supports model inheritance and Pydantic-only fields.
- Provides optional field encryption.
- Includes database transactions and model lifecycle signals.
- Works with Alembic for database migrations.
- Supports use as FastAPI request and response models.
- Provides type annotations and mypy support.
Website: github.com/ormar-orm/ormar
Support:
Developer: Radosław Drążkiewicz
License: MIT License
ormar 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.