Illustration Image

Cassandra.Link

The best knowledge base on Apache Cassandra®

Helping platform leaders, architects, engineers, and operators build scalable real time data platforms.

7/29/2019

Reading time:2 min

tomekkup/helenos

by John Doe

IntroductionHelenos is a free web based environment that simplifies a data exploring & schema managament with Apache Cassandra database.Features listExploring schemaViewing properties of keyspaces and column familiesAdd / remove / truncate column familyAdd / Drop keyspaceData browsing via:keyRangepredicateResults paginationCQL supportAuthenticationAdmin and read only rolesCurrent version1.5Important: when upgrading to version 1.5 or above please note that you'll lose all your configuration (stored in local sql db). Please read changelog...ChangelogSee here for all changes in current and all previous releasesDownloadPackages are available to download via Sourceforge.net as WAR files and Apache Tomcat bundles.Gallery![CF properties] (https://raw.github.com/tomekkup/helenos/gh-pages/gallery/helenos1_small.png) ![CQL] (https://raw.github.com/tomekkup/helenos/gh-pages/gallery/helenos2_small.png) ![Browse] (https://raw.github.com/tomekkup/helenos/gh-pages/gallery/helenos3_small.png)Click here for preview on YoutubeInstallationMake sure that a user account which your application server runs as, has write permission to home directoryDownload war package and deploy to your servlet container (tested with Jetty 8, Tomcat 6, Resin 4)When running on Resin, additionally make sure that fileServlet is enabled and configured (see web.xml or Resin manual)Start appMake sure your web browser supports Flash 10Open your web browser to http://localhost:8080/{yourdeploypath}/index.htmlSign in with your credentials (default is admin:admin)Edit your connections by clicking icon in upper right cornerAfter editing click button 'Connect to'Building manuallyYou can build manually with Maven but first install all prerequisities:Qooxdoo SDK 2.1.2 [download] (http://sourceforge.net/projects/qooxdoo/)Python 2.x [download] (http://www.python.org/downloads/)Next download this archive: [https://github.com/cboulanger/qx-contrib-Dialog/archive/v1.2.zip] (https://github.com/cboulanger/qx-contrib-Dialog/archive/v1.2.zip)and unpack to directory src/main/frontend/contribs and change destination folder name to 'dialog'. Next apply patch file 'src/main/frontent/Login.js.patch'.Wish listBrowse with indexed columnsResults export to fileManually setting serializersPersisting default filter criteria to reuse at anytimeJMX monitorSchema editingQueries logFAQI see a cluster structure in a left pane but how to do anything more !? - Use the force Luke ...I mean right mouse buttonMy Cassandra instance is not listening on localhost:9160. How to change the CassandraHost after installation ? - put your values into defaults.properties file, then restartAuthorMy name is Tomek Kuprowski and I'm java enthusiast, father, husband and IBMer.You can find me on [LinkedIn] (http://www.linkedin.com/in/tomekkuprowski) and contact via tomekkuprowski@gmail.comLicence and disclaimerHelenos is distributed free, AS-IS, without any warranty under GPL v2 [licence] (http://www.gnu.org/licences/gpl.html)

Illustration Image

Introduction

Helenos is a free web based environment that simplifies a data exploring & schema managament with Apache Cassandra database.

Features list

  • Exploring schema
  • Viewing properties of keyspaces and column families
  • Add / remove / truncate column family
  • Add / Drop keyspace
  • Data browsing via:
    • keyRange
    • predicate
  • Results pagination
  • CQL support
  • Authentication
  • Admin and read only roles

Current version

1.5

Important: when upgrading to version 1.5 or above please note that you'll lose all your configuration (stored in local sql db). Please read changelog...

Changelog

See here for all changes in current and all previous releases

Download

Packages are available to download via Sourceforge.net as WAR files and Apache Tomcat bundles.

Gallery

![CF properties] (https://raw.github.com/tomekkup/helenos/gh-pages/gallery/helenos1_small.png) ![CQL] (https://raw.github.com/tomekkup/helenos/gh-pages/gallery/helenos2_small.png) ![Browse] (https://raw.github.com/tomekkup/helenos/gh-pages/gallery/helenos3_small.png)

Click here for preview on Youtube

Installation

  • Make sure that a user account which your application server runs as, has write permission to home directory
  • Download war package and deploy to your servlet container (tested with Jetty 8, Tomcat 6, Resin 4)
  • When running on Resin, additionally make sure that fileServlet is enabled and configured (see web.xml or Resin manual)
  • Start app
  • Make sure your web browser supports Flash 10
  • Open your web browser to http://localhost:8080/{yourdeploypath}/index.html
  • Sign in with your credentials (default is admin:admin)
  • Edit your connections by clicking icon in upper right corner
  • After editing click button 'Connect to'

Building manually

You can build manually with Maven but first install all prerequisities:

Next download this archive: [https://github.com/cboulanger/qx-contrib-Dialog/archive/v1.2.zip] (https://github.com/cboulanger/qx-contrib-Dialog/archive/v1.2.zip) and unpack to directory src/main/frontend/contribs and change destination folder name to 'dialog'. Next apply patch file 'src/main/frontent/Login.js.patch'.

Wish list

  • Browse with indexed columns
  • Results export to file
  • Manually setting serializers
  • Persisting default filter criteria to reuse at anytime
  • JMX monitor
  • Schema editing
  • Queries log

FAQ

  • I see a cluster structure in a left pane but how to do anything more !? - Use the force Luke ...I mean right mouse button
  • My Cassandra instance is not listening on localhost:9160. How to change the CassandraHost after installation ? - put your values into defaults.properties file, then restart

Author

My name is Tomek Kuprowski and I'm java enthusiast, father, husband and IBMer. You can find me on [LinkedIn] (http://www.linkedin.com/in/tomekkuprowski) and contact via tomekkuprowski@gmail.com

Licence and disclaimer

Helenos is distributed free, AS-IS, without any warranty under GPL v2 [licence] (http://www.gnu.org/licences/gpl.html)

Related Articles

cassandra
tools
sstables

ic-tools for Apache Cassandra SSTables

John Doe

2/17/2023

cassandra
tools

Checkout Planet Cassandra

Claim Your Free Planet Cassandra Contributor T-shirt!

Make your contribution and score a FREE Planet Cassandra Contributor T-Shirt! 
We value our incredible Cassandra community, and we want to express our gratitude by sending an exclusive Planet Cassandra Contributor T-Shirt you can wear with pride.

Join Our Newsletter!

Sign up below to receive email updates and see what's going on with our company

Explore Related Topics

AllKafkaSparkScyllaSStableKubernetesApiGithubGraphQl

Explore Further

cassandra