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
Open-source columnar OLAP database known for very fast aggregations over billions of rows.
Google's serverless, pay-per-query data warehouse built on Dremel and Colossus.
Real-time analytics database for sub-second slice-and-dice over streaming event data.
Veteran MPP columnar analytics database from the C-Store lineage, now owned by Rocket Software.
Microsoft's Kusto engine: fast KQL analytics over logs, telemetry and time series at petabyte scale.
Real-time OLAP store from LinkedIn for user-facing analytics at very high query rates.
Columnar storage engine for fast analytics on fast-changing data, paired with Impala or Spark.
OpenTelemetry-native APM and observability platform storing logs, metrics and traces in ClickHouse.
A single C++ binary for streaming SQL, built on ClickHouse's engine with streams and windows.
Real-time MPP analytical database with MySQL compatibility, search indexes and lakehouse access.
MPP OLAP database with a fast vectorized engine, real-time upserts and native lakehouse queries.
GPU-native columnar SQL database with visual analytics, fully open-sourced by NVIDIA in 2026.
Streaming lakehouse table format with LSM-based upserts and changelogs, born in Apache Flink.
Managed ClickHouse platform that turns SQL pipes into low-latency, versioned HTTP APIs.
Postgres extension that mirrors tables into Iceberg columnstores for real-time analytics via DuckDB.
Managed event and telemetry store with schema-on-read ingest and the piped APL query language.
Columnar streaming storage for Flink with primary-key tables and tiering into the lakehouse.
Low-latency analytical database with a Postgres-compliant dialect, as cloud service or self-hosted Core.
GPU- and vector-accelerated database for real-time spatial, time-series and vector analytics.
PostgreSQL-compatible MPP warehouse that runs on its appliance, any cloud or Kubernetes.
Hyperscale data warehouse on NVMe compute-adjacent storage, rebranded as the OcientAIQ platform.
Actian's vectorized columnar analytics database, born from CWI's X100; renamed Analytics Engine in 2026.
In-memory OLAP aggregation engine for bank risk analytics, renamed Atoti Server by ActiveViam.
Commercial cloud and enterprise distribution of Apache Doris from its core maintainers.
Experimental Rust columnar analytics engine built to scan billions of rows per second on one machine.
Streaming data lake for log-scale event data, with ClickHouse-based SQL over object storage.
Commercial in-memory columnar SQL engine for .NET that speeds up reporting over hundreds of millions of rows.
PostgreSQL extension adding hypertables, columnar compression and continuous aggregates for time series.
MySQL-compatible distributed SQL with a row store for OLTP and a columnar replica for real-time analytics.
Columnar time-series SQL database built for market data and very high ingest rates.
Column-store time-series engine with the q language, a fixture of capital-markets tick data.
Read-path sync engine that streams partial replicas of Postgres to clients over plain HTTP.
Distributed SQL mixing in-memory rowstore and columnstore for real-time analytics, search and vectors.
Distributed SQL database built on Lucene for real-time analytics over machine, IoT and JSON data.
In-memory relational database that runs your server logic as WASM modules and streams changes to clients.
In-memory, Cypher-compatible graph database in C++ for streaming and real-time graph workloads.
Postgres extension that shards tables across nodes for multi-tenant SaaS and real-time analytics.
In-memory, partitioned SQL engine running Java stored procedures serially for millisecond decisioning.
Alipay-proven distributed SQL with MySQL (and Oracle, in Enterprise) compatibility, HTAP and vector search.
An Apache-licensed, Postgres-compatible streaming database that stores state on S3 and writes Iceberg.
Distributed MPP graph database built for deep-link analytics on very large graphs.
An incremental SQL engine grounded in DBSP theory that updates any SQL query from changes only.
A Postgres-compatible operational data warehouse that keeps SQL views incrementally up to date.
Oracle's long-running Java data grid, with a UPL-licensed Community Edition on GitHub.
PostgreSQL extension that embeds DuckDB's vectorized engine for fast analytics and data-lake queries.
Confluent's SQL layer over Kafka Streams, still supported but superseded by Flink SQL for new work.
Multi-model data platform (SQL, objects, globals, vectors) with built-in interoperability, big in healthcare.
In-memory geospatial database and geofencing server that speaks the Redis protocol and HTTP.
Oracle's in-memory relational database: microsecond SQL, PL/SQL, and a cache tier for Oracle Database.
The dominant industrial data historian: time-series storage plus asset context for plants and grids.
A Postgres extension that keeps materialized views updated incrementally inside the same transaction.
Korean hybrid in-memory/on-disk RDBMS for telecom and finance, closed-source again since 2023.
A Rust stream processor with SQL pipelines, now owned by Cloudflare and powering Cloudflare Pipelines.
Alibaba's open-source, MySQL-compatible shared-nothing distributed SQL with Paxos and columnar indexes.
GigaSpaces' Java in-memory data grid with space-based processing, SQL queries and tiered storage.
Alibaba Cloud's shared-storage relational service in MySQL-, PostgreSQL- and Oracle-compatible editions.
Distributed in-memory time-series database with PromQL, ingesting from Kafka and persisting to Cassandra.
Converged C/C++ NoSQL platform mixing key-value, documents, time-series, stream processing, graph and ML.
Gremlin graph layer on the Aerospike database for billion-edge graphs with predictable latency.
Columnar tick database and array language from Kona's author, with JSON and SQL syntax; open-sourced in 2022.
Self-tuning document-graph database with automatic indexing, full version history and time-travel reads.
Proprietary ACID 'algorithmic' database from Indianapolis claiming extreme speed without conventional indexes.
An incremental view engine that keeps complex SQL results fresh inside your existing Postgres or MySQL.
Commercial in-memory data grid for .NET and Java with parallel query, Redis support and in-cache code.
Commercial distributed graph database marketed as built natively for ISO GQL.
The in-memory data structure server that became the default cache, now with search, JSON and vectors built in.
Lucene-based distributed search and analytics engine for text, vectors, logs and metrics.
Microsoft's flagship RDBMS: T-SQL, columnstore, Always On, and now native vectors and JSON.
The Linux Foundation's BSD-licensed fork of Redis, now the default engine on AWS and Google Cloud.
Apache-licensed, foundation-governed fork of Elasticsearch for search, vectors and observability.
Purpose-built time-series database, rebuilt in Rust on Arrow, DataFusion and Parquet for version 3.
Machine-data indexing and search platform with schema-on-read SPL queries, now owned by Cisco.
Microsoft's globally distributed, multi-API NoSQL and vector database with SLA-backed latency.
Flash-optimized distributed key-value and document database for predictable sub-millisecond latency at scale.
SAP's in-memory columnar HTAP database, the mandatory engine under S/4HANA.
The original MPP data warehouse, now VantageCloud with open table formats and in-database analytics.
A Java in-memory data grid and stream processor that embeds in your app or runs as a cluster.
Google's managed wide-column store, the original Bigtable, with HBase API and SQL access.
Low-latency graph database using sparse matrices, the maintained successor to RedisGraph.
A distributed, memory-first SQL database and compute grid; Ignite 3 rebuilt it around Raft and Calcite.
Elasticsearch-quality BM25 search and fast aggregations inside Postgres via the pg_search extension.
Big-data serving engine for search, recommendation and RAG with tensors and ML ranking.
Apache time-series database for industrial IoT with tree and table models and edge-to-cloud sync.
Industrial-IoT time-series database with a table-per-device model and built-in streaming and caching.
Rust observability database that keeps metrics, logs and traces in one columnar engine on object storage.
The open-source core of GemFire: a consistent, partitioned in-memory data grid for Java.
Distributed time-series database and scripting platform for quant finance and industrial analytics.
Shared-nothing, auto-sharded in-memory MySQL engine built for telecom-grade availability.
The commercial, enterprise-hardened distribution of Apache Ignite for low-latency SQL and compute.
Distributed columnar time-series database, now sold as Quasar, for tick, sensor and industrial data.
Broadcom's commercial in-memory data grid, the enterprise build of Apache Geode.
Google's Postgres-compatible service with disaggregated storage, a columnar engine and ScaNN vectors.
AWS time-series services: managed InfluxDB today, with serverless LiveAnalytics closed to new customers.
In-memory RDF store with incremental Datalog reasoning, now owned by Samsung.
Oracle's managed MySQL with an in-memory columnar engine for analytics, lakehouse, ML and vector search.
deprecated, discontinued & research · 25
related
license legend · Open source (permissive) · Open source (copyleft) · Source-available · Proprietary