Geek Answers Handbook

Kassandra - Difference Between CLI and CQL

I am new to Kassandra and am learning things. I saw that there are several Cassandra client APIs such as Cassandra CLI , CQL , etc. I need to know what exactly is the difference between CLI and CQL ? Which one is better to use? Also, what client APIs are available to request Cassandra using .NET?

Any help is appreciated.

+4
source share
3 answers

CQL is the SQL language (structured query) used for a Cassandra query. An easy way to use cql is to try the cqlsh tool that comes with Cassandra. CLI is a command line application that can be used to query Cassandra.

There are several popular high-level C # Cassandra APIs, most of which support CQL.

  • Aquiles - Includes examples, but requires some configuration (explained in the wiki )
  • Hector Sharp - Not enough documentation, but thanks to their tests you can decide what to do, and I found this blog with some useful information.
  • Fluent Cassandra - Some configuration is required, but getting started is very well explained in their blog .

Note You can always use the Thrift API, but I would advise him to use it as a low-level implementation and requires a lot of code to do something.

+3
source

Another possible high-level .NET client is cassandra-sharp: https://github.com/pchalamet/cassandra-sharp

In fact, I did not use cassandra. Nevertheless, I was able to get out of Free Kassandra despite great efforts (albeit with some pre-existing knowledge of Kassandra).

+1
source

There is a new library for accessing Cassandra in .NET: https://github.com/reuzel/CqlSharp CqlSharp (like CassandraSharp) implements the new Cassandra binary protocol. The CqlSharp API is very similar to ADO and implemented async from scratch. The wiki has examples of how to use it.

+1
source

More articles:


All Articles