Developing with Cassandra

ACID Transactions — ACID transactions across partitions with BEGIN TRANSACTION / COMMIT

Schema Constraints — Enforce data integrity rules at the database level

Vector Search — Experimental ANN search with vector embeddings and SAI indexes for AI/ML applications

New CQL operators — BETWEEN, NOT, and LIKE for more expressive queries

SAI on frozen collections — Storage-attached indexes now support frozen collection types

Slow-query virtual table — Monitor slow queries directly from CQL

Client Drivers

Data Modeling Overview — Cassandra 6 patterns for Accord transactions and schema constraints

Coming from SQL / RDBMS

Query-Driven Design

CQL Overview

Definitions

Data Types

Data Definition (DDL)

Data Manipulation (DML)

Functions

CQL Security

Constraints

Triggers

BEGIN TRANSACTION Reference

Vector Search Overview — VECTOR type, SAI ANN indexes, and application patterns (RAG, semantic search, recommendations)

Vector Search Quickstart

SAI Concepts — the index engine powering vector search

Application Patterns

Developer Troubleshooting

Choosing Consistency Levels — pick the right consistency for your use case

Time-Series Modeling — partition bucketing, TTL, and TWCS

Paginating Query Results — safe pagination patterns

Retries and Idempotence — retry safely in distributed systems

Adopting ACID Transactions — multi-partition atomic operations

SAI Usage Patterns — when and how to use Cassandra’s recommended secondary indexes

Schema Migrations — evolving your schema safely

Code Examples — complete examples in Java, Python, and CQL