Skip to main content

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.

Project details


Download files

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

Source Distribution

pony-0.7.13.tar.gz (284.7 kB view details)

Uploaded Source

File details

Details for the file pony-0.7.13.tar.gz.

File metadata

  • Download URL: pony-0.7.13.tar.gz
  • Upload date:
  • Size: 284.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/3.1.1 pkginfo/1.5.0.1 requests/2.23.0 setuptools/45.2.0 requests-toolbelt/0.9.1 tqdm/4.43.0 CPython/3.6.9

File hashes

Hashes for pony-0.7.13.tar.gz
Algorithm Hash digest
SHA256 8a9e7339fe7a5182566c83047dbae8053aa1cf458bff0f21f1ae1b106a210cbb
MD5 83dbd95d1ed2d7c8687777151c62cc59
BLAKE2b-256 48e445fa6185e86edfa97eef5a4fbe3f29f537de7f36c032ff7c54676310dcb1

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page