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 pony 0.7.6

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

Source distribution (sdist)

Source distribution for pony 0.7.6
File Size Uploaded
pony-0.7.6.tar.gz 256.8 kB Details

Built distributions (wheels)

Table of built distributions (wheels) for pony 0.7.6
File Interpreter ABI Platform
pony-0.7.6-py3-none-any.whl Python 3 none any Details
pony-0.7.6-py2-none-any.whl Python 2 none any Details

Total release size: 884.2 kB

Release files / pony-0.7.6.tar.gz

Download URL pony-0.7.6.tar.gz
Size 256.8 kB
Tags Source
SHA-256 checksum
How to use checksums
b18434011c03c2981e44a2cfbbaeec4bdebe30adb434d1dfd6be8f59d07f37bd
BLAKE2b-256 checksum
How to use checksums
ead9ebc9d7719b6e3f7ed07e02e88fe2f2d4f92c860f0c35dd4acf0ec1a3b55d
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.11.0 pkginfo/1.4.2 requests/2.19.1 setuptools/39.2.0 requests-toolbelt/0.8.0 tqdm/4.23.4 CPython/2.7.15

Release files / pony-0.7.6-py3-none-any.whl

Download URL pony-0.7.6-py3-none-any.whl
Size 313.7 kB
Tags Python 3
SHA-256 checksum
How to use checksums
c6dee426b50001a5cf984f201b2b61d66acd8f5018813e3a587467971f30ec2a
BLAKE2b-256 checksum
How to use checksums
4c333cb99aab8f115a5b6b9c07988d1abfa2ab8f6d937d65d27eff01518006f0
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.11.0 pkginfo/1.4.2 requests/2.19.1 setuptools/40.0.0 requests-toolbelt/0.8.0 tqdm/4.23.4 CPython/3.6.5

Release files / pony-0.7.6-py2-none-any.whl

Download URL pony-0.7.6-py2-none-any.whl
Size 313.7 kB
Tags Python 2
SHA-256 checksum
How to use checksums
0d72f4ab9d50d42f275606c0c2812aa704bf3a37ac8f2a60c9892eff3f90d615
BLAKE2b-256 checksum
How to use checksums
5fa5a7feeeb532438e436feadbd054a744c26748dd8d43a2b1fe59c43f830b8b
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.11.0 pkginfo/1.4.2 requests/2.19.1 setuptools/40.0.0 requests-toolbelt/0.8.0 tqdm/4.23.4 CPython/3.6.5

Release history Release notifications | RSS feed

0.7.19

2 release files

0.7.18

2 release files

0.7.17

2 release files

0.7.16

2 release files

0.7.15

2 release files

0.7.14

1 release file

0.7.13

1 release file

0.7.12

1 release file

0.7.11

1 release file

0.7.10

1 release file

0.7.9

1 release file

0.7.8

1 release file

0.7.7

1 release file

This release

0.7.6 This release

3 release files

0.7.5

2 release files

0.7.4

1 release file

0.7.3

1 release file

0.7.2

1 release file

0.7.1

1 release file

0.7

1 release file

0.6.6

1 release file

0.6.5

1 release file

0.6.4

1 release file

0.6.3

1 release file

0.6.2

1 release file

0.6.1

1 release file

0.6

1 release file

0.5.4

1 release file

0.5.3

1 release file

0.5.2

1 release file

0.5.1

1 release file

0.5

1 release file

0.4.9

1 release file

0.4.8

1 release file

0.4.7

1 release file

0.4.6

1 release file

0.4.5

1 release file

0.4.3

1 release file

0.4.2

1 release file

0.4.1

1 release file

0.4

1 release file

0.3

1 release file

0.2

1 release file

0.1

1 release file

0.0.1a1

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