Illustration Image

Cassandra.Link

The best knowledge base on Apache Cassandra®

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

10/21/2018

Reading time:1 min

Kindrat/cassandra-client

by John Doe

This client is intended to be a simple GUI solution to work with cassandra 3.What it already can: connect to cassandra load and show tables show table DDL show table data (simple editable table view with header) apply composite filters to loaded data execute query lazy data load/pagination add/delete tables validation in filter values safe mode with manual commit-reset add/save connections select driver load driver files packagingRequirementsInstall JDK8 (Oracle, OpenJDK)Set JAVA_HOME env variable docIf you are using OpenJDK, make sure to have installed openjfx.Build and runClone the source if you haven't done so. git clone https://github.com/Kindrat/cassandra-client.gitGo to the directory: cd cassandra-clientBuild sources using gradle (add -x test to provided cli command to skip tests):3.1 For Windows ./gradlew.bat build3.2 For Unix ./gradlew buildRun client java -jar build/libs/cassadra-client-1.0.2.jar or from gradle ./gradlew bootRunEditor windowOn selecting table data from context menu in table list all rows are loaded from cassandrathat is quite dangerous when having millions of entries in single table. Lazy loading andpagination is planned but not implemented yet. On cell edit updated row is immediately sent to cassandra - I'm planning to add safe modeby executing DB queries only on commit button click with ability to reset all local uncommitedchanges.Available filtersType of cassandra column is respected. String value from filter is converted to sametype using cassandra driver codecs and column metadata. Filters are combined withAND OR keywords and parentheses brackets.var1 = val1 AND var2 <= val2 OR (var1 != val2 AND var5 LIKE .*test_value{1,2}.*)equal checkfield = valuenot equalfield != valueless or equalfield <= valueless thanfield < valuegreater or equalfield >= valuegreater thanfield > valuestring REGEX checkfield LIKE valuevalue should represent Java Pattern-style regexGUIMain windowConnectList tablesShow DDLShow data

Illustration Image

This client is intended to be a simple GUI solution to work with cassandra 3.

CodeFactor Build Status codecov Known Vulnerabilities

What it already can:

  • connect to cassandra
  • load and show tables
  • show table DDL
  • show table data (simple editable table view with header)
  • apply composite filters to loaded data
  • execute query
  • lazy data load/pagination
  • add/delete tables
  • validation in filter values
  • safe mode with manual commit-reset
  • add/save connections
  • select driver
  • load driver files
  • packaging

Requirements

  • Install JDK8 (Oracle, OpenJDK)
  • Set JAVA_HOME env variable doc
  • If you are using OpenJDK, make sure to have installed openjfx.

Build and run

  1. Clone the source if you haven't done so. git clone https://github.com/Kindrat/cassandra-client.git

  2. Go to the directory: cd cassandra-client

  3. Build sources using gradle (add -x test to provided cli command to skip tests):

    3.1 For Windows ./gradlew.bat build

    3.2 For Unix ./gradlew build

  4. Run client java -jar build/libs/cassadra-client-1.0.2.jar or from gradle ./gradlew bootRun

Editor window

On selecting table data from context menu in table list all rows are loaded from cassandra that is quite dangerous when having millions of entries in single table. Lazy loading and pagination is planned but not implemented yet.
On cell edit updated row is immediately sent to cassandra - I'm planning to add safe mode by executing DB queries only on commit button click with ability to reset all local uncommited changes.

Available filters

Type of cassandra column is respected. String value from filter is converted to same type using cassandra driver codecs and column metadata. Filters are combined with AND OR keywords and parentheses brackets.

var1 = val1 AND var2 <= val2 OR (var1 != val2 AND var5 LIKE .*test_value{1,2}.*)
  • equal check
    field = value

  • not equal
    field != value

  • less or equal
    field <= value

  • less than
    field < value

  • greater or equal
    field >= value

  • greater than
    field > value

  • string REGEX check
    field LIKE value
    value should represent Java Pattern-style regex

GUI

Main window

main window

Connect

connect popup

List tables

list tables

Show DDL

show DDL

Show data

show DDL

Related Articles

data.modeling
open.source
cassandra

johnnywidth/cql-calculator

John Doe

6/17/2020

cassandra
tool

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

interface