ClickHouse vs Redis: Rating, Votes and Features
- License: ClickHouse — Apache-2.0; Redis — AGPL-3.0, RSALv2, SSPL-1.0.
- Data model: ClickHouse — Relational, Time-series; Redis — Document, Key-value, Vector.
- Workload: ClickHouse — Analytics (OLAP); Redis — Cache.
ClickHouse — November 2026: 3 votes, rating 9.3/10.
Redis — November 2026: 5 votes, rating 9.7/10.
| ClickHouse | Redis | |
|---|---|---|
| Category | database engine | database engine |
| Developer | ClickHouse, Inc. | Redis Ltd. |
| Created by | Alexey Milovidov | Salvatore Sanfilippo |
| First release | 2016 | 2009 |
| License | Apache-2.0 | AGPL-3.0, RSALv2, SSPL-1.0 |
| Open source | Yes | Yes |
| Pricing | Free, with paid plans | Free, with paid plans |
| Website | https://clickhouse.com | https://redis.io |
| Written in | C++ | C |
| Data model | Relational, Time-series | Document, Key-value, Vector |
| Storage layout | Column-oriented | In-memory |
| Workload | Analytics (OLAP) | Cache |
| Analytics architecture | Data warehouse | Not an analytics platform |
| Query language | SQL | Redis commands |
| ACID transactions | No | No |
| Schema | Strict | Flexible |
| Deployment | Distributed cluster, Managed cloud, Server | Managed cloud, Server |
| Scaling | Sharding | Sharding |
| Create, read, update, delete | Create: fast (Built for large batch inserts); Read: fast (Very fast aggregations and scans); Update: slow (Mutations rewrite data parts in the background); Delete: moderate (Lightweight deletes hide rows, merges remove them) | Create: fast (Everything happens in memory); Read: fast (Sub-millisecond lookups by key); Update: fast (Atomic operations on data structures); Delete: fast (Immediate, plus expiry by time) |