DevCenter 1.1.0 adds support for Apache Cassandra 2.0 and DataStax Enterprise 4.0
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.
'now'). With this, DevCenter supports now all flavors of CQL starting with Cassandra 1.2 and up to Cassandra 2.0.7.
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:
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
COPY command so you can reimport this sample data. Or you can run the set of
cqlsh -f copied_rows.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.