connecting to cassandra from PHP [closed]

Question

I have found lots of questions on here and other sites about what php libraries to use for connecting to cassandra but most of the questions are 1 or more years old.

I have also found lots of different libraries for connecting to cassandra but most of those have not been committed to for over 2 years.

The PDO php library https://code.google.com/a/apache-extras.org/p/cassandra-pdo seems to be the one most talked about but again this has had 0 changes since 2012.

So my question is what are people using and why?

Ive also seen this http://evseevnn.github.io/php-cassandra-binary which at first glance to me looks pretty promasing but it is really new and iam worried it may not be supported in the long term as appears to be the case with lots of others.

Answer 1

Here's the full list:

Simple Cassie - SimpleCassie is entirely stand-alone package which wrap itself around Thrift libs This Library hasn't had any commits in a while.

Pandra - Pandra is a light-weight PHP based CRUD layer for the Cassandra distributed datastore. Seems inactive since early 2012

PHPCassa - PHPcassa is a PHP client library for Apache Cassandra. Very active, I'd recommend this library since one of the DataStax developers is maintaining it.

Cassandra PHP Client Library - Cassandra PHP Client Library allows for managing and querying your Cassandra cluster. Inactive since late 2013

CQL | PHP - A CQL (Cassandra Query Language) driver for PHP using PDO.

CQLSÍ - A simple interface, a wrapper, for working with CQL from PHP without Thrift. Last activity was early 2014

Orange-OpenSource/YACassandraPDO - PDO driver for Cassandra CQL. Also highly active, last commit was today.

PHP Library for Cassandra - PHP library for use Cassandra database via a binary protocol. This is the library you listed, highly active.

php-cassandra - A PHP driver for Cassandra.Works exclusively with CQL3 and Cassandra's binary protocol. Very recent commits, but the library itself is very new

Based on this list it'd say your prime choices are PHPCassa which has the advantage of being highly active, Orange-OpenSource/YACassandraPDO which is a mature and active project but as stated support for cassandra-2.0 is experimental and 2.1 isn't mentioned at all, or the other two projects which are less mature but recent and active.

Answer 2

Better late than never.

Datastax have finally come up their php-cassandra driver

It is still beta but you can rely on them for further updates.

I was using Orange-OpenSource/YACassandraPDO for the past 6months. Fairly good. Might replace this with datastax driver in future.