Pony is an advanced object-relational mapper.
Pony is an easy-to-learn and easy-to-use library. It makes your work more productive and helps to save resources.
This is free and open source software.
Key Features
- Write queries to the database using Python generator expressions and lambdas. Queries may be written by a developer familiar with Python, even without being a database expert.
- Analyzes the abstract syntax tree of the expression and translates it into a SQL query.
- Automatic query optimization
- An elegant solution for the N+1 problem
- The online database schema editor
- Compact entity definitions.
- The concise query language.
- Ability to work with Pony interactively in a Python interpreter.
- Comprehensive error messages, showing the exact part where an error occurred in the query.
- Displaying of the generated SQL in a readable format with indentation.
- The IdentityMap pattern.
- Automatic transaction management.
- Automatic caching of queries and objects.
- Full support of composite keys.
- The ability to easily write queries using LEFT JOIN, HAVING and other features of SQL.
- Pythonic API.
Website: github.com/ponyorm/pony
Support: Documentation
Developer: Alexander Kozlovsky and contributors
License: Apache License 2.0
Pony 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.