Alexey Malashkevich

Number of videos:
How Pony ORM translates Python generators to SQL queries
EuroPython 2014
Alexey Malashkevich
Recorded: July 24, 2014Language: English

Pony ORM is an Object-Relational Mapper implemented in Python. It uses an unusual approach for writing database queries using Python generators. Pony analyzes the abstract syntax tree of a generator and translates it to its SQL equivalent. The translation process consists of several non-trivial stages. In this talk one of Pony ORM authors will reveal the internal details of this process.

Pony Object-Relational Mapper
PyCon US 2013
Alexey Malashkevich
Recorded: March 17, 2013Language: English

Pony is an object-relational mapper implemented in Python. It allows writing advanced SQL queries using plain Python in the form of a generator expression. This way queries look very concise. Pony implements the IdentityMap pattern, offers a solution for N+1 select problem, and has a visual editor for models.