Cassandra PHP接口与CQL可用/计划?

我正在尝试计划应该使用noSQL解决方案的Web应用程序 - Cassandra似乎是一个很好的解决方案。 我看到有PHP库可以像phpCassa那样操作数据库。
另外我看到新版本的Cassandra 0.8引入了查询语言CQL。
是否有使用CQL的php接口? 使用CQL有什么好处? 这只是一种类似sql的查询方式吗?</ p>

谢谢!</ p>
</ div>



I'm trying to plan a web application that should use a noSQL solution - Cassandra seems to be a good solution. I saw there are libraries for PHP to manipulate the database like phpCassa. Also I saw the new version of Cassandra 0.8 is introducing a query language CQL. Are there php interfaces that use the CQL? What is the benefit using the CQL? Is it just a more sql-like way to make queries?

Thank you!


虽然还没有驱动程序 可用它不会阻止你使用CQL,驱动程序都将成为thrift方法“execute_cql_query”的包装器(直到创建一个新的传输)。</ p>

这意味着你 可以简单地为PHP编译thrift或从更新的项目中获取它,然后将您的cql查询传递给该方法。 它确实意味着手动处理驱动程序将要/应该处理的事情。</ p>

“它只是一种类似于sql的方式来进行查询吗?”,基本上......是的。 Cassandra邮件列表中提到的一件事就是让CQL尽可能地像SQL一样。</ p>

“使用CQL有什么好处?” 好吧,主要是一些新的Cassandra用户发现节俭API很难掌握,CQL可能更容易学习,因为它非常接近“普通”sql。</ p>
</ div>



The link Greg posted above is to date the working repo and state of the php-cql driver efforts. While a driver is not yet available it does not stop you from using CQL, the drivers are all going to be a wrapper of the thrift method "execute_cql_query" (Until a new transport is created anyway).

That means you can simply compile thrift for php or get it from an updated project and then pass your cql query to that method. It does mean manual handling of things that a driver will/should take care of.

"Is it just a more sql-like way to make queries?", basically...yes. One of the things that came up on the Cassandra mailing list was getting CQL to be as SQL-Like as possible.

"What is the benefit using the CQL?" Well, mainly that some new Cassandra users find the thrift API tedious to get to grips with, CQL may be much easier to learn since its is so close to the "normal" sql.

https:/ / </ p>

我也相信phpCassa也应该支持它。</ p>

它的设计目的是 使来自SQL作为数据库引擎的人更合乎逻辑。</ p>
</ div>



I also believe that phpCassa should support it as well.

It's designed to make NoSQL more logical for people coming from SQL as a database engine.

如果您希望使用CQL通过PHP与Cassandra进行通信,这将非常有用</ p> </ p>

这是zcourts在上一篇文章中提到的样本</ p>

Tamil </ p>
</ div>



This will really be helpful if you wish to use CQL to communicate with Cassandra via PHP

This is a sample of what zcourts mentioned in his previous post

Regards, Tamil

我相信Apache Cassandra项目支持的官方CQL驱动程序都在Apache Extras上,在此链接:</ p>

http: // </ p>

PHP版位于</ p> \ n。 com / a / / p / cassandra-pdo / </ p>
</ div>



The official CQL drivers supported by the Apache Cassandra project at large are, I believe, all on Apache Extras, at this link:

The PHP one is at

通过Thrift连接已弃用。</ p>

我正在使用通过二进制协议为Cassandra数据库提供的PHP库。 </ p>
</ div>



Connection via Thrift deprecated.

I am using PHP library for Cassandra database via a binary protocol.

Csdn user default icon