ClickHouse
A column-oriented database built for real-time analytics, scanning billions of rows a second. See how developers rate it month by month on DTDb.
- Category
- database engine
- Developer
- ClickHouse, Inc.
- Created by
- Alexey Milovidov
- First release
- 2016
- License
- Apache-2.0
- Open source
- Yes
- Pricing
- Free with paid plans
- Website
- https://clickhouse.com
- Written in
- C++
- Data model
- Relational, Time-series
- Storage layout
- Column-oriented
- Workload
- Analytics (OLAP)
- Analytics architecture
- Data warehouse
- Query language
- SQL
- ACID transactions
- No
- Schema
- Strict
- Deployment
- Server, Distributed cluster, Managed cloud
- Scaling
- 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)