![](https://www.pythian.com/hubfs/Imported_Blog_Media/word-image-16.png)
In this quick blog post, I’m going to assess how the databases that advertise themselves as “Cassandra API-compatible” fare in the compatibility department. But that is all I will do, only API testing, and not an extensive testing, just based on the APIs I see used often. Based on this, you can start building an informed decision on whether or not to change databases. The contenders:
- Apache Cassandra 4.0
- Installation: Build from Source
- Yugabyte - https://www.yugabyte.com/
- “YCQL is a transactional flexible-schema API that is compatible with the Cassandra Query Language (CQL). “
- Installation: Docker
- ScyllaDB - https://www.scylladb.com/
- “Apache Cassandra’s wire protocol, a rich polyglot of drivers, and integration with Spark, Presto, and Graph tools make for resource-efficient and performance-effective coding.”
- Installation: Docker
- Azure Cosmos - https://azure.microsoft.com/en-us/services/cosmos-db/
- “Azure Cosmos DB provides native support for NoSQL and OSS APIs including MongoDB, Cassandra, Gremlin and SQL”
- Installation: Azure Portal Wizard
What was tested
In this test, the following CQL APIs were tested:- Keyspace Creation
- Table Creation
- Adding a Column to a table (Alter table)
- Data Insert
- Data Insert with TTL (Time-to-live)
- Data Insert with LWT (Lightweight Transactions)
- Select Data
- Select data with a full table scan (ALLOW FILTERING)
- Creating a Secondary Index (2I)
Cassandra 4.0
- All statements worked (as expected)
CosmosDB
LWT Not supported ALLOW FILTERING Not supported 2i Is Not supportedScylla
LWT Not supportedYugabyte
2i Not SupportedResults Table
![](https://www.pythian.com/hubfs/Imported_Blog_Media/word-image-16.png)
Share this
You May Also Like
These Related Stories
ORA-15418: appliance mode not supported for compatible.asm 12.1.0.0.0
ORA-15418: appliance mode not supported for compatible.asm 12.1.0.0.0
Jul 20, 2016
1
min read
Installing SQL Server 2008 R2 on Windows 2012 cluster
Installing SQL Server 2008 R2 on Windows 2012 cluster
Aug 7, 2018
5
min read
Making existing SQLPLUS Scripts 12c and Container DB (PDB) compatible
Making existing SQLPLUS Scripts 12c and Container DB (PDB) compatible
May 26, 2015
7
min read
No Comments Yet
Let us know what you think