ClickHouse
columnar analytics
Open Source
Fast open source OLAP columnar database
Pricing Model
Free (OSS) / Pay-per-use (Cloud)
Free tier: Unlimited self-hosted
Supported Languages
Pros and Cons
Ventajas
- + Extremely fast for analytics
- + Efficient columnar compression
- + Real-time data ingestion
- + SQL-based with extensions
- + Linear cluster scalability
Desventajas
- - Not for transactional workloads
- - Updates/deletes not optimized
- - Requires analytical knowledge
Casos de Uso
- Real-time analytics
- BI and dashboards
- Log and event analysis
- A/B testing at scale