DataStax Developer Blog

DevCenter 1.1.0 adds support for Apache Cassandra 2.0 and DataStax Enterprise 4.0

By Alex Popescu -  May 2, 2014 | 7 Comments

It took us quite a bit longer to get here, but now we’re ready to share a new version of DevCenter which comes with a couple of most requested features and UI changes, lots of code assist and validation improvements, and some major backend changes.

While you download the new release, let’s take a quick look at what’s new in DevCenter 1.1.0.

Full CQL support for Cassandra 2.0

DevCenter 1.1.0 adds support for the CQL version that comes with Apache Cassandra 2.0. This includes support for the lightweight transaction IF EXISTS syntax, the new STATIC column type, and more CQL functions (e.g. uuid(), now(), and 'now'). With this, DevCenter supports now all flavors of CQL starting with Cassandra 1.2 and up to Cassandra 2.0.7.

Lightweight transactions CQL

The new version of DevCenter is using the DataStax Java driver version 2.0.x thus making it possible to connect to a wide range of Cassandra (all 1.2 and 2.0.x releases) and DataStax Enterprise versions (all releases starting with 3.1 and up to the latest in the 4.0 series).

More and improved validations and code assist rules

One of the most interesting productivity features in DevCenter is its ability to validate CQL in real-time without the need to actually execute the statements. The way it does this is by enabling a specific version of the CQL grammar corresponding to the active connection and triggering only those validations and assist rules that apply. Here’s a quick example:

Code assist and validation for CQL STATIC columns

With DevCenter we’ve expanded the set of validations and assist rules including obvious suggestions like using IF NOT EXISTS for keyspace, table, or index creation and also some more advanced ones like signaling an error for inserting into a counter table or the options passed to a CREATE TABLE WITH.

Copy as CSV and CQL

In DevCenter 1.1.0 we’ve added the option to copy a selection or all the results of a query as either CSV or CQL INSERT statements. The CSV format conforms to the format used by cqlsh COPY command so you can reimport this sample data. Or you can run the set of INSERTs using cqlsh -f copied_rows.cql.

Copy-as-CSV-or-CQL

Other new features

At the top of the CQL editor we’ve added the option to configure a default keyspace and also the default number of rows to be returned by a statement.

On the dialog for creating or editing connections we’ve added additional configuration options that will allow setting up compression (Snappy or LZ4), authentication details, and even setting up SSL without the pain of passing in the truststore details through environment variables.

Before closing, I thought I should share one last feature that I find to be very useful when working with many CQL scripts: code formatting. If you open a script or paste some CQL statements into the editor, you can then format the CQL code by using the shortcut Cmd+Shift+f (Mac). You can also find this action in the contextual right-click menu.

You can download the new DevCenter version for Windows, Mac, and Linux from here. We would love to hear your feedback devcenter-feedback@datastax.com!



Comments

  1. sanjay says:

    Thanks a Million, This makes developers life easy and more love for Cassandra!!

  2. Patrice says:

    Good job !! just what developpers where waiting for !!

  3. Rahul Gupta says:

    This tool is great. I have been using DevCenter 1.0 for some time, 1.1.0 is a great improvement.
    However I am unable to use it completely because it doesn’t work if keyspace name has upper case.

    I many many such keyspaces (for example: “META”), DevCenter 1.1.0 keeps looking for meta. Older feature of use “META”; doesn’t help either.

    1. Alex Popescu says:

      Thanks for the report Rahul. We’ll be looking into this issue.

  4. Cool; itz a great tool for developers’ community. Great Job!

  5. Ganeshkumar says:

    I was using DevCenter 1.1 version

    later I have installed Datastax cassandra sharp drivers in my machine (Installed thru Nuget)

    After that DevCenter is not working

    Pls advise what needs to be done?

    1. Alex Popescu says:

      Hi Ganeshkumar,

      The C# driver should not interfere in any ways with DevCenter so the cause of this problem is probably somewhere else.

      Could you please drop us an email (devcenter-feedback@datastax.com or directly to me alexp@datastax.com) to look into this?

      thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>