PHP/PDO driver for Cassandra CQL
--------------------------------
Key: CASSANDRA-3025
URL: https://issues.apache.org/jira/browse/CASSANDRA-3025
Project: Cassandra
Issue Type: New Feature
Components: API
Reporter: Mikko Koppanen
Hello,
attached is the initial version of the PDO driver for Cassandra CQL language.
This is a native PHP extension written in what I would call a combination of C
and C++, due to PHP being C. The thrift API used is the C++.
The API looks roughly following:
{code}
<?php
$db = new PDO('cassandra:host=127.0.0.1;port=9160');
$db->exec ("CREATE KEYSPACE mytest with strategy_class = 'SimpleStrategy' and
strategy_options:replication_factor=1;");
$db->exec ("USE mytest");
$db->exec ("CREATE COLUMNFAMILY users (
my_key varchar PRIMARY KEY,
full_name varchar );");
$stmt = $db->prepare ("INSERT INTO users (my_key, full_name) VALUES (:key,
:full_name);");
$stmt->execute (array (':key' => 'mikko', ':full_name' => 'Mikko K' ));
{code}
Currently prepared statements are emulated on the client side but I understand
that there is a plan to add prepared statements to Cassandra CQL API as well. I
will add this feature in to the extension as soon as they are implemented.
Additional documentation can be found in github
https://github.com/mkoppanen/php-pdo_cassandra, in the form of rendered
MarkDown file. Tests are currently not included in the package file and they
can be found in the github for now as well.
I have created documentation in docbook format as well, but have not yet
rendered it.
Comments and feedback are welcome.
Thanks,
Mikko
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
