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 |
| 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.