DB-EnginesextremeDB - Data management wherever you need itEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > ClickHouse vs. Firebolt vs. Redis

System Properties Comparison ClickHouse vs. Firebolt vs. Redis

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameClickHouse  Xexclude from comparisonFirebolt  Xexclude from comparisonRedis  Xexclude from comparison
DescriptionA high-performance, column-oriented SQL DBMS for online analytical processing (OLAP) that uses all available system resources to their full potential to process each analytical query as fast as possible. It is available as both an open-source software and a cloud offering.Highly scalable cloud data warehouse and analytics product infoForked from ClickhousePopular in-memory data platform used as a cache, message broker, and database that can be deployed on-premises, across clouds, and hybrid environments infoRedis focuses on performance so most of its design decisions prioritize high performance and very low latencies.
Primary database modelRelational DBMSRelational DBMSKey-value store infoMultiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistence
Secondary database modelsTime Series DBMSDocument store infowith RedisJSON
Graph DBMS infowith RedisGraph
Spatial DBMS
Search engine infowith RediSearch
Time Series DBMS infowith RedisTimeSeries
Vector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score18.73
Rank#31  Overall
#19  Relational DBMS
Score0.94
Rank#188  Overall
#86  Relational DBMS
Score154.11
Rank#7  Overall
#1  Key-value stores
Websiteclickhouse.comwww.firebolt.ioredis.com
redis.io
Technical documentationclickhouse.com/­docsdocs.firebolt.iodocs.redis.com/­latest/­index.html
redis.io/­docs
DeveloperClickhouse Inc.Firebolt Analytics Inc.Redis project core team, inspired by Salvatore Sanfilippo infoDevelopment sponsored by Redis Inc.
Initial release201620202009
Current releasev24.6.2.17-stable, July 20247.2.5, May 2024
License infoCommercial or Open SourceOpen Source infoApache 2.0commercialOpen Source infosource-available extensions (modules), commercial licenses for Redis Enterprise
Cloud-based only infoOnly available as a cloud servicenoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC++C
Server operating systemsFreeBSD
Linux
macOS
hostedBSD
Linux
OS X
Windows infoported and maintained by Microsoft Open Technologies, Inc.
Data schemeyesyesschema-free
Typing infopredefined data types such as float or dateyesyespartial infoSupported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nono
Secondary indexesyesyesyes infowith RediSearch module
SQL infoSupport of SQLClose to ANSI SQL (SQL/JSON + extensions)yeswith RediSQL module
APIs and other access methodsgRPC
HTTP REST
JDBC
MySQL wire protocol
ODBC
PostgreSQL wire protocol
Proprietary protocol
.Net
ODBC
RESTful HTTP API
proprietary protocol infoRESP - REdis Serialization Protocol
Supported programming languagesC# info3rd party library
C++
Elixir info3rd party library
Go info3rd party library
Java info3rd party library
JavaScript (Node.js) info3rd party library
Kotlin info3rd party library
Nim info3rd party library
Perl info3rd party library
PHP info3rd party library
Python info3rd party library
R info3rd party library
Ruby info3rd party library
Rust
Scala info3rd party library
Go
JavaScript (Node.js)
Python
C
C#
C++
Clojure
Crystal
D
Dart
Elixir
Erlang
Fancy
Go
Haskell
Haxe
Java
JavaScript (Node.js)
Lisp
Lua
MatLab
Objective-C
OCaml
Pascal
Perl
PHP
Prolog
Pure Data
Python
R
Rebol
Ruby
Rust
Scala
Scheme
Smalltalk
Swift
Tcl
Visual Basic
Server-side scripts infoStored proceduresyesnoLua; Redis Functions coming in Redis 7 (slides and Github)
Triggersnonopublish/subscribe channels provide some trigger functionality; RedisGears
Partitioning methods infoMethods for storing different data on different nodeskey based and customSharding infoAutomatic hash-based sharding with support for hash-tags for manual sharding
Replication methods infoMethods for redundantly storing data on multiple nodesAsynchronous and synchronous physical replication; geographically distributed replicas; support for object storages.depending on storage layerMulti-source replication infowith Redis Enterprise Pack
Source-replica replication infoChained replication is supported
MapReduce infoOffers an API for user-defined Map/Reduce methodsnothrough RedisGears
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Causal consistency can be enabled in Active-Active databases
Strong consistency with Redis Raft
Strong eventual consistency with Active-Active
Foreign keys infoReferential integritynono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoAtomic execution of command blocks and scripts and optimistic locking
Concurrency infoSupport for concurrent manipulation of datayesyes infoData access is serialized by the server
Durability infoSupport for making data persistentyesyes infoConfigurable mechanisms for persistency via snapshots and/or operations logs
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes
User concepts infoAccess controlAccess rights for users and roles. Column and row based policies. Quotas and resource limits. Pluggable authentication with LDAP and Kerberos. Password based, X.509 certificate, and SSH key authentication.Access Control Lists (ACLs): redis.io/­docs/­management/­security/­acl
LDAP and Role-Based Access Control (RBAC) for Redis Enterprise
Mutual TLS authentication: redis.io/­docs/­management/­security/­encryption
Password-based authentication

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
ClickHouseFireboltRedis
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2018
2 January 2019, Paul Andlinger, Matthias Gelbmann

MySQL, PostgreSQL and Redis are the winners of the March ranking
2 March 2016, Paul Andlinger

MongoDB is the DBMS of the year, defending the title from last year
7 January 2015, Paul Andlinger, Matthias Gelbmann

show all

Recent citations in the news

Wiz Research Uncovers Exposed DeepSeek Database Leaking Sensitive Information, Including Chat History
29 January 2025, wiz.io

DeepSeek Exposed Database Leaks Sensitive Data
30 January 2025, Infosecurity Magazine

ClickHouse Acquires HyperDX to Accelerate the Future of Observability
13 March 2025, Business Wire

A Beginner’s Guide to ClickHouse Database
13 September 2024, KDnuggets

Quesma bridges Elasticsearch and SQL, promises faster, cheaper queries
4 April 2025, Blocks and Files

provided by Google News

Firebolt Introduces FireScale - A Benchmark for Low Latency/High Concurrency Analytics Workloads to Power Data and AI Applications
27 March 2025, Business Wire

Firebolt Introduces Industry-First Low Latency Cloud Data Warehouse
18 September 2024, insideAI News

Jedify Launches Universal Data Connectivity With Firebolt to Power Lightning-Fast Enterprise AI & Analytics
16 April 2025, Newswire :) Press Release Distribution

Firebolt Welcomes Former Oracle and Confluent Leader Hemanth Vedagarbha as President, Overseeing Global Go-To-Market Expansion and Customer-Facing Operations
6 February 2025, Business Wire

Data warehouse unicorn Firebolt aims to make magic in Kirkland
10 September 2024, The Business Journals

provided by Google News

Vector search is the new black for enterprise databases
24 April 2025, theregister.com

Accelerate Machine Learning Model Serving with FastAPI and Redis Caching
23 April 2025, KDnuggets

Redis 8 Targets AI Applications with New Data Type for Vector Similarity
20 April 2025, infoq.com

Integrate your Spring Boot application with Amazon ElastiCache
16 April 2025, Amazon Web Services

Redis Inc seeks control over future of Rust redis-rs client library, amid talk of trademark concerns
27 November 2024, devclass

provided by Google News



Share this page

Featured Products

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Present your product here