Commonly Compared
Ranked in these QuestionsQuestion Ranking
Pros
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.
Cons
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.