amalashkevich

4 ms·

1. 1.▲
   by amalashkevich 12y ago

   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 confus
2. 2.▲
   by amalashkevich 12y ago

   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`
3. 3.▲
   by amalashkevich 12y ago

   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 Pony and now it
4. 4.▲
   by amalashkevich 12y ago

   Actually we named our project aprox two years before Django Pony mascot image appeared.
5. 5.▲
   by amalashkevich 12y ago

   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 small, smart and powerful
6. 6.▲
   by amalashkevich 13y ago

   Thank you, will check this out.
7. 7.▲
   by amalashkevich 13y ago

   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.
8. 8.▲
   by amalashkevich 13y ago

   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 free for non-commercia
9. 9.▲
   by amalashkevich 13y ago

   Pony gets the code object from a generator, decompiles it to a Python AST and then translates it to a SQL abstract tree.
10. 10.▲
    by amalashkevich 13y ago

    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 objects using Python genera
11. 11.▲
    by amalashkevich 13y ago

    Thank you for pointing this out, will check this out