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 <https://github.com/ponyorm/pony/tree/orm/pony/orm/examples>_
contains several examples.
::
pip install pony
Pony online ER Diagram Editor <https://editor.ponyorm.com>_ 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.
FAQs
Pony Object-Relational Mapper
We found that pony demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 2 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Research
Security News
Malicious Go packages are impersonating popular libraries to install hidden loader malware on Linux and macOS, targeting developers with obfuscated payloads.
Security News
Bybit's $1.46B hack by North Korea's Lazarus Group pushes 2025 crypto losses to $1.6B in just two months, already surpassing all of 2024's $1.49B total.
Security News
OpenSSF has published OSPS Baseline, an initiative designed to establish a minimum set of security-related best practices for open source software projects.