About DataStax DevCenter

About this document 

DataStax DevCenter is compatible with DataStax Enterprise (DSE) versions up to 5.0.

Welcome to the DataStax DevCenter documentation. To ensure that you get the best experience in using this document, take a moment to look at the Tips for using DataStax documentation.

The landing pages provide information about supported platforms, product compatibility, planning and testing cluster deployments, recommended production settings, troubleshooting, third-party software, resources for additional information, administrator and developer topics, and earlier documentation.

About DataStax DevCenter 

DataStax DevCenter is a free visual schema and query IDE for developers, administrators, and others who want to create and run Cassandra Query Language (CQL) statements against Apache Cassandra and DataStax Enterprise. Users can quickly add and create new connections, import previously saved queries, and navigate database instances. Tabbed editors allow administrators to work on multiple database sessions at a time and compare results.

Features in 1.6 

• Export Keyspace wizard
• Export results to file as CSV or INSERT statements
• New data collected: Cassandra version, DataStax Enterprise version and workload
• Data formatting:
  • numeric data
  • timestamps
  • Paging for large results

Features in 1.5 

• Support for Cassandra 3.0 features:
  • New, Edit, Clone, and Drop Materialized View wizards
  • Multiple secondary indexes
  • Syntax highlighting, code snippets and code assist support for materialized views in the CQL editor
• Schema Navigator improvements:
  • Materialized View nodes are displayed both under their corresponding keyspace and also under their base table
  • Maintains the state of expanded nodes and also the position on a refresh
  • Displays only those schema elements supported by the version of Cassandra in the cluster
• Drop schema objects:
  • Added wizards for dropping User-defined Functions and User-defined Aggregates
  • The drop action checks for dependent objects (for example, dropping a table checks for materialized views, dropping a User-defined type checks for table and User-defined types, dropping a User-defined function checks for User-defined aggregates)
• Improved timestamp formatting used in the Query Results and Detailed Results views; the new format is yyyy-MM-dd hh:mm:ssZ
• Editor and Wizard support in Cassandra 3.0 for new compression options class and chunk_length_in_kb, and for crc_check_chance as a table-level property
• Ability to enable or disable the Query Trace feature
• Improved content assist proposals for caching, compaction, compressions and clustering properties for ATLER TABLE statements
• Authentication against DataStax Enterprise clusters configured to use LDAP has been tested with the following LDAP providers: OpenLDAP, OracleLDAP, WinAD08, or WinAD12
• Help links in wizards use the underlying connection details to link to the version-specific documentation pages

Features in DevCenter 1.4.1 

• Improved Index name validation for Cassandra 1.2 and 2.0
• Improved content assist and validation for DROP FUNCTION statement
• New usage data metrics: DevCenter version, Java version, and OS version

Features in DevCenter 1.4 

• New wizards
  • New Index wizard: allows you to create an index on a column
  • New User-defined Type wizards: allows you to create, edit, and clone your UDTs by using interactive wizards
• Support for Apache Cassandra 2.2 features:
  • Advanced JSON support in the editor and a new Results viewer
  • User-defined functions (UDF) and aggregates (UDA)
  • New data types: date, time, smallint, and tinyint
  • Role-based authentication CQL statements
  • Secondary index support for map key-value pairs with CREATE INDEX ... ENTRIES
• Ability to drop database objects from the Schema Navigator
• An enhanced Results panel with a Details data viewer, including TTL and write-time data
• Ability to specify the consistency level when executing queries
• Automatic update notifications when new DevCenter versions become available
• Collection and sending of anonymous usage data

Features in DevCenter 1.3.1 

• Support for Cassandra 2.1.3 CQL features:
  • Frozen collections including nested collections and FULL collection indexes.
  • Inclusion of IF EXISTS for UPDATE statements.
• Editor and wizard support for the DateTieredCompactionStrategy.
• Additional table options available in the Create and Edit Table wizard:
  • default_time_to_live
  • gc_grace_seconds
  • index_interval
  • min_index_interval
  • max_index_interval
  • memtable_flush_period_in_ms
  • populate_io_cache_on_flush
  • speculative_retry

Features in DevCenter 1.3.0 

• Execute (single or multiple) selected statement(s)
• Wizards
  • Keyspace wizard
  • Table wizard
• A feedback form has been added

Features in DevCenter 1.2.1 

• New features
  • Prevent execution of CQL scripts containing syntax errors
  • Copy as INSERT now supports collections of UDTs or Tuples
• Bug fixes
  • Fix issue on Mac OS/X Yosemite which caused first row of results and query trace table to be hidden
  • Fix NPE appearing in log file on some content assist actions

Features in DevCenter 1.2 

• Full support for Cassandra 2.1, including:
  • user-defined types (UDTs)
  • tuples
  • IF EXISTS
• Syntax highlighting, representation in Results tab and Schema navigator, validation, content assist, and code snippets for UDTs and tuples
• A new Query Trace tab, located next to the Results tab, which displays detailed trace event data for the last executed query to aid in understanding query execution and performance
• An improved New Connection wizard for creating and managing Cassandra connections

Features in DevCenter 1.1 

• Support for Apache Cassandra 2.0.x and DataStax Enterprise 4.0.x (lightweight transactions syntax, static columns, uuid(), now, etc.)
• New and improved validation and code-assist rules
• Option to use a default keyspace for running a script
• Option to set the maximum number of rows to be returned by a statement
• Copy selected or all results as CSV or CQL inserts
• Option to enabled SSL connection
• See the posting on the DataStax Developer Blog about the DevCenter 1.1 feature set

Features in DevCenter 1.0 

• A smart CQL editor that provides
  • syntax highlighting
  • code auto-completion (both keyword and snippet)
  • real-time script validation against the current connection
• Schema explorer view for browsing
  • keyspaces
  • tables
  • other database objects
• Outline view for allowing quick navigating long CQL scripts
• Configuring connections to Cassandra or DataStax Enterprise clusters requiring authorization