5

I'm looking for a good driver for python:

1) Pycassa. It doesn't support CQL, and they dont think to do it soon.

2) https://code.google.com/a/apache-extras.org/p/cassandra-dbapi2/.

I thought to use cassandra-dbapi2 but here a guy says that "it doesn't support connection pooling load balance advance features". On the other hand I can use PyCassa but it doesn't support CQL. Should do I try Pycassa and forget about CQL on the client?

I don't care about losing ORM features, actually I think It could be even worse sometimes because its force your team to learn new things (new features on the ORM API which you are using) where as SQL is something that people know. Why learn a new language when you already know SQL/CQL? But It's just an opinion...

What do you think is the best option? Should I forget about CQL?

alasarr
  • 1,565
  • 3
  • 16
  • 32
  • 2
    I'm not asking for an opinion,what I want to know if i should use CQL in cassandra or use cassandra whithout CQL. I've modify the title It was confusing – alasarr Mar 31 '13 at 15:07
  • 4
    These types of questions are incredibly useful. I believe they should be welcomed on Stackoverflow. – Chris Dutrow May 10 '13 at 15:45
  • @alasarr: You're looking for https://github.com/datastax/python-driver. – Matt Joiner Aug 14 '13 at 11:57

1 Answers1

2

Pycassa or CQL supported driver, both are client API's implementing the thrift interface, base API of cassandra, so basically which ever API you choose it will ought to have the same functionality. For every CQL implementation there is an alternative in pycassa but if are really liking pycassa and you still want to mix CQL with it, then you can execute CQL statements through pycassa using the execute_cql thrift call. And you can also check pcmanus / python-cql written by one of the cassandra committer.

abhi
  • 4,762
  • 4
  • 29
  • 49
  • pcmanus / python-cql is the same as cassandra-dbapi2, and it has the pooling issue. Is this so bad? (see the last post in the following forum) http://www.datastax.com/support-forums/topic/when-will-pycassa-support-cql – alasarr Mar 31 '13 at 18:44
  • 1
    if so go with pycassa, and try executing CQL statements using the execute_cql thrift call. In the mean time keep an eye on other API's too, they may come up with resolved pooling issue in their next versions. – abhi Apr 01 '13 at 05:30
  • Can Pycassa connect to a Cassandra 1.2 database? – Chris Dutrow May 10 '13 at 16:00