node-cassandra-cql

So, let's chat about node-cassandra-cql. This is an awesome open-source software that gives you a CQL driver for the Apache Cassandra CQL3 binary protocol. It's built using Node.js, which is pretty cool. CQL stands for Contextual Query Language, and it's basically the language you use to interact with Apache Cassandra. With this tool, you can easily grab a cell by its column name. For example, you can use row.get('first_name') to get the first name.

CQL Driver Features

One of the best parts? It's written in plain old JavaScript! That means no need to mess around with generating thrift files when you're using node-cassandra-cql. The project supports parameters in queries, bigints, connection pooling across multiple hosts, automatic failover, load balancing, and even UUID support. Plus, it allows field and row streaming!

Getting Started with node-cassandra-cql

If you're ready to dive in, getting this software is super easy. You can grab a universal sources archive from GitHub in either tar or zip format. You'll find the latest nightly source code there too! Just download the latest version from the official website or check it out on Softpedia.

Installation Steps

Once you've downloaded it, just save the archive wherever you'd like and unpack it using your favorite archive manager. Don't forget to check out node-cassandra-cql's homepage. There you'll find loads of detailed info on how to use the API, work with the Connection class, logging features, and data types.

See It In Action!

If you're curious about how node-cassandra-cql works in practice, here's a quick code snippet:

Creating a new connection pool to multiple hosts.

var cql = require('node-cassandra-cql');

var client = new cql.Client({hosts: ['host1', 'host2'], keyspace: 'keyspace1'});

client.execute('SELECT key, email, last_name FROM user_profiles WHERE key=?', ['jbay'],

    function(err, result) {

      if (err) console.log('execute failed');

     else console.log('got user profile with email ' + result.rows[0].email);

    }

);