Elassandra vs SWC-DB

Elassandra combines Apache Cassandra’s distributed storage with embedded OpenSearch search on each node. Its maintained line targets Apache Cassandra 4.0.x, OpenSearch 1.3.x, and Java 11. OpenSearch indices map to Cassandra keyspaces, documents to rows, and indexed fields to columns or cells; the current _doc model maps to a Cassandra table. Cassandra remains the durable layer, allowing restart recovery to replay Cassandra state and rebuild a local search view. Applications can search through the OpenSearch HTTP API or CQL, with HTTP responses following OpenSearch style. Data placement uses Cassandra token ownership, while replicas follow keyspace replication. Schemas can be created from OpenSearch indexes or discovered from existing Cassandra schemas through mappings. Integrations listed include OpenSearch plugins, OpenSearch Dashboards, and Spark. Deployment options include tarball, Debian package, RPM, Docker image, and Helm chart. Elassandra is free and open source, with a 30-day trial noted.

SWC-DB is a self-hosted Super Wide Column Database that the maker describes as a key-value, wide-column NoSQL and time-series database. It supports SQL, but SQL has no joins, and the system is designed for very large data volumes. Its data model uses cell keys made from lists of fractions with timestamps, with numerous columns rather than tables or namespaces. Data can have automatic or user-defined versions, ordered ascending or descending, with a configurable maximum retained. The maker describes ACID concepts for a single data entry; writes across multiple entries are not atomic as a group. Communications can use SSL, but transaction security also depends on the configured filesystem and clients supporting a secure layer. User-concept access controls are unsupported. A cluster utility can deploy, start and stop distributed clusters. Downloads include tar.xz and Debian packages, with Arch Linux AUR packages also described. SWC-DB is free under GPLv3; commercial-purpose licensing inquiries are invited for uses limited by that license.