ClickHouse Reviews and details

Social recommendations and mentions

• The 2024 Web Hosting Report

  For the third, examples here might be analytics plugins in specialized databases like Clickhouse, data-transformations in places like your ETL pipeline using Airflow or Fivetran, or special integrations in your authentication workflow with Auth0 hooks and rules. - Source: dev.to / 2 months ago

• Choosing Between a Streaming Database and a Stream Processing Framework in Python

  Online analytical processing (OLAP) databases like Apache Druid, Apache Pinot, and ClickHouse shine in addressing user-initiated analytical queries. You might write a query to analyze historical data to find the most-clicked products over the past month efficiently using OLAP databases. When contrasting with streaming databases, they may not be optimized for incremental computation, leading to challenges in... - Source: dev.to / 3 months ago

• Real-Time Data Enrichment and Analytics With RisingWave and ClickHouse

  To achieve seamless real-time data ingestion, transformation, and analytics, a powerful combination to explore is RisingWave and ClickHouse. RisingWave is a PostgreSQL-compatible database specifically designed for stream processing. It excels at ingesting real-time data streams, performing diverse transformations, and enabling instant querying of results. ClickHouse® is a high-performance, column-oriented SQL... - Source: dev.to / 4 months ago

• Ask HN: Is there a Hacker News takeout to export my comments / upvotes, etc.?

  You can export the whole dataset as described here: https://github.com/ClickHouse/ClickHouse/issues/29693

      curl https://clickhouse.com/ | sh.

  - Source: Hacker News / 5 months ago

• Best alternative

  Nowadays I am looking at the clickhouse and how it might help me maybe you can check it out: https://clickhouse.com/. Source: 5 months ago

• Ask HN: Where to Store Logs?

  Don't insert the logs/events/analytics into your Application DB. Usually, you send those to specialist datastores (OLAP etc) that process such high volume of data. You can use something like clickhouse [0] for example or use 3rd party SAAS solutions like posthog [1] etc that are built on top of clickhouse [0] https://clickhouse.com [1] https://posthog.com. - Source: Hacker News / 6 months ago

• InfluxDB CTO: Why We Moved from Go to Rust

  Is there a comparison of the new InfluxDB against https://clickhouse.com? I ask because ClickHouse is quite hot at the moment from my experience in consulting and that reflect in Google Trends [1]. And there are some startups relying on ClickHouse for their log/monitoring products like https://signoz.io. - Source: Hacker News / 7 months ago

• The (Detailed & Creative) Playbook for More GitHub Stars

  I used tools (such at this one and this one) to see what other repos our stargazers were starring most frequently. The stargazers of these "other" commonly starred repos became an expanded pool of potential stargazers for Preevy. - Source: dev.to / 9 months ago

• Alternatives to Grafana for dashboards?

  Definitely worth considering SigNoz. It's free and open source, and does a better job of tying together traces, logs, and metrics in its UI. It also uses ClickHouse to store data which is high-performance for timeseries queries. Source: 10 months ago

• Altinity vs Open Source

  Https://clickhouse.com They're the devs who spun this product out of Yandex long ago. If you scroll down their "our story" page or whatever you'll see Alexey Milovidov is still CTO. Source: 11 months ago

• Seeking a free full text search solution for large data with progress display

  There's nothing faster than clickhouse. All queries have progress display by default (available both in CLI and in golang api). Unfortunately full text search is experimental, but you can get (fuzzy) string matching and read data directly from .txt (which would be a bit slower than using a native data format and use much more space) potentially without running a server. Source: 11 months ago

• The New Timescale

  The new logo and palette reminds me a lot of the recent ClickHouse facelift, https://clickhouse.com/. - Source: Hacker News / 12 months ago

• Miller: Like Awk, sed, cut, join, and sort for CSV, TSV, and tabular JSON

  > curl https://clickhouse.com/ | sh Jesus, this is disgusting. I'm not that picky and don't really complain about "... | sh" usually, but at least I took it for granted that I can always look at the script in the browser and assume that is has no actual evil intentions and doesn't rely on some fucking client-header magic to be modified on the fly. - Source: Hacker News / about 1 year ago

• What Is Synthetic Data? The Good, the Bad, and the Ugly

  If you need to anonymize a dataset (structured, possibly linked tables), I recommend clickhouse-obfuscator - a tool designed specifically for this purpose: https://clickhouse.com/blog/five-methods-of-database-obfuscation Quick Start:

      curl https://clickhouse.com/ | sh.

  - Source: Hacker News / about 1 year ago

• Best Platform Stack for SaaS Web App with Large DB

  Https://clickhouse.com/ if you need to get even lower level. Source: about 1 year ago

• Show HN: ClickHouse-local – a small tool for serverless data analytics

  What happens if you download the install script and edit it? I don't have a windows machine at hand right now so I can't check myself. Something like this:

      curl https://clickhouse.com/ --output install.sh.

  - Source: Hacker News / over 1 year ago

• Show HN: ClickHouse-local – a small tool for serverless data analytics

  > curl https://clickhouse.com/ | sh It feels a bit weird to not use a subdomain (install.clickhouse.com) or a specific route for this, and instead mix this in with your marketing site. - Source: Hacker News / over 1 year ago

• Cached Chrome Top Million Websites

  If you are interested in the research on technologies used on the Internet, I recommend playing with the "Minicrawl" dataset. It contains data about ~7 million top websites, and for every website, it also contains: - the full content of the main page; - the verbose output of curl, containing various timing info; the HTTP headers, protocol info... Using this dataset, you can build a service similar to... - Source: Hacker News / over 1 year ago

• Detecting the use of “curl – bash” server side

  I've also thought about this problem but ended up with curl | sh:

    curl https://clickhouse.com/ | sh.

  - Source: Hacker News / over 1 year ago

• Clickhouse - Getting started with Docker

  Clickhouse is a popular open-source column-oriented database management system that is designed for fast analytical queries and real-time data processing. It is particularly well-suited for handling large volumes of data and has been used by companies like Yandex, Alibaba, and Uber for their data warehousing and analytics needs. - Source: dev.to / over 1 year ago

• Querying Postgres Tables Directly from DuckDB

  It is very easy with ClickHouse. All you need is: SELECT ... FROM postgresql(...) FORMAT Parquet And you can run this query without installing ClickHouse, using the clickhouse-local command-line tool. It can be downloaded simply as: curl https://clickhouse.com/ | sh. - Source: Hacker News / over 1 year ago