Use case

Databases for Real-time analytics

Sub-second queries over streaming, constantly-arriving data for user-facing dashboards. The leading options are ClickHouse, Google BigQuery and Apache Druid.

95 active · ordered by fit for this category, then WhichDB Score

ClickHouseColumnar / OLAPopen source

Open-source columnar OLAP database known for very fast aggregations over billions of rows.

69.8
Google BigQueryColumnar / OLAPmanaged

Google's serverless, pay-per-query data warehouse built on Dremel and Colossus.

65.3
Apache DruidColumnar / OLAPopen source

Real-time analytics database for sub-second slice-and-dice over streaming event data.

35.0
VerticaColumnar / OLAP

Veteran MPP columnar analytics database from the C-Store lineage, now owned by Rocket Software.

33.1
Azure Data ExplorerColumnar / OLAPmanaged

Microsoft's Kusto engine: fast KQL analytics over logs, telemetry and time series at petabyte scale.

31.2
Apache PinotColumnar / OLAPopen source

Real-time OLAP store from LinkedIn for user-facing analytics at very high query rates.

29.9
Apache KuduColumnar / OLAPopen source

Columnar storage engine for fast analytics on fast-changing data, paired with Impala or Spark.

18.6
SigNozColumnar / OLAPopen source

OpenTelemetry-native APM and observability platform storing logs, metrics and traces in ClickHouse.

17.0
Timeplus ProtonColumnar / OLAPopen source

A single C++ binary for streaming SQL, built on ClickHouse's engine with streams and windows.

16.6
Apache DorisColumnar / OLAPopen source

Real-time MPP analytical database with MySQL compatibility, search indexes and lakehouse access.

15.9
StarRocksColumnar / OLAPopen source

MPP OLAP database with a fast vectorized engine, real-time upserts and native lakehouse queries.

15.6
HEAVY.AI (HeavyDB)Columnar / OLAPopen source

GPU-native columnar SQL database with visual analytics, fully open-sourced by NVIDIA in 2026.

14.3
Apache PaimonColumnar / OLAPopen source

Streaming lakehouse table format with LSM-based upserts and changelogs, born in Apache Flink.

14.2
TinybirdColumnar / OLAP

Managed ClickHouse platform that turns SQL pipes into low-latency, versioned HTTP APIs.

12.6
pg_mooncakeColumnar / OLAPopen source

Postgres extension that mirrors tables into Iceberg columnstores for real-time analytics via DuckDB.

11.2
AxiomColumnar / OLAPmanaged

Managed event and telemetry store with schema-on-read ingest and the piped APL query language.

10.9
Apache FlussColumnar / OLAPopen source

Columnar streaming storage for Flink with primary-key tables and tiering into the lakehouse.

8.4
FireboltColumnar / OLAP

Low-latency analytical database with a Postgres-compliant dialect, as cloud service or self-hosted Core.

7.8
KineticaColumnar / OLAP

GPU- and vector-accelerated database for real-time spatial, time-series and vector analytics.

6.4
YellowbrickColumnar / OLAP

PostgreSQL-compatible MPP warehouse that runs on its appliance, any cloud or Kubernetes.

4.1
OcientColumnar / OLAP

Hyperscale data warehouse on NVMe compute-adjacent storage, rebranded as the OcientAIQ platform.

3.8
Actian Analytics Engine (Vector)Columnar / OLAP

Actian's vectorized columnar analytics database, born from CWI's X100; renamed Analytics Engine in 2026.

3.7
ActivePivotColumnar / OLAP

In-memory OLAP aggregation engine for bank risk analytics, renamed Atoti Server by ActiveViam.

3.4
VeloDBColumnar / OLAPmanaged

Commercial cloud and enterprise distribution of Apache Doris from its core maintainers.

2.3
LocustDBColumnar / OLAPopen source

Experimental Rust columnar analytics engine built to scan billions of rows per second on one machine.

2.1
HydrolixColumnar / OLAP

Streaming data lake for log-scale event data, with ClickHouse-based SQL over object storage.

0.2
InMemory.NetColumnar / OLAP

Commercial in-memory columnar SQL engine for .NET that speeds up reporting over hundreds of millions of rows.

0.2
TimescaleDBTime-Series

PostgreSQL extension adding hypertables, columnar compression and continuous aggregates for time series.

47.1
TiDBRelationalopen source

MySQL-compatible distributed SQL with a row store for OLTP and a columnar replica for real-time analytics.

35.9
QuestDBTime-Seriesopen source

Columnar time-series SQL database built for market data and very high ingest rates.

34.1
kdb+Time-Series

Column-store time-series engine with the q language, a fixture of capital-markets tick data.

31.8
ElectricSQLRelationalopen source

Read-path sync engine that streams partial replicas of Postgres to clients over plain HTTP.

30.4
SingleStoreRelational

Distributed SQL mixing in-memory rowstore and columnstore for real-time analytics, search and vectors.

29.0
CrateDBRelationalopen source

Distributed SQL database built on Lucene for real-time analytics over machine, IoT and JSON data.

27.3
SpacetimeDBRelational

In-memory relational database that runs your server logic as WASM modules and streams changes to clients.

27.3
MemgraphGraph

In-memory, Cypher-compatible graph database in C++ for streaming and real-time graph workloads.

24.4
CitusRelationalopen source

Postgres extension that shards tables across nodes for multi-tenant SaaS and real-time analytics.

21.1
Volt Active Data (VoltDB)Relational

In-memory, partitioned SQL engine running Java stored procedures serially for millisecond decisioning.

20.7
OceanBaseRelationalopen source

Alipay-proven distributed SQL with MySQL (and Oracle, in Enterprise) compatibility, HTAP and vector search.

19.4
RisingWaveRelationalopen source

An Apache-licensed, Postgres-compatible streaming database that stores state on S3 and writes Iceberg.

17.4
TigerGraphGraph

Distributed MPP graph database built for deep-link analytics on very large graphs.

16.6
FelderaRelationalopen source

An incremental SQL engine grounded in DBSP theory that updates any SQL query from changes only.

15.8
MaterializeRelational

A Postgres-compatible operational data warehouse that keeps SQL views incrementally up to date.

15.7
Oracle CoherenceKey-Valueopen source

Oracle's long-running Java data grid, with a UPL-licensed Community Edition on GitHub.

15.7
pg_duckdbRelationalopen source

PostgreSQL extension that embeds DuckDB's vectorized engine for fast analytics and data-lake queries.

14.9
ksqlDBRelational

Confluent's SQL layer over Kafka Streams, still supported but superseded by Flink SQL for new work.

13.7
InterSystems IRISRelational

Multi-model data platform (SQL, objects, globals, vectors) with built-in interoperability, big in healthcare.

13.3
Tile38Spatialopen source

In-memory geospatial database and geofencing server that speaks the Redis protocol and HTTP.

10.0
Oracle TimesTenRelational

Oracle's in-memory relational database: microsecond SQL, PL/SQL, and a cache tier for Oracle Database.

9.5
OSIsoft PITime-Series

The dominant industrial data historian: time-series storage plus asset context for plants and grids.

6.4
pg_ivmRelationalopen source

A Postgres extension that keeps materialized views updated incrementally inside the same transaction.

6.4
AltibaseRelational

Korean hybrid in-memory/on-disk RDBMS for telecom and finance, closed-source again since 2023.

5.5
ArroyoRelationalopen source

A Rust stream processor with SQL pipelines, now owned by Cloudflare and powering Cloudflare Pipelines.

5.4
PolarDB-XRelationalopen source

Alibaba's open-source, MySQL-compatible shared-nothing distributed SQL with Paxos and columnar indexes.

5.0
GigaSpaces XAPObject

GigaSpaces' Java in-memory data grid with space-based processing, SQL queries and tiered storage.

4.4
Alibaba PolarDBRelationalmanaged

Alibaba Cloud's shared-storage relational service in MySQL-, PostgreSQL- and Oracle-compatible editions.

2.7
FiloDBTime-Seriesopen source

Distributed in-memory time-series database with PromQL, ingesting from Kafka and persisting to Cassandra.

2.2
BangDBDocument

Converged C/C++ NoSQL platform mixing key-value, documents, time-series, stream processing, graph and ML.

2.1
Aerospike GraphGraph

Gremlin graph layer on the Aerospike database for billion-edge graphs with predictable latency.

1.7
KerfTime-Seriesopen source

Columnar tick database and array language from Kona's author, with JSON and SQL syntax; open-sourced in 2022.

1.3
ConcourseDocumentopen source

Self-tuning document-graph database with automatic indexing, full version history and time-travel reads.

0.9
AncelusRelational

Proprietary ACID 'algorithmic' database from Indianapolis claiming extreme speed without conventional indexes.

0.0
EpsioRelational

An incremental view engine that keeps complex SQL results fresh inside your existing Postgres or MySQL.

0.0
ScaleOut StateServerKey-Value

Commercial in-memory data grid for .NET and Java with parallel query, Redis support and in-cache code.

0.0
UltipaGraph

Commercial distributed graph database marketed as built natively for ISO GQL.

0.0
RedisKey-Valueopen source

The in-memory data structure server that became the default cache, now with search, JSON and vectors built in.

84.3
ElasticsearchSearch Engineopen source

Lucene-based distributed search and analytics engine for text, vectors, logs and metrics.

75.1
Microsoft SQL ServerRelational

Microsoft's flagship RDBMS: T-SQL, columnstore, Always On, and now native vectors and JSON.

71.0
ValkeyKey-Valueopen source

The Linux Foundation's BSD-licensed fork of Redis, now the default engine on AWS and Google Cloud.

58.0
OpenSearchSearch Engineopen source

Apache-licensed, foundation-governed fork of Elasticsearch for search, vectors and observability.

56.6
InfluxDBTime-Seriesopen source

Purpose-built time-series database, rebuilt in Rust on Arrow, DataFusion and Parquet for version 3.

51.0
SplunkSearch Engine

Machine-data indexing and search platform with schema-on-read SPL queries, now owned by Cisco.

48.1
Azure Cosmos DBDocumentmanaged

Microsoft's globally distributed, multi-API NoSQL and vector database with SLA-backed latency.

45.3
AerospikeKey-Valueopen source

Flash-optimized distributed key-value and document database for predictable sub-millisecond latency at scale.

40.4
SAP HANARelational

SAP's in-memory columnar HTAP database, the mandatory engine under S/4HANA.

39.7
Teradata VantageRelational

The original MPP data warehouse, now VantageCloud with open table formats and in-database analytics.

38.5
HazelcastKey-Valueopen source

A Java in-memory data grid and stream processor that embeds in your app or runs as a cluster.

33.5
Google Cloud BigtableWide-Columnmanaged

Google's managed wide-column store, the original Bigtable, with HBase API and SQL access.

33.3
FalkorDBGraph

Low-latency graph database using sparse matrices, the maintained successor to RedisGraph.

28.5
Apache IgniteKey-Valueopen source

A distributed, memory-first SQL database and compute grid; Ignite 3 rebuilt it around Raft and Calcite.

28.3
ParadeDBSearch Engineopen source

Elasticsearch-quality BM25 search and fast aggregations inside Postgres via the pg_search extension.

25.1
VespaSearch Engineopen source

Big-data serving engine for search, recommendation and RAG with tensors and ML ranking.

23.8
Apache IoTDBTime-Seriesopen source

Apache time-series database for industrial IoT with tree and table models and edge-to-cloud sync.

22.8
TDengineTime-Seriesopen source

Industrial-IoT time-series database with a table-per-device model and built-in streaming and caching.

17.4
GreptimeDBTime-Seriesopen source

Rust observability database that keeps metrics, logs and traces in one columnar engine on object storage.

15.1
Apache GeodeKey-Valueopen source

The open-source core of GemFire: a consistent, partitioned in-memory data grid for Java.

11.7
DolphinDBTime-Series

Distributed time-series database and scripting platform for quant finance and industrial analytics.

11.6
MySQL NDB ClusterRelationalopen source

Shared-nothing, auto-sharded in-memory MySQL engine built for telecom-grade availability.

11.4
GridGainRelational

The commercial, enterprise-hardened distribution of Apache Ignite for low-latency SQL and compute.

7.8
quasardbTime-Series

Distributed columnar time-series database, now sold as Quasar, for tick, sensor and industrial data.

6.6
VMware Tanzu GemFireKey-Value

Broadcom's commercial in-memory data grid, the enterprise build of Apache Geode.

4.7
AlloyDB for PostgreSQLRelationalmanaged

Google's Postgres-compatible service with disaggregated storage, a columnar engine and ScaNN vectors.

3.6
Amazon TimestreamTime-Seriesmanaged

AWS time-series services: managed InfluxDB today, with serverless LiveAnalytics closed to new customers.

3.5
RDFoxRDF / Triple Store

In-memory RDF store with incremental Datalog reasoning, now owned by Samsung.

3.4
MySQL HeatWaveRelationalmanaged

Oracle's managed MySQL with an in-memory columnar engine for analytics, lakehouse, ML and vector search.

0.5

license legend · Open source (permissive) · Open source (copyleft) · Source-available · Proprietary