Actually Pony can transform subqueries into JOINs in most of the cases. But when it translates the 'in' operator of a generator expression, it produces a subquery with 'IN', because otherwise the programmer can be…
There is no need to wrap it with a query. You can just add a filter: mynewquery = myquery.filter(lambda c: c.name > 'G') The new query will produce the following SQL: SELECT `c`.`id` FROM `customer` `c` LEFT JOIN…
Hi Mike, Pony had the ability to produce JOINs from the very beginning, but during that presentation we found that Pony produced subqueries for MySQL and that was not very performant, correct. Since than we've improved…
Actually we named our project aprox two years before Django Pony mascot image appeared.
Hi, I am one of Pony ORM authors. The idea of Pony ORM is to provide a Pythonic way to work with the database. We think that the generator syntax is very concise and convenient. It is named Pony because a pony is a…
Thank you, will check this out.
Pure in this case means that you can use Python syntax in order to query a database. This way a database query looks identical to an iteration over a list of Python objects.
Thanks for pointing this out, we are working on the licensing part now. We are not going to put anyone at risk of the licence misuse. Eventually we are going to have a multiple licensing model allow using Pony ORM for…
Pony gets the code object from a generator, decompiles it to a Python AST and then translates it to a SQL abstract tree.
I'm Alexey Malashkevich, one of the Pony ORM authors. For now Pony ORM runs on CPython only because there is no access to frames in other implementations. "Pure Python" means that you can write queries in term of…
Thank you for pointing this out, will check this out
Actually Pony can transform subqueries into JOINs in most of the cases. But when it translates the 'in' operator of a generator expression, it produces a subquery with 'IN', because otherwise the programmer can be…
There is no need to wrap it with a query. You can just add a filter: mynewquery = myquery.filter(lambda c: c.name > 'G') The new query will produce the following SQL: SELECT `c`.`id` FROM `customer` `c` LEFT JOIN…
Hi Mike, Pony had the ability to produce JOINs from the very beginning, but during that presentation we found that Pony produced subqueries for MySQL and that was not very performant, correct. Since than we've improved…
Actually we named our project aprox two years before Django Pony mascot image appeared.
Hi, I am one of Pony ORM authors. The idea of Pony ORM is to provide a Pythonic way to work with the database. We think that the generator syntax is very concise and convenient. It is named Pony because a pony is a…
Thank you, will check this out.
Pure in this case means that you can use Python syntax in order to query a database. This way a database query looks identical to an iteration over a list of Python objects.
Thanks for pointing this out, we are working on the licensing part now. We are not going to put anyone at risk of the licence misuse. Eventually we are going to have a multiple licensing model allow using Pony ORM for…
Pony gets the code object from a generator, decompiles it to a Python AST and then translates it to a SQL abstract tree.
I'm Alexey Malashkevich, one of the Pony ORM authors. For now Pony ORM runs on CPython only because there is no access to frames in other implementations. "Pure Python" means that you can write queries in term of…
Thank you for pointing this out, will check this out