PonyORM - Python

Recently I came to know a modern object rational mapper (ORM) named PonyORM for Python. It is basically known for its ability to write queries to the database using Python generator expressions and lambdas. An example query could be:

print('All Bangladeshi customers')
result = select(c for c in Customer if c.country == 'Bangladesh')[:]        

..more like a SQL query in a pythonic way. You can compare it with SQLAlchemy instead of Django's ORM as it supports SQLite, MySQL, PostgreSQL and Oracle databases.

Why use Pony?

• It's query language is consise and entity definitions is compact.
• Ability to work more interactively with Python Interpreter
• Support developer for productive work and save resources

Another interesting thing, it has ER diagram support tool officially.

#python #orm #ponyORM #happyLearning #happycoding