email iconemail phone iconcall
SHARE THIS PAGE




CATEGORIES



TWEET THIS!

Alex Popescu

Announcing DataStax Studio 2.0, a powerful developer environment for DataStax Enterprise 5.1

By Alex PopescuApril 19, 2017

This is a big week here at DataStax. With many exciting announcements around DataStax Enterprise (DSE) 5.1, OpsCenter 6.1, and new versions of the enterprise drivers. It’s also a big day for DataStax Studio which goes 2.0 🎂.

DataStax Studio debuted last year to enable developers and data scientists to query and explore data with ease, visualize graph data, and create and edit graph schemas for DSE Graph. Today’s release brings a series of improvements for DSE Graph and also introduces support for the Cassandra Query Language (CQL), delivering a single environment for architects, developers, and data scientists for accessing data stored in DataStax Enterprise. Now DSE developers can visually navigate database objects, create complex queries, and tune CQL queries for fast performance all within Studio.

In this post, I’ll walk you quickly through the most exciting new features, but I’d strongly encourage you to download DataStax Studio 2.0 and try it for yourself as it is a product better experienced than described in words.

Writing, executing, displaying, and profiling CQL

At a minimum, supporting CQL could simply mean being able to submit CQL queries and retrieving their results. But that wouldn’t be much different to using `cqlsh`. An application like DataStax Studio can do a lot more to increase your productivity by providing:

  1. Syntax highlighting for making the CQL statements more legible and signaling potential typos
  2. Code completions and code snippets for writing queries faster
  3. Schema-aware content assist for eliminating context switching between writing queries and checking database object names
  4. Validations for helping eliminate errors without requiring execution of the queries
  5. A built-in set of visualizations for results including a grid view, a JSON viewer, and different charts. Additionally, a detailed value viewer which provides access to metadata information (data type, TTL, etc.)
  6. Query profiling for better understanding of how queries are executed in order to optimize their performance

DataStax Studio 2.0 ships with all these features for both CQL and Gremlin.

It would take me a good while to go through all of the above features, so I’ll focus on the three I’m most excited about:

  1. Intelligent code completions
  2. CQL execution profiles
  3. Query profiling

The most intelligent CQL editor

DataStax Studio has deep understanding of both the query language syntax (for both CQL and Gremlin), but also the structure of the database objects: keyspaces, tables, columns, indexes for CQL; vertices, edges, properties for Gremlin. This allows it to provide intelligent contextual code suggestions that include both keywords and database identifiers. This is very similar to the experience of writing code with an advanced IDE like Visual Studio, IntelliJ IDEA, PyCharm, or Eclipse. Additionally, DataStax Studio ships with a set of code snippets that can help you write complicated queries faster and with less errors.

We are planning to publish a subsequent article covering the CQL code editor in more detail.

Execution of CQL statements can be configured using options like consistency level or timeouts. DataStax Studio provides access to such configuration options to allow reproducing specific behaviors. Combining that with the ability to trace these queries, you’ll not only be able to  better understand their behavior but also optimize their performance.

All these features related to CQL support can be found in DataStax Studio 2.0 alongside an accompanying notebook “Working with CQL” which can walk you through each feature.

Customizing DSE Graph Visualizations

DataStax Studio 2.0 includes new features and improvements for working with DSE Graph in two areas:

  1. Improving the information and usability of profiling graph queries
  2. Customizing graph visualizations. Studio 2.0 allows coloring and sizing vertices by label or property value. It also enabled using custom shapes and icons.

We’re also preparing a separate blog post which will dive into the details about these graph visualization improvements.

Download DataStax Studio 2.0

DataStax Studio 2.0 works with DataStax Enterprise 5.0 and 5.1. You can download it now. If you are upgrading from a previous version of Studio, please make sure to check the upgrade notes. We really do love hearing your feedback and suggestions studio-feedback@datastax.com

Interested in learning more about the new capabilities in DSE 5.1 release? Check out our blog here:





SHARE THIS PAGE
SUBSCRIBE

Comments

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