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

Platforms

  • Mac
  • Linux
  • BSD
  • FreeBSD
  • Windows
  • Docker
  • Self-Hosted
  • Online
  • Software as a Service (SaaS)
Save

Features

No features, maybe you want to suggest one?

 Tags

ClickHouse News & Activities

Highlights All activities

Recent News

Recent activities

No comments or reviews, maybe you want to be first?

Featured in Lists

Open-Source Slopware

A list of open-source software containing slop (LLM generated) code or endorses the usage of LLMs in other ways. This list contains software that obviously accepts irresponsible coding practices or promotes LLM usage. I found these applications while searching for alternatives to previously used software that turned out to contain code generated by slop-machines. Each of added applications have at least one link that points to the verifiable proof. This list by no means is meant to cover all the software that contains code by not-so-intelligent tools and people using them but to serve as a reminder to myself about what I have already checked. Why having LLM generated code (and using generative tools in general) is bad? Ethical reasons — such as illegally retrieved training material, underpaid workers that prepare the training data. Impact on environment — increased fossil fuel usage to supply the needed electricity power, water usage in water scarce regions. This somewhat overlaps with the above. Social impact – noise pollution in neighbourhoods near AI data centres, air pollution from diesel- or gas-powered turbines (also overlaps with the above), resource consumption by data centres drastically increases utility prices. Impact on brain and thinking, reasoning — by offloading thinking and decision making to machines people are shooting in their foot (more like in their head) as this leads to brain rot. Less intelligent people are easier to control. Even legal issues (especially in open-source software as it cannot be guaranteed that the “generated” code is not really just re-used, thus unknowingly violating the source license). Inevitable enshittification — every software product from big technology eventually gets enshittified to maximize revenue. For users this could mean hidden or plain ads, biased opinions/information, privacy violations, increased prices for LLM based tools. Burden on open-source software maintenance — LLM tools provide easier access to code contributions which often shifts the responsibility of checking code quality from developers to maintainers and reviewers. Digging through walls of merge request text and code generated by slop-machines takes valuable time that otherwise could be spent more meaningfully by fixing bugs and working on new features. I will try to add links that back up the claims above, but it may take a while. Of course, I see how and where generative tools could be helpful and sometimes I feel tempted to find an acceptable way to use them, but for now the direct and indirect costs far too much outweigh gains. This list has its positive counterpart: Slop-Free (Supposedly) Open-Source Software (not quite complete yet). Also take a look at and give thumbs up to AI Slopfree Software Catalog which contains software dedicated against usage of LLMs. Also, here is a list of some labels that can be added / voted for so they would eventually appear on application pages: Slopware; Slop (LLM) Code; Slop-Source Software; Open-Source Slopware; Contains Slop (LLM Generated) Code.
By Edgars148 appsUpdated

Official Links

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.

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

    11 alternatives listed
  • Badge

    Get an embeddable badge for ClickHouse
  • Supported Languages

    • English

GitHub repository

  •  50,244 Stars
  •  9,058 Forks
  •  8010 Open Issues
  •   Updated  
View on GitHub

Popular alternatives

View all
ClickHouse was added to AlternativeTo by Mahdy Abdelmotaleb on and this page was last updated .