Skip to main content
Join the official Python Developers Survey 2018 and win valuable prizes: Start the survey!

Pony Object-Relational Mapper

Project description

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.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
pony-0.7.6-py2-none-any.whl (313.7 kB) Copy SHA256 hash SHA256 Wheel py2 Aug 10, 2018
pony-0.7.6-py3-none-any.whl (313.7 kB) Copy SHA256 hash SHA256 Wheel py3 Aug 10, 2018
pony-0.7.6.tar.gz (256.8 kB) Copy SHA256 hash SHA256 Source None Aug 10, 2018

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page