When comparing LocustDB vs ClickHouse, the Slant community recommends ClickHouse for most people. In the question“What are the best analytics databases? ” ClickHouse is ranked 2nd while LocustDB is ranked 4th.
Ranked in these QuestionsQuestion Ranking
Pro Lightning fast
When running a simple count query on a database of 1.46 billion taxi rides, LocustDB completed the query in 0.25 seconds, beating out both Clickhouse and KDB+ (both leading analytics services) which came in at 0.89s and 0.84s respectively.
During testing a number of other queries were run, including average, count by 2/3, sparse filter, top N, reducible cardinality, irreducible cardinality, and dictionary encoding. LocustDB came out on top throughout nearly all of these tests.
Pro Simple to install and run
Using LocustDB is as simple as installing Rust, cloning the repository, pointing it to your database, and pressing go.
Pro SQL support
Pro Detailed documentation
Pro Vectorized query execution
Pro True column-oriented storage
ClickHouse supports multi-master asynchronous replication and can be deployed across multiple datacenters. Downtime of a single node or the whole datacenter won't affect the system's availability for both reads and writes.
ClickHouse scales well both vertically and horizontally. ClickHouse is easily adaptable to perform either on cluster with hundreds of nodes, or on a single server or even on a tiny virtual machine.
ClickHouse uses all available hardware to its full potential to process each query as fast as possible. It processes hundreds of millions to more than a billion rows and tens of gigabytes of data per single server per second.
Con Current support for certain types of data is lacking
LocustDB, as of the time of writing this, does not support floating point numbers, finding averages, or grouping by clause.