title: Choosing python client lib for Cassandra
body: <p>I have worked with Pycassa before and wrote a wrapper to use batch mutation &amp; connection pooling etc. But <a href="http://wiki.apache.org/cassandra/ClientOptions" rel="nofollow">http://wiki.apache.org/cassandra/ClientOptions</a> recommends now to use CQL 3 based api because Thrift based api (Pycassa) will be supported for backward compatibility only. Apache site recommends to use Python api written by DataStax which is still in Beta (As per their documentation). See warnings from their python-driver/README.rst file</p>
  
  <p><strong>Warning</strong>                                                                </p>
  
  <p>This driver is currently under heavy development, so the API and layout of packages,modules, classes, and functions are subject to change. There may also be serious bugs, so usage in a production environment is <em>not</em> recommended at this time.                                            </p>
  
  <p>DataStax site <a href="http://www.datastax.com/download/clientdrivers" rel="nofollow">http://www.datastax.com/download/clientdrivers</a> recommends using DB-API 2.0 plus legacy api's. Is there more? Has any one compared between CQL 3 based apis? Which stands out on top? Answers based on facts will help the community so please refrain from opinions.</p>