Edgy is a Python object-relational mapper designed for working with complex databases. It combines SQLAlchemy Core with Pydantic, providing a familiar model and query interface together with automatic data validation.
The ORM is framework agnostic and can be integrated with ASGI frameworks including FastAPI, Starlette, Sanic and Quart. It also includes database migration tooling built on Alembic.
This is free and open source software.
Key Features
- Models use Pydantic for automatic data validation.
- Built on the flexible and powerful SQLAlchemy Core.
- Supports model inheritance, abstract models and meta classes.
- Provides custom managers, filters and composable querysets.
- Supports one-to-one, foreign key and many-to-many relationships.
- Offers bulk creation, updating and other common database operations.
- Includes constraints and indexes defined through model metadata.
- Provides a native migration system built on Alembic.
- Supports PostgreSQL, MySQL, MariaDB, SQLite, MSSQL and JDBC databases.
- Offers built-in support for multi-tenant applications.
- Includes a native database test client.
- Works with a wide range of ASGI frameworks.
Website: github.com/dymmond/edgy
Support:
Developer: Dymmond Ltd.
License: BSD 3-Clause “New” or “Revised” License
Edgy 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.