Pony

Pony provides an abstraction layer for running database queries directly from Python code.

It allows developer to write complex operations via Python's advanced scripting capabilities and convert the code to valid SQL operations.

The difference between Pony and other Python ORMs is that Pony uses Python generators to query the database.

What is new in this release:

• Use standard transaction mode by default instead of optimistic mode.
• SELECT ... FOR UPDATE support added: select(...).for_update()[:].
• UUID datatype support added.
• Automatic foreign key indexes generation.