Top all-time · #134
ClickHouse
Company blog · clickhouse.com/blog · on HN as saisrirampurdataprogramming
ClickHouse is the company blog at clickhouse.com, writing about data and programming. Since 2021, 305 different Hacker News readers have linked it 966 times, most often “ClickHouse: We Stand with Ukraine”. It is still writing: the last post was on 2026-11-02, and you can follow it by feed.
ClickHouse is a fast open-source column-oriented database management system that allows generating analytical data reports in real-time using SQL queries
Most-linked posts?
- /13 people · 14 mentions · first linked 2021-11-12
- ClickHouse: We Stand with Ukraine7 people · 7 mentions · first linked 2022-10-04
- Building a Distributed Cache for S36 people · 9 mentions · first linked 2025-05-28
- Agentic Coding at ClickHouse5 people · 7 mentions · first linked 2026-04-02
- AI-powered migrations from Postgres to ClickHouse5 people · 7 mentions · first linked 2026-02-17
- Asynchronous Data Inserts in ClickHouse5 people · 6 mentions · first linked 2023-08-02
- ClickHouse and the One Trillion Row Challenge5 people · 5 mentions · first linked 2024-03-05
- We scaled PgBouncer to 4x throughput4 people · 9 mentions · first linked 2026-07-01
- Show HN: ClickHouse-local – a small tool for serverless data analytics4 people · 8 mentions · first linked 2023-01-05
- Fast UPDATEs for the ClickHouse column store4 people · 8 mentions · first linked 2025-07-25
What Hacker News says?
They require the bot management config to update and propagate quickly in order to respond to attacks - but this seems like a case where updating a since instance first would have seen the panic and stopped the deploy. I wonder why clickhouse is used to store the feature flags here, as it has it's own duplication footguns[0] which could have also easily lead to a query blowing up 2/3x in size. oltp/sqlite seems more…
Comment linking /docs/guides/developer/deduplication
on “Cloudflare outage on November 18, 2025 post mortem”Submitted 28M Hacker News comments as vector embedding search dataset as a story · 454 points
HN discussionYup https://clickhouse.com/docs/en/sql-reference/statements/sele...
Comment linking /docs/en/sql-reference/statements/select/join
on “SQL for data scientists in 100 queries”Submitted A new JSON data type for ClickHouse as a story · 382 points
HN discussionIf you are interested in reading about JOINS in detail, ClickHouse has good blogs around it: - https://clickhouse.com/blog/clickhouse-fully-supports-joins-... - https://clickhouse.com/blog/clickhouse-fully-supports-joins-... - https://clickhouse.com/blog/clickhouse-fully-supports-joins-... - https://clickhouse.com/blog/clickhouse-fully-supports-joins-... - https://clickhouse.com/blog/clickhouse-fully-supports-joins-…
Comment linking /blog/clickhouse-fully-supports-joins-how-to-choose-the-right-algorithm-part5
on “SQL for data scientists in 100 queries”Submitted ClickHouse gets lazier and faster: Introducing lazy materialization as a story · 366 points
HN discussionYeah ClickHouse is written in C++, though rust is also possible https://clickhouse.com/blog/rust - would be cool to see zig!
Comment linking /blog/rust
on “Libghostty is coming”Submitted ClickHouse Cloud is now in Public Beta as a story · 278 points
HN discussionI recommend checking the dataset of "YouTube dislikes": https://clickhouse.com/docs/en/getting-started/example-datas... (it is named this way because it was an archival effort to collect the information before the dislike feature was removed) It can be used to find things like the most controversial videos; top videos with a description in a certain language, etc.
Comment linking /docs/en/getting-started/example-datasets/youtube-dislikes
on “How big is YouTube?”Submitted Optimizing ClickHouse for Intel's ultra-high core count processors as a story · 225 points
HN discussionUsing ClickHouse you can also process local files in one line using clickhouse-local command tool. And it will look a lot easier: clickhouse local -q "SELECT passenger_count, COUNT(*), AVG(total_amount) FROM file(taxi.csv, 'CSVWithNames') GROUP BY passenger_count" And ClickHouse supports a lot of different file formats both for import and export (you can see all of them here https://clickhouse.com/docs/en/interfaces…
Comment linking /docs/en/interfaces/formats/
on “One-liner for running queries against CSV files with SQLite”Submitted Scaling our observability platform by embracing wide events and replacing OTel as a story · 200 points
HN discussionClickHouse does not allow external connections by default. If someone wants to configure an unauthenticated access from the Internet, they have to do the following extra steps: - enable listening to the wildcard address; - remove IP filtering for the default user; - set up a no-password authentication; It is possible to ignore and turn off all guardrails that the system has by default, but it needs extra efforts. Ho…
Comment linking /cloud
on “Exposed DeepSeek database leaking sensitive information, including chat history”Submitted Postgres isn't slow, your storage is as a story · 180 points
HN discussionFrom https://clickhouse.com/docs/en/operations/access-rights#acce... > By default, the ClickHouse server provides the default user account which is not allowed using SQL-driven access control and account management but has all the rights and permissions. The default user account is used in any cases when the username is not defined, for example, at login from client or in distributed queries This seems... very antiq…
Comment linking /docs/en/operations/access-rights
on “Exposed DeepSeek database leaking sensitive information, including chat history”Submitted What's New in ClickHouse 21.12 as a story · 133 points
HN discussionI don't have personal experience but from a quick google it looks like default setup is to accept connections on localhost only [0], and there's a default user without capability to run SQL statements. They would have had to open remote connections and enable SQL capability for the default user (it looks like this is the first step to creating other users, the 3rd step is, removing SQL capability for default user.)…
Comment linking /docs/en/operations/access-rights
on “Exposed DeepSeek database leaking sensitive information, including chat history”Submitted A year of Rust in ClickHouse as a story · 125 points
HN discussionFor those interested in birdwatching, I also recommend checking a web app: https://adsb.exposed/?dataset=Birds Explanation: https://clickhouse.com/blog/birds
Comment linking /blog/birds
on “Merlin Bird ID”Submitted ClickHouse raises $350M Series C as a story · 119 points
HN discussionclickhouse-local is incredible, and, in addition to JSON, support TSV, CSV, Parquet and many other input formats. See https://clickhouse.com/blog/extracting-converting-querying-l...
Comment linking /blog/extracting-converting-querying-local-files-with-sql-clickhouse-local
on “Sq.io: jq for databases and more”Submitted ClickHouse acquires LibreChat, open-source AI chat platform as a story · 118 points
HN discussionOh! Damn it I forgot about manticore -- I had seen it before but forgot to include it. Eventually all of these projects will be highlighted on Awesome F/OSS ( https://awsmfoss.com ), but for now I'm just going to dump my bookmarks here for other people, since I'm leaving awesome projects out: Search Engines AWS OpenSearch https://github.com/opensearch-project/OpenSearch https://github.com/opensearch-project/OpenSear…
Comment linking /docs/en/sql-reference/functions/string-search-functions/
on “Sonic: Fast, lightweight and schema-less search backend”Submitted Pg_ClickHouse: A Postgres extension for querying ClickHouse as a story · 117 points
HN discussionClickHouse can delete rows but work as batch/async operations: https://clickhouse.com/docs/en/faq/operations/delete-old-dat...
Comment linking /docs/en/faq/operations/delete-old-data/
on “ClickHouse, Inc.”Submitted When Sigterm Does Nothing: A Postgres Mystery as a story · 115 points
HN discussionThere are many independent comparisons of ClickHouse vs TimescaleDB: By Splitbee: https://github.com/ClickHouse/ClickHouse/issues/22398#issuec... By GitLab: https://github.com/ClickHouse/ClickHouse/issues/22398#issuec... And others: https://github.com/ClickHouse/ClickHouse/issues/22398#issuec... https://github.com/ClickHouse/ClickHouse/issues/22398#issuec... If you'll find more, please post it there. TimescaleDB can…
Comment linking /docs/en/sql-reference/statements/alter/delete/
on “ClickHouse, Inc.”Submitted Data engineering and software engineering are converging as a story · 108 points
HN discussion(Timescale DevRel here) We've recently been working through a detailed benchmark of TimescaleDB and Clickhouse. The DELETE/UPDATE question has been an intriguing story to follow - and I honestly hadn't considered the GDPR angle. ATM, Clickhouse is still OLAP focused and their MergeTree implementation does not allow direct DELETE (or UPDATE) of any data. All DELETE/UPDATE requests are applied asynchronously by (essen…
Comment linking /docs/en/sql-reference/statements/alter/
on “ClickHouse, Inc.”Submitted ClickHouse vs PostgreSQL UPDATE performance comparison as a story · 106 points
HN discussion
