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