SWC-DB vs Transwarp Hyperbase

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.

Transwarp Hyperbase is a self-hosted NoSQL wide-table database for real-time, low-latency access under high concurrency. It supports precise and range queries, stream-processing applications, full-text search and retrieval of unstructured data. Stored content can include structured records, text, images, videos and objects. Distributed full-text indexing through Transwarp Scope supports global, local and high-dimensional indexes, advanced filters and automatic index selection. Hyperbase accepts ANSI SQL 2003 syntax and is compatible with open-source HBase. Transwarp says it supports concurrent queries for millions of users and high-volume insert, modify and delete operations. SQL Bulkload handles data migration, while DSTool provides one-click cluster repair. Transwarp Guardian adds authentication, table access controls and multi-tenancy permissions. The database runs on general server clusters and is listed as part of the TDH data platform. It is available through an API. Pricing is by inquiry, with no public price listed.