Cassandra

From DreamFactory
Jump to: navigation, search
(Created page with "Cassandra is one of the popular NoSQL databases that comes with DreamFactory OpenSource. The Cassandra service type can connect to local or remote Cassandra servers. ==Common...")
(No difference)

Revision as of 17:29, 8 August 2016

Cassandra is one of the popular NoSQL databases that comes with DreamFactory OpenSource. The Cassandra service type can connect to local or remote Cassandra servers.

Common Feature Exceptions

  • Unlike some other NoSQL databases, Cassandra has defined schema for tables. Therefore, the _schema resource works like a SQL DB service.
  • Cassandra supports filtering in CQL. Therefore, DreamFactory also supports that using the filter parameter like a SQL DB service.

Requirements

  • PHP extension cassandra and C/C++ driver from DataStax is required to be installed or compiled in. Check [[1]] for installation help.

Configuration

  • Host - String. Required. IP Address/Hostname of your Cassandra node. Note that you don’t have to specify the addresses of all hosts in your cluster. Once the driver has established a connection to any host, it will perform auto-discovery and connect to all hosts in the cluster.
  • Port - Integer. Optional. Cassandra server port number. Defaults to 9042.
  • Username - String. Optional. If your Cassandra server requires authentication. Then provide Username here.
  • Password - String. Optional. If your Cassandra server requires authentication. Then provide Password here.
  • Options - Object/Associative array. Optional. An array of options for the Cassandra connection. Available options are - ssl : boolean, server_cert_path : string, client_cert_path : string, private_Key_path : string, key_pass_phrase : string