Pony is an object-relational mapper. The most interesting feature of Pony is its ability to write queries to the database using generator expressions. Pony works with entities which are mapped to a SQL database. Using generator syntax for writing queries allows the user to formulate very eloquent queries. It increases the level of abstraction and allows a programmer to concentrate on the business logic of the application. For this purpose Pony 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)

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

Pony ORM also include the ER Diagram Editor which is a great tool for prototyping. You can create your ER diagram online at https://editor.ponyorm.com, generate the database schema based on the diagram and start working with the database using declarative queries in seconds.

The package pony.orm.examples contains several examples. Documenation is available at http://doc.ponyorm.com

We are looking forward to your comments and suggestions at our mailing list http://ponyorm-list.ponyorm.com

Pony ORM is released under multiple licenses, check ponyorm.com for more information.

Pony ORM documentation is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.

By editing or otherwise contributing to Pony ORM documentation, you agree to license any text you change or contribute under the CC BY-SA license.

Copyright (c) 2014 Pony ORM, LLC. All rights reserved. team (at) ponyorm.com

Please send your questions, comments and suggestions to our mailing list http://ponyorm-list.ponyorm.com