Re: [Python-ideas] Query Language extension to Python

2016-11-02 Thread Pavel Velikhov
> 3 нояб. 2016 г., в 0:28, Denis Akhiyarov > написал(а): > > How does this compare to LINQ in .NET? Denis, PythonQL is very similar to LINQ actually. The syntax is a little different - more Pythonic vs SQL, the clauses can be composed arbitrarily, we have named tuples, that make nested q

Re: [Python-ideas] Query Language extension to Python

2016-11-01 Thread Pavel Velikhov
Hi David! I haven’t used blaze, but its looks quite similar to pandas, at least conceptually. Thanks for the reference! The big difference with PythonQL is that we actually extend the syntax of Python with a few constructs that are typically used in query languages (group by, order by, win

Re: [Python-ideas] Query Language extension to Python

2016-11-01 Thread David Mertz
How do you see this as different from Blaze ( http://blaze.readthedocs.io/en/latest/index.html)? A On Nov 1, 2016 1:34 AM, "Pavel Velikhov" wrote: > Hi Folks, > > We have released PythonQL, a query language extension to Python (we have > extended Python’s comprehensions with a full-fledged que

Re: [Python-ideas] Query Language extension to Python

2016-11-01 Thread Wes Turner
On Tuesday, November 1, 2016, Pavel Velikhov wrote: > Hi Wes! > > Right now we don’t push anything yet, we fetch everything into the > Python’s runtime. > But going forward the current idea is to push as much computation to the > database as > possible (most of the time the database will do a b

Re: [Python-ideas] Query Language extension to Python

2016-11-01 Thread Pavel Velikhov
Hi Wes! Right now we don’t push anything yet, we fetch everything into the Python’s runtime. But going forward the current idea is to push as much computation to the database as possible (most of the time the database will do a better job then our engine). If we run on top PySpark/Hadoop I t

Re: [Python-ideas] Query Language extension to Python

2016-11-01 Thread Wes Turner
Cool! https://github.com/pythonql/pythonql/wiki/PythonQL-Intro-and-Tutorial How do I determine how much computation is pushed to the data? (Instead of pulling all the data and running the computation with one local node) ... https://en.wikipedia.org/wiki/Bulk_synchronous_parallel (MapReduce,) -

Re: [Python-ideas] Query Language extension to Python

2016-11-01 Thread Paul Moore
On 1 November 2016 at 08:33, Pavel Velikhov wrote: > We have released PythonQL, a query language extension to Python (we have > extended Python’s comprehensions with a full-fledged query language, > drawing from the useful features of SQL, XQuery and JSONiq). Take a look at > the project here:

[Python-ideas] Query Language extension to Python

2016-11-01 Thread Pavel Velikhov
Hi Folks, We have released PythonQL, a query language extension to Python (we have extended Python’s comprehensions with a full-fledged query language, drawing from the useful features of SQL, XQuery and JSONiq). Take a look at the project here: http://www.pythonql.org and lets us know what yo