Re: Choosing python client lib for Cassandra

2013-11-26 Thread Kumar Ranjan
Thanks Jonathan for the help. On Tue, Nov 26, 2013 at 6:14 PM, Jonathan Haddad wrote: > No, 2.7 only. > > > On Tue, Nov 26, 2013 at 3:04 PM, Kumar Ranjan wrote: > >> Hi Jonathan - Does cqlengine have support for python 2.6 ? >> >> >> On Tue, Nov 26, 2013 at 4:17 PM, Jonathan Haddad wrote: >> >>

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Jonathan Haddad
No, 2.7 only. On Tue, Nov 26, 2013 at 3:04 PM, Kumar Ranjan wrote: > Hi Jonathan - Does cqlengine have support for python 2.6 ? > > > On Tue, Nov 26, 2013 at 4:17 PM, Jonathan Haddad wrote: > >> cqlengine supports batch queries, see the docs here: >> http://cqlengine.readthedocs.org/en/latest/t

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Kumar Ranjan
Hi Jonathan - Does cqlengine have support for python 2.6 ? On Tue, Nov 26, 2013 at 4:17 PM, Jonathan Haddad wrote: > cqlengine supports batch queries, see the docs here: > http://cqlengine.readthedocs.org/en/latest/topics/queryset.html#batch-queries > > > On Tue, Nov 26, 2013 at 11:53 AM, Kumar

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Jonathan Haddad
cqlengine supports batch queries, see the docs here: http://cqlengine.readthedocs.org/en/latest/topics/queryset.html#batch-queries On Tue, Nov 26, 2013 at 11:53 AM, Kumar Ranjan wrote: > Jon - Any comment on batching? > — > Sent from Mailbox for iPhone > > > On

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Robert Coli
On Tue, Nov 26, 2013 at 11:46 AM, Kumar Ranjan wrote: > How do you insert huge amount of data? > http://www.palominodb.com/blog/2012/09/25/bulk-loading-options-cassandra ? =Rob

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Kumar Ranjan
Jon - Any comment on batching? — Sent from Mailbox for iPhone On Tue, Nov 26, 2013 at 2:52 PM, Laing, Michael wrote: > That's not a problem we have faced yet. > On Tue, Nov 26, 2013 at 2:46 PM, Kumar Ranjan wrote: >> How do you insert huge amount of data? >> — >> Sent from Mailbox

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Laing, Michael
That's not a problem we have faced yet. On Tue, Nov 26, 2013 at 2:46 PM, Kumar Ranjan wrote: > How do you insert huge amount of data? > — > Sent from Mailbox for iPhone > > > On Tue, Nov 26, 2013 at 2:31 PM, Laing, Michael > wrote: > >> I think thread pooling

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Kumar Ranjan
How do you insert huge amount of data? — Sent from Mailbox for iPhone On Tue, Nov 26, 2013 at 2:31 PM, Laing, Michael wrote: > I think thread pooling is always in operation - and we haven't seen any > problems in that regard going to the 6 local nodes each client connects to. > We haven't tried

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Kumar Ranjan
Hi Jon - you are right. Its that I understand other ORM like python sqlalchemy or perl DBIX by heart. So i can cql faster than use cqlengine. I will give a shot at python-driver based on Michael's recommendation. — Sent from Mailbox for iPhone On Tue, Nov 26, 2013 at 2:21 PM, Jonathan Haddad w

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Laing, Michael
I think thread pooling is always in operation - and we haven't seen any problems in that regard going to the 6 local nodes each client connects to. We haven't tried batching yet. On Tue, Nov 26, 2013 at 2:05 PM, Kumar Ranjan wrote: > Michael - thanks. Have you tried batching and thread pooling

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Robert Coli
On Tue, Nov 26, 2013 at 9:46 AM, Kumar Ranjan wrote: > I have worked with Pycassa before and wrote a wrapper to use batch > mutation & connection pooling etc. But > http://wiki.apache.org/cassandra/ClientOptions recommends now to use CQL > 3 based api because Thrift based api (Pycassa) will be su

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Jonathan Haddad
We're currently using the "cql" package, which is really a wrapper around thrift. To your concern about deadlines, I'm not sure how writing raw CQL is going to be any faster than using a mapper library for anything other than the most trivial of project. On Tue, Nov 26, 2013 at 11:09 AM, Kumar

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Kumar Ranjan
Jon - Thanks. As I understand, cqlengine is an object mapper and must be using for cql prepare statements. What are you wrapping it with, in alternative to python-driver?  — Sent from Mailbox for iPhone On Tue, Nov 26, 2013 at 1:19 PM, Jonathan Haddad wrote: > So, for cqlengine (https://githu

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Kumar Ranjan
Michael - thanks. Have you tried batching and thread pooling in python-driver? For now, i would avoid object mapper cqlengine, just because of my deadlines. — Sent from Mailbox for iPhone On Tue, Nov 26, 2013 at 1:52 PM, Laing, Michael wrote: > We use the python-driver and have contributed som

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Laing, Michael
We use the python-driver and have contributed some to its development. I have been careful to not push too fast on features until we need them. For example, we have just started using prepared statements - working well BTW. Next we will employ futures and start to exploit the async nature of new

Re: Choosing python client lib for Cassandra

2013-11-26 Thread Jonathan Haddad
So, for cqlengine (https://github.com/cqlengine/cqlengine), we're currently using the thrift api to execute CQL until the native driver is out of beta. I'm a little biased in recommending it, since I'm one of the primary authors. If you've got cqlengine specific questions, head to the mailing lis

Choosing python client lib for Cassandra

2013-11-26 Thread Kumar Ranjan
I have worked with Pycassa before and wrote a wrapper to use batch mutation & connection pooling etc. But http://wiki.apache.org/cassandra/ClientOptions recommends now to use CQL 3 based api because Thrift based api (Pycassa) will be supported for backward compatibility only. Apache site recommends