Cassandra Database Cheatsheet

Cassandra is a highly scalable and distributed NoSQL database that is designed to handle large amounts of data across multiple commodity servers, providing high availability and fault tolerance. Whether you are a beginner or an experienced developer, having a cheatsheet handy can be incredibly useful for quick reference. In this blog post, we’ll provide you with a Cassandra Database cheatsheet, organized with helpful headings and code snippets.

Getting Started

1. Installation

# Download and install Cassandra
brew install cassandra

# Start Cassandra service
brew services start cassandra

2. Accessing the Cassandra Shell

# Connect to the Cassandra shell
cqlsh

Basic Operations

3. Keyspace Operations

Creating a Keyspace

CREATE KEYSPACE my_keyspace
WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 3};

Switching to a Keyspace

USE my_keyspace;

Listing Keyspaces

DESCRIBE keyspaces;

4. Table Operations

Creating a Table

CREATE TABLE users (
   user_id UUID PRIMARY KEY,
   username TEXT,
   email TEXT
);

Inserting Data

INSERT INTO users (user_id, username, email)
VALUES (uuid(), 'john_doe', '[email protected]');

Querying Data

SELECT * FROM users WHERE user_id = uuid();

5. Updating and Deleting Data

Updating Data

UPDATE users SET email = '[email protected]' WHERE user_id = uuid();

Deleting Data

DELETE FROM users WHERE user_id = uuid();

Advanced Operations

6. Secondary Index

Creating a Secondary Index

CREATE INDEX idx_username ON users (username);

7. Batch Statements

Using Batch Statements

BEGIN BATCH
  INSERT INTO users (user_id, username, email) VALUES (uuid(), 'user1', '[email protected]');
  UPDATE users SET email = '[email protected]' WHERE user_id = uuid();
APPLY BATCH;

8. Data Consistency

Setting Consistency Level

CONSISTENCY QUORUM;

9. Working with Collections

Using Lists

CREATE TABLE shopping_cart (
   user_id UUID PRIMARY KEY,
   items LIST<TEXT>
);

Using Sets

CREATE TABLE tags (
   article_id UUID PRIMARY KEY,
   tag_set SET<TEXT>
);

10. CQL Tracing

Enabling Tracing for a Query

TRACING ON;

Viewing Tracing Results

SHOW SESSION Tracing;

This Cassandra Database cheatsheet serves as a quick reference guide for common operations when working with Cassandra. Whether you’re setting up keyspaces, creating tables, or performing more advanced tasks, having these snippets at your fingertips can save you time and streamline your development process. Keep this cheatsheet handy, and feel free to customize it based on your specific use cases and requirements.

FAQ