Skip to content

Latest commit

 

History

History
75 lines (52 loc) · 1.52 KB

README.md

File metadata and controls

75 lines (52 loc) · 1.52 KB
Raw

cql-ui

cql-ui is a web-based interface for interacting with CQL databases like Cassandra or ScyllaDB.

CQL-UI Screenshot

Getting Started

Prerequisites

  • Node.js
  • CQL Database

Server

  1. Install server dependencies:

    cd ./cassandra-server
npm install

  2. Start the server

    SERVER_PORT=7777 NODE_CONTACT_POINT=172.18.0.7 LOCAL_DATA_CENTER=datacenter1 node server.js

    Replace 172.18.0.7 with the actual contact point IP address of your NoSQL database cluster.

Client

  1. Install client dependencies

    cd ./cql-ui
npm install

  2. Start the client

    REACT_APP_MIDDLEWARE_HOST=http://127.0.0.1:7777 npm start

    This will start the cql-ui client on your local development server. Make sure the host flag points to the previously created server.

Usage

  1. Open your web browser and navigate to http://localhost:3000.
  2. Choose the keyspace
  3. Choose the table
  4. Start editing
  • Press "Save" to save the changes
  • Press "Add" to add a new editable row
  • Press "Discard" to discard all changes made to a table

Possibilities

  • Can choose keyspaces
  • Can choose tables
  • Can CRUD existing tables (Create, Read, Update, Delete data)
  • Can filter data by fields
  • Performs operations as a single transaction
  • Displays errors

Limitations

  • Cannot create tables
  • Cannot create indexes
  • Cannot paginate data
  • Cannot order data
  • Cannot create backups
  • Cannot scale databases
  • Cannot monitor the database