ClickHouse icon
ClickHouse icon

ClickHouse

ClickHouse is an open source column-oriented database management system capable of real time generation of analytical data reports using SQL queries.

ClickHouse screenshot 1

Cost / License

  • Freemium (Subscription)
  • Open Source

Platforms

  • Mac
  • Linux
  • BSD
  • FreeBSD
  • Windows
  • Docker
  • Self-Hosted
  • Online
  • Software as a Service (SaaS)
-
No reviews
5likes
0comments

Features

Suggest and vote on features
No features, maybe you want to suggest one?

 Tags

  • dbms

ClickHouse News & Activities

Highlights All activities

Recent News

Show more news

Recent activities

Show all activities
No comments or reviews, maybe you want to be first?
Post comment/review

What is ClickHouse?

ClickHouse is the fastest and most resource efficient real-time data warehouse and open-source database.

  • Blazing fast: Ultimate query performance that your mission-critical and time-sensitive applications can depend on.
  • Developer friendly: Built to ensure that even the most sophisticated data analysis can be done intuitively, using simple SQL.
  • Cost effective: Best-in-class compression ratios that reduce storage and accelerate performance.

Seamlessly integrate with your stack

Choose from our growing ecosystem of integrations for data ingestion, visualization, language clients, and more.

Why is ClickHouse so fast?

Column-oriented databases are better suited to OLAP scenarios. They are at least 100x faster in processing most queries. ClickHouse uses all available system resources to their full potential to process each analytical query as fast as possible.

  • Row-oriented databases: In row-oriented databases, data is stored in rows, with all the values related to a row physically stored next to each other.
  • Column-oriented databases: In column-oriented databases, like ClickHouse, data is stored in columns, with values from the same columns stored together.

Deploy your way

Unlike traditional closed-source databases, ClickHouse runs in every environment, whether it’s on your machine or in the cloud.

Official Links

ClickHouse information

  • Developed by

    US flagClickHouse, Inc. HQ
  • Licensing

    Open Source (Apache-2.0) and Freemium product.
  • Pricing

    Subscription ranging between $25 and $100 per month + free version with limited functionality.
  • Written in

  • Alternatives

    8 alternatives listed
  • Supported Languages

    • English

GitHub repository

  •  44,699 Stars
  •  7,909 Forks
  •  5526 Open Issues
  •   Updated  
View on GitHub
ClickHouse was added to AlternativeTo by Mahdy Abdelmotaleb on and this page was last updated .