ScyllaDB is a NoSQL database designed for high performance, high throughput, and predictable low latency. Some of the tradeoffs are the lack of traditional relational database functionalities, such as arbitrary joins and ad-hoc querying. It does provide linearizable, single-partition transactions via lightweight transactions (Paxos) today—and Raft-based strong consistency for metadata (and soon for user tables)—but it does not yet support full ACID transactions spanning multiple partitions or tables. ScyllaDB also requires careful data modeling to ensure data is distributed according to its access patterns. On the other hand, its performance and scalability make it ideal for workloads that require predictable performance at scale. Read about database performance tradeoffs.