Use ScyllaDB¶

This section helps developers connect to and work with their ScyllaDB Cloud cluster. It covers application best practices and links to key ScyllaDB developer resources for querying data, modeling schemas, capturing change streams, and integrating ScyllaDB with the broader ecosystem.

• Application Best Practices — Configure replication strategy, consistency levels, and disk capacity for reliable, high-performance ScyllaDB Cloud applications.

• Apache Cassandra Query Language (CQL) — Use CQL to create keyspaces and tables, insert, query, update, and delete data. Covers data types, consistency levels, secondary indexes, materialized views, TTL, JSON support, and ScyllaDB CQL extensions.

• ScyllaDB Drivers — Connect your application to ScyllaDB Cloud using shard-aware CQL drivers for Python, Java, Go, Node.js, Rust, C++, and more, or DynamoDB-compatible drivers for Alternator workloads.

• Data Modeling — Design schemas optimized for ScyllaDB’s distributed architecture. Covers query-first design, partition key selection, clustering columns, denormalization patterns, and best practices for high-throughput workloads.

• Tracing — Trace CQL query execution across nodes to identify latency bottlenecks, slow coordinators, and inefficient queries.

• Change Data Capture (CDC) — Stream row-level changes from ScyllaDB tables in real time. Use CDC to build event-driven pipelines, synchronize downstream systems, or feed Kafka and other message brokers.

• Role Based Access Control (RBAC) — Configure fine-grained permissions on keyspaces and tables using CQL GRANT and REVOKE statements. Apply the principle of least privilege to database users and service accounts.

• ScyllaDB Alternator (DynamoDB-compatible API) — Use ScyllaDB Cloud as a drop-in replacement for Amazon DynamoDB. Alternator exposes a DynamoDB-compatible REST API, allowing you to migrate existing DynamoDB applications without code changes.

• Lightweight Transactions (LWT) — Execute compare-and-set (CAS) operations with IF NOT EXISTS and IF conditions to enforce uniqueness and conditional writes when strong consistency is required.

• ScyllaDB Integrations — Integrate ScyllaDB with third-party tools and platforms including Apache Kafka, Spark, Elasticsearch, Kubernetes, Databricks, DataDog, Spring, and more.