Skip to main content

About

Pony ORM is easy to use and powerful object-relational mapper for Python. Using Pony, developers can create and maintain database-oriented software applications faster and with less effort. One of the most interesting features of Pony is its ability to write queries to the database using generator expressions. Pony then analyzes the abstract syntax tree of a generator and translates it to its SQL equivalent.

Following is an example of a query in Pony:

select(p for p in Product if p.name.startswith('A') and p.cost <= 1000)

Such approach simplify the code and allows a programmer to concentrate on the business logic of the application.

Pony translates queries to SQL using a specific database dialect. Currently Pony works with SQLite, MySQL, PostgreSQL and Oracle databases.

The package pony.orm.examples contains several examples.

Installation

pip install pony

Entity-Relationship Diagram Editor

Pony online ER Diagram Editor is a great tool for prototyping. You can draw your ER diagram online, generate Pony entity declarations or SQL script for creating database schema based on the diagram and start working with the database in seconds.

Metadata

Release files for pony2 0.7.16

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for pony2 0.7.16
File Size Uploaded
pony2-0.7.16.tar.gz 252.4 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for pony2 0.7.16
File Interpreter ABI Platform
pony2-0.7.16-py3-none-any.whl Python 3 none any Details

Total release size: 562.1 kB

Release files / pony2-0.7.16.tar.gz

Download URL pony2-0.7.16.tar.gz
Size 252.4 kB
Tags Source
SHA-256 checksum
How to use checksums
09b3b5b59da25b49f77bc1d8839deed3388d067f3c5f4cc91724eaf6a7814218
BLAKE2b-256 checksum
How to use checksums
a0e15b76c1c84160f352fbe1c93145dc7ccc7a0895258b3dbc69ca80952d05de
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/4.0.2 CPython/3.10.6

Release files / pony2-0.7.16-py3-none-any.whl

Download URL pony2-0.7.16-py3-none-any.whl
Size 309.7 kB
Tags Python 3
SHA-256 checksum
How to use checksums
5509ec42ee280ecb50c0efec8807f1ba76c915b383c64dfaba610ee1c341ac58
BLAKE2b-256 checksum
How to use checksums
8861326b513ba4db4155a2a2f2c38eb1adc9bd0c11ac361d8ddb067d1ce4448f
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/4.0.2 CPython/3.10.6

Release history Release notifications | RSS feed

This release

0.7.16 This release

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page