[GUEST ACCESS MODE: Data is scrambled or limited to provide examples. Make requests using your API key to unlock full data. Check https://lunarcrush.ai/auth for authentication information.] #  @ClickHouseDB ClickHouse ClickHouse posts on X about clickhouse, realtime, snowflake, databricks the most. They currently have XXXXXX followers and XX posts still getting attention that total XXXXXXX engagements in the last XX hours. ### Engagements: XXXXXXX [#](/creator/twitter::824992362480943106/interactions)  - X Week XXXXXXXXX +24% - X Month XXXXXXXXX +390% - X Months XXXXXXXXX +3,130% - X Year XXXXXXXXX +11% ### Mentions: XX [#](/creator/twitter::824992362480943106/posts_active)  - X Week XX -XXXX% - X Month XX -XX% - X Months XXX +33% - X Year XXX -XX% ### Followers: XXXXXX [#](/creator/twitter::824992362480943106/followers)  - X Week XXXXXX +0.61% - X Month XXXXXX +3.80% - X Months XXXXXX +30% - X Year XXXXXX +44% ### CreatorRank: XXXXXX [#](/creator/twitter::824992362480943106/influencer_rank)  ### Social Influence **Social category influence** [technology brands](/list/technology-brands) XXXX% [events](/list/events) #647 [stocks](/list/stocks) XXXX% **Social topic influence** [clickhouse](/topic/clickhouse) #1, [realtime](/topic/realtime) #7, [snowflake](/topic/snowflake) #90, [databricks](/topic/databricks) #11, [ai](/topic/ai) 6.12%, [jobs](/topic/jobs) 2.04%, [credits](/topic/credits) 2.04%, [shoutout](/topic/shoutout) 2.04%, [level](/topic/level) 2.04%, [cloudflare](/topic/cloudflare) XXXX% **Top accounts mentioned or mentioned by** [@thenewstack](/creator/undefined) [@markhneedham](/creator/undefined) [@saisrirampur](/creator/undefined) [@amankabeer11](/creator/undefined) [@a_pangeran](/creator/undefined) [@rinegade](/creator/undefined) [@galaxy001en](/creator/undefined) [@nvidiadeveloper](/creator/undefined) [@tiangolo](/creator/undefined) [@streamfold](/creator/undefined) [@alibabaclouds](/creator/undefined) [@canva](/creator/undefined) [@pumpdotco](/creator/undefined) [@incidentio](/creator/undefined) [@librechatai](/creator/undefined) [@shopify](/creator/undefined) [@daimlertruck](/creator/undefined) [@cbioportal](/creator/undefined) [@ryadhdotnet](/creator/undefined) [@websummit](/creator/undefined) **Top assets mentioned** [Cloudflare, Inc. (NET)](/topic/cloudflare) ### Top Social Posts Top posts by engagements in the last XX hours "We benchmarked Snowflake Databricks ClickHouse Cloud BigQuery and Redshift across 1B 10B and 100B rows applying each vendors real compute billing rules. For analytical workloads at scale ClickHouse Cloud delivers an order-of-magnitude better value than any other system" [X Link](https://x.com/ClickHouseDB/status/1999607698690646106) 2025-12-12T22:30Z 14K followers, 499.5K engagements "When Postgres could no longer deliver the real-time speed GitLab needed the team turned to ClickHouse. Today ClickHouse powers GitLab analytics across every deployment model turning 30-second queries into sub-second insights and enabling AI-driven features like GitLab Duo" [X Link](https://x.com/ClickHouseDB/status/1982822342817636690) 2025-10-27T14:51Z 14K followers, 2.3M engagements "We just released pg_clickhouse - a PostgreSQL extension that runs your analytics queries on ClickHouse without rewriting any SQL. The hard part of migrating to ClickHouse isn't moving data (ClickPipes handles that). It's the months of analytics SQL scattered across dashboards ORMs and background jobs. pg_clickhouse solves this by making ClickHouse tables look like regular Postgres tables. Change your schema path and your queries just work - except now they execute on ClickHouse. And it's pretty fast too ⚡ Query X from TPC-H: 650ms in Postgres 67ms with pg_clickhouse" [X Link](https://x.com/ClickHouseDB/status/1998799937769787636) 2025-12-10T17:00Z 14K followers, 9685 engagements "Interested in seeing how ClickHouse works on your data Get started with ClickHouse Cloud in minutes and receive $XXX in free credits" [X Link](https://x.com/ClickHouseDB/status/1999243546168295853) 2025-12-11T22:23Z 14K followers, 88.7K engagements "System tables in ClickHouse are basically a SQL interface to the database's internal state. Want to know why a query failed Check system.query_log. Curious about merge progress Look at system.merges. Need to track down a memory issue It's all there. The post demonstrates: - How to aggregate query logs to find patterns in slow or failed queries - Using system.part_log to verify data is being written correctly - Monitoring background operations like merges and mutations - Calculating actual compression ratios for your tables Includes ready-to-use queries with real output examples" [X Link](https://x.com/ClickHouseDB/status/2000536780559327598) 2025-12-15T12:01Z 14K followers, 1403 engagements "🚀 What Python packages were trending in November 2025 We used AgentHouse + ClickPy to analyze PyPI download data from last month: 🌍 Geo distribution of downloads 📦 Top most downloaded package 🌱 Emerging tools to watch Check out the report here: Shout-out to the top X emerging packages: ⚬ Charles Leifer with Huey ⚬ @NVIDIADeveloper with tritonclient ⚬ @tiangolo with typer-slim Want to explore the data yourself or generate your own report Sign in on AgentHouse: or check ClickPy:" [X Link](https://x.com/ClickHouseDB/status/2000689179445826010) 2025-12-15T22:07Z 14K followers, 1144 engagements "Which cloud warehouse wins the cost-performance race We ran the same analytical workload across Snowflake Databricks ClickHouse Cloud BigQuery and Redshift. At 100B rows: only one stayed Fast & Low-Cost. The rest went Slow & High-Cost. Come see us at re:Invent" [X Link](https://x.com/ClickHouseDB/status/1995885820327206917) 2025-12-02T16:00Z 14K followers, 2575 engagements "Last chance to register Dont miss our Observability at Scale with ClickStack workshop happening this Wednesday. Learn how to build high-performance end-to-end observability using ClickHouse and the ClickStack ecosystem. Secure your spot now" [X Link](https://x.com/ClickHouseDB/status/1995961285758902328) 2025-12-02T21:00Z 14K followers, XXX engagements "What a night 🎉 House Party the SQL was next level and you made it happen. You showed up in record numbers and turned it into an unforgettable party.Huge thank you to the ClickHouse community for making the night so special. 🙏" [X Link](https://x.com/ClickHouseDB/status/1996313358090612855) 2025-12-03T20:19Z 14K followers, XXX engagements "Were excited to host the ClickHouse SF Meetup on December 8th at Cloudflare HQ 🚀 Well have a special talk from ClickHouse Founder Alexey Milovidov you wont want to miss it. Food drinks and sharp minds included. See you there 🙌 RSVP -" [X Link](https://x.com/ClickHouseDB/status/1996383978891211199) 2025-12-04T01:00Z 14K followers, XXX engagements "Regular SQL UPDATE statements in ClickHouse Yeah that's a thing now and it doesn't involve the usual part-rewriting gymnastics. The trick is "patch parts" lightweight deltas that get applied on the fly and merged later. @markhneedham shows you the mechanics: 🔸 UK property price data as the test case 🔸 Virtual columns and how ClickHouse tracks what changed 🔸 Querying system tables to see what's actually stored 🔸 Rule of thumb: use this for XX% updates ALTER TABLE for bigger ones Makes incremental updates way less of a headache" [X Link](https://x.com/ClickHouseDB/status/1996670913966755956) 2025-12-04T20:00Z 14K followers, 1406 engagements "Managing data lifecycles in ClickHouse doesn't require external schedulers or complex scripts. Our TTL guide explores how a single DDL clause can handle retention policies progressive aggregation compression changes and even column-level expiration. The post includes practical patterns such as keeping per-second detail for recent data while automatically rolling up to daily summaries for historical records" [X Link](https://x.com/ClickHouseDB/status/1996912810983379092) 2025-12-05T12:01Z 14K followers, 4630 engagements "Alexey said it best: We optimize ClickHouse and then optimize it again and again. XXXXX keeps that tradition alive Parallel GROUP BY merges. Projections as true secondary indexes. Faster DISTINCT. More speed everywhere" [X Link](https://x.com/ClickHouseDB/status/1996972986142748859) 2025-12-05T16:00Z 14K followers, 32.1K engagements "So you've got millions of IP addresses in your logs and you want to know where they're coming from. Turns out ClickHouse has some pretty clever tricks for this - including a dictionary type specifically designed for IP lookups (ip_trie) and some wild bitwise math to convert IP ranges into CIDR blocks. The post covers everything from importing open-source GeoIP data to creating heatmaps in Grafana. Plus there's a fun detour into XOR operations if you're into that sort of thing" [X Link](https://x.com/ClickHouseDB/status/1997999981488185604) 2025-12-08T12:01Z 14K followers, 1690 engagements "ClickHouse XXXXX ships with some quality-of-life SQL improvements. @markhneedham covers the additions: 🔸 argAndMax/argAndMin functions for getting both the extreme value and related data 🔸 Fractional LIMIT and OFFSET (write "top 10%" instead of doing percentage calculations) 🔸 cume_dist window function for cumulative distribution analysis 🔸 Three utility functions: flipCoordinates arrayRemove and midpoint" [X Link](https://x.com/ClickHouseDB/status/1998029838842572958) 2025-12-08T14:00Z 14K followers, 1006 engagements "More than XXX builders. One Saturday in NYC. At the NYC AI Agents Hackathon ClickHouse was the only database sponsor and became the default backbone for real-time agents on live data. 🏆 VitalSignal for personalized outbreak alerts 🛡 RedBot for chatbot red teaming Read the recap:" [X Link](https://x.com/ClickHouseDB/status/1998147553402192061) 2025-12-08T21:47Z 14K followers, 1115 engagements "Real-world data pipelines are messy. Files arrive out of order backfills happen and retries create chaos. ClickPipes for S3 now handles all of it. Ingest files in any order using S3 Event Notifications + SQSno more lexicographical ordering requirements. Event-driven exactly-once semantics blazing fast. 🚀" [X Link](https://x.com/ClickHouseDB/status/1998437529473761727) 2025-12-09T17:00Z 14K followers, 2460 engagements "AWS re:Invent is over. Now comes the hard part: actually choosing a data warehouse. We just published two posts comparing ClickHouse Cloud against Snowflake Databricks BigQuery and Redshift: Part 1: How each system actually bills you for compute (It's way more complicated than "pay per second") 👉 Part 2: Cost-performance at 1B 10B and 100B rows We ran ClickBench using real billing models. 👉 Yes ClickHouse came out on topdecisively. But we show the full methodology and results for all five systems. At 100B rows we had to stop testing. Not because ClickHouse hit limits but because several" [X Link](https://x.com/ClickHouseDB/status/1999117019090657447) 2025-12-11T14:00Z 14K followers, 1871 engagements "🎉ClickHouse has achieved the AWS Financial Services Competency joining a select group of AWS Partners recognized for deep expertise in serving financial services organizations. This milestone reflects our commitment to helping businesses unlock powerful insights from their data at scale. Learn more about what this means for our customers:" [X Link](https://x.com/ClickHouseDB/status/1999551386237960319) 2025-12-12T18:46Z 14K followers, 1353 engagements "From XX seconds to XXXX seconds ⚡ See how GitLab moved to ClickHouse to power real-time analytics for 50M+ users across Gitlab GitLab Dedicated and self-managed deployments" [X Link](https://x.com/ClickHouseDB/status/1982826369605152858) 2025-10-27T15:07Z 14K followers, 1.1M engagements "The open-source Agentic Data Stack is here 🔥 👉 Today were excited to share that weve joined forces with @LibreChatAI. Together ClickHouse and LibreChat form the foundation of the open-source Agentic Data Stack empowering teams to deploy AI agents that analyze and act on large datasets through natural language. And its already powering real-world applications: @Shopify uses LibreChat internally with 1000+ custom agents and 30+ MCP servers @DaimlerTruck has deployed LibreChat company-wide for secure AI access @cBioPortal built a public genomics research agent for cancer data analysis on top" [X Link](https://x.com/ClickHouseDB/status/1985755913316081760) 2025-11-04T17:07Z 14K followers, 10.5K engagements ""Everyone is saying AI AI AI. It is so boring." Alexey Milovidov opened his @WebSummit talk by loading 81.5TB of human knowledge into ClickHouse in XX minutes. Then he: * Compressed it better than Parquet (46TB 33TB) * Loaded Wikipedia in X seconds * Built style fingerprints for every website on the internet * Made 1B photos queryable in real time" [X Link](https://x.com/ClickHouseDB/status/1990397671039750441) 2025-11-17T12:32Z 14K followers, 9475 engagements "New in ClickHouse 25.10: You can now instruct secondary indices to pause during inserts and materialize later. @markhneedham shows how this works with vector similarity indexes: 🔸 13x faster inserts when skipping index creation (2s vs 26s) 🔸 Materialize indexes whenever you want with ALTER TABLE 🔸 Control behavior on inserts AND merges separately 🔸 Queries work either way just faster once indexed (8x improvement) It turns out that sometimes the best time to build an index is "not right now."" [X Link](https://x.com/ClickHouseDB/status/1999162286389227834) 2025-12-11T17:00Z 14K followers, 1503 engagements ""Just add an index" doesn't quite work the same way in ClickHouse. This post explores the actual mechanics of making queries fasterstarting with how ClickHouse's sparse primary indexes use binary search across granules instead of individual rows. The practical bits: - Using projections as automatically-synced "hidden tables" with different sort orders - When pre-computing aggregates actually helps (and when it's overkill) - Why increasing max_threads from X to XX doubled query speed but increased memory usage by XX% It's a technical deep dive but with concrete examples you can actually try" [X Link](https://x.com/ClickHouseDB/status/1999450007737405870) 2025-12-12T12:03Z 14K followers, 1675 engagements "EMQ enables real-time data integration. ClickHouse makes it possible to process large-scale data in real time. Read how @EMQTech is using @ClickHouseDB to power AI-assisted analytics for the intelligent data-driven factories of the future 👇" [X Link](https://x.com/ClickHouseDB/status/2000611838870913120) 2025-12-15T17:00Z 14K followers, 1291 engagements ""We've consistently run into scaling and performance bottlenecks that limited our ability to deliver the kind of analytics features our users needed. ClickHouse gave us the breakthrough we needed to deliver the kind of features wed been holding back." - Dennis Tang GitLab" [X Link](https://x.com/ClickHouseDB/status/1982822342884831657) 2025-10-27T14:51Z 14K followers, 2.5M engagements "At Netflix scale drives everything. Their logging system ingests X PB/day averaging 10M+ events/sec across 40K+ microservices to serve 300M+ subscribers. See how they did it with some key optimizations in fingerprinting serialization and queries" [X Link](https://x.com/ClickHouseDB/status/1982826369299120582) 2025-10-27T15:07Z 14K followers, 8.9M engagements "Some of the most interesting performance work never fits into release notes. This post is a first-person engineering write-up on how ClickHouse parallelized aggregation merges for FixedHashMap-based GROUP BY queries including what didnt work what broke and how the final design emerged" [X Link](https://x.com/ClickHouseDB/status/2000959210834571593) 2025-12-16T16:00Z 14K followers, 5779 engagements
[GUEST ACCESS MODE: Data is scrambled or limited to provide examples. Make requests using your API key to unlock full data. Check https://lunarcrush.ai/auth for authentication information.]
@ClickHouseDB ClickHouse
ClickHouse posts on X about clickhouse, realtime, snowflake, databricks the most. They currently have XXXXXX followers and XX posts still getting attention that total XXXXXXX engagements in the last XX hours.
Engagements: XXXXXXX #
- X Week XXXXXXXXX +24%
- X Month XXXXXXXXX +390%
- X Months XXXXXXXXX +3,130%
- X Year XXXXXXXXX +11%
Mentions: XX #
- X Week XX -XXXX%
- X Month XX -XX%
- X Months XXX +33%
- X Year XXX -XX%
Followers: XXXXXX #
- X Week XXXXXX +0.61%
- X Month XXXXXX +3.80%
- X Months XXXXXX +30%
- X Year XXXXXX +44%
CreatorRank: XXXXXX #
Social Influence
Social category influence technology brands XXXX% events #647 stocks XXXX%
Social topic influence clickhouse #1, realtime #7, snowflake #90, databricks #11, ai 6.12%, jobs 2.04%, credits 2.04%, shoutout 2.04%, level 2.04%, cloudflare XXXX%
Top accounts mentioned or mentioned by @thenewstack @markhneedham @saisrirampur @amankabeer11 @a_pangeran @rinegade @galaxy001en @nvidiadeveloper @tiangolo @streamfold @alibabaclouds @canva @pumpdotco @incidentio @librechatai @shopify @daimlertruck @cbioportal @ryadhdotnet @websummit
Top assets mentioned Cloudflare, Inc. (NET)
Top Social Posts
Top posts by engagements in the last XX hours
"We benchmarked Snowflake Databricks ClickHouse Cloud BigQuery and Redshift across 1B 10B and 100B rows applying each vendors real compute billing rules. For analytical workloads at scale ClickHouse Cloud delivers an order-of-magnitude better value than any other system"
X Link 2025-12-12T22:30Z 14K followers, 499.5K engagements
"When Postgres could no longer deliver the real-time speed GitLab needed the team turned to ClickHouse. Today ClickHouse powers GitLab analytics across every deployment model turning 30-second queries into sub-second insights and enabling AI-driven features like GitLab Duo"
X Link 2025-10-27T14:51Z 14K followers, 2.3M engagements
"We just released pg_clickhouse - a PostgreSQL extension that runs your analytics queries on ClickHouse without rewriting any SQL. The hard part of migrating to ClickHouse isn't moving data (ClickPipes handles that). It's the months of analytics SQL scattered across dashboards ORMs and background jobs. pg_clickhouse solves this by making ClickHouse tables look like regular Postgres tables. Change your schema path and your queries just work - except now they execute on ClickHouse. And it's pretty fast too ⚡ Query X from TPC-H: 650ms in Postgres 67ms with pg_clickhouse"
X Link 2025-12-10T17:00Z 14K followers, 9685 engagements
"Interested in seeing how ClickHouse works on your data Get started with ClickHouse Cloud in minutes and receive $XXX in free credits"
X Link 2025-12-11T22:23Z 14K followers, 88.7K engagements
"System tables in ClickHouse are basically a SQL interface to the database's internal state. Want to know why a query failed Check system.query_log. Curious about merge progress Look at system.merges. Need to track down a memory issue It's all there. The post demonstrates: - How to aggregate query logs to find patterns in slow or failed queries - Using system.part_log to verify data is being written correctly - Monitoring background operations like merges and mutations - Calculating actual compression ratios for your tables Includes ready-to-use queries with real output examples"
X Link 2025-12-15T12:01Z 14K followers, 1403 engagements
"🚀 What Python packages were trending in November 2025 We used AgentHouse + ClickPy to analyze PyPI download data from last month: 🌍 Geo distribution of downloads 📦 Top most downloaded package 🌱 Emerging tools to watch Check out the report here: Shout-out to the top X emerging packages: ⚬ Charles Leifer with Huey ⚬ @NVIDIADeveloper with tritonclient ⚬ @tiangolo with typer-slim Want to explore the data yourself or generate your own report Sign in on AgentHouse: or check ClickPy:"
X Link 2025-12-15T22:07Z 14K followers, 1144 engagements
"Which cloud warehouse wins the cost-performance race We ran the same analytical workload across Snowflake Databricks ClickHouse Cloud BigQuery and Redshift. At 100B rows: only one stayed Fast & Low-Cost. The rest went Slow & High-Cost. Come see us at re:Invent"
X Link 2025-12-02T16:00Z 14K followers, 2575 engagements
"Last chance to register Dont miss our Observability at Scale with ClickStack workshop happening this Wednesday. Learn how to build high-performance end-to-end observability using ClickHouse and the ClickStack ecosystem. Secure your spot now"
X Link 2025-12-02T21:00Z 14K followers, XXX engagements
"What a night 🎉 House Party the SQL was next level and you made it happen. You showed up in record numbers and turned it into an unforgettable party.Huge thank you to the ClickHouse community for making the night so special. 🙏"
X Link 2025-12-03T20:19Z 14K followers, XXX engagements
"Were excited to host the ClickHouse SF Meetup on December 8th at Cloudflare HQ 🚀 Well have a special talk from ClickHouse Founder Alexey Milovidov you wont want to miss it. Food drinks and sharp minds included. See you there 🙌 RSVP -"
X Link 2025-12-04T01:00Z 14K followers, XXX engagements
"Regular SQL UPDATE statements in ClickHouse Yeah that's a thing now and it doesn't involve the usual part-rewriting gymnastics. The trick is "patch parts" lightweight deltas that get applied on the fly and merged later. @markhneedham shows you the mechanics: 🔸 UK property price data as the test case 🔸 Virtual columns and how ClickHouse tracks what changed 🔸 Querying system tables to see what's actually stored 🔸 Rule of thumb: use this for XX% updates ALTER TABLE for bigger ones Makes incremental updates way less of a headache"
X Link 2025-12-04T20:00Z 14K followers, 1406 engagements
"Managing data lifecycles in ClickHouse doesn't require external schedulers or complex scripts. Our TTL guide explores how a single DDL clause can handle retention policies progressive aggregation compression changes and even column-level expiration. The post includes practical patterns such as keeping per-second detail for recent data while automatically rolling up to daily summaries for historical records"
X Link 2025-12-05T12:01Z 14K followers, 4630 engagements
"Alexey said it best: We optimize ClickHouse and then optimize it again and again. XXXXX keeps that tradition alive Parallel GROUP BY merges. Projections as true secondary indexes. Faster DISTINCT. More speed everywhere"
X Link 2025-12-05T16:00Z 14K followers, 32.1K engagements
"So you've got millions of IP addresses in your logs and you want to know where they're coming from. Turns out ClickHouse has some pretty clever tricks for this - including a dictionary type specifically designed for IP lookups (ip_trie) and some wild bitwise math to convert IP ranges into CIDR blocks. The post covers everything from importing open-source GeoIP data to creating heatmaps in Grafana. Plus there's a fun detour into XOR operations if you're into that sort of thing"
X Link 2025-12-08T12:01Z 14K followers, 1690 engagements
"ClickHouse XXXXX ships with some quality-of-life SQL improvements. @markhneedham covers the additions: 🔸 argAndMax/argAndMin functions for getting both the extreme value and related data 🔸 Fractional LIMIT and OFFSET (write "top 10%" instead of doing percentage calculations) 🔸 cume_dist window function for cumulative distribution analysis 🔸 Three utility functions: flipCoordinates arrayRemove and midpoint"
X Link 2025-12-08T14:00Z 14K followers, 1006 engagements
"More than XXX builders. One Saturday in NYC. At the NYC AI Agents Hackathon ClickHouse was the only database sponsor and became the default backbone for real-time agents on live data. 🏆 VitalSignal for personalized outbreak alerts 🛡 RedBot for chatbot red teaming Read the recap:"
X Link 2025-12-08T21:47Z 14K followers, 1115 engagements
"Real-world data pipelines are messy. Files arrive out of order backfills happen and retries create chaos. ClickPipes for S3 now handles all of it. Ingest files in any order using S3 Event Notifications + SQSno more lexicographical ordering requirements. Event-driven exactly-once semantics blazing fast. 🚀"
X Link 2025-12-09T17:00Z 14K followers, 2460 engagements
"AWS re:Invent is over. Now comes the hard part: actually choosing a data warehouse. We just published two posts comparing ClickHouse Cloud against Snowflake Databricks BigQuery and Redshift: Part 1: How each system actually bills you for compute (It's way more complicated than "pay per second") 👉 Part 2: Cost-performance at 1B 10B and 100B rows We ran ClickBench using real billing models. 👉 Yes ClickHouse came out on topdecisively. But we show the full methodology and results for all five systems. At 100B rows we had to stop testing. Not because ClickHouse hit limits but because several"
X Link 2025-12-11T14:00Z 14K followers, 1871 engagements
"🎉ClickHouse has achieved the AWS Financial Services Competency joining a select group of AWS Partners recognized for deep expertise in serving financial services organizations. This milestone reflects our commitment to helping businesses unlock powerful insights from their data at scale. Learn more about what this means for our customers:"
X Link 2025-12-12T18:46Z 14K followers, 1353 engagements
"From XX seconds to XXXX seconds ⚡ See how GitLab moved to ClickHouse to power real-time analytics for 50M+ users across Gitlab GitLab Dedicated and self-managed deployments"
X Link 2025-10-27T15:07Z 14K followers, 1.1M engagements
"The open-source Agentic Data Stack is here 🔥 👉 Today were excited to share that weve joined forces with @LibreChatAI. Together ClickHouse and LibreChat form the foundation of the open-source Agentic Data Stack empowering teams to deploy AI agents that analyze and act on large datasets through natural language. And its already powering real-world applications: @Shopify uses LibreChat internally with 1000+ custom agents and 30+ MCP servers @DaimlerTruck has deployed LibreChat company-wide for secure AI access @cBioPortal built a public genomics research agent for cancer data analysis on top"
X Link 2025-11-04T17:07Z 14K followers, 10.5K engagements
""Everyone is saying AI AI AI. It is so boring." Alexey Milovidov opened his @WebSummit talk by loading 81.5TB of human knowledge into ClickHouse in XX minutes. Then he: * Compressed it better than Parquet (46TB 33TB) * Loaded Wikipedia in X seconds * Built style fingerprints for every website on the internet * Made 1B photos queryable in real time"
X Link 2025-11-17T12:32Z 14K followers, 9475 engagements
"New in ClickHouse 25.10: You can now instruct secondary indices to pause during inserts and materialize later. @markhneedham shows how this works with vector similarity indexes: 🔸 13x faster inserts when skipping index creation (2s vs 26s) 🔸 Materialize indexes whenever you want with ALTER TABLE 🔸 Control behavior on inserts AND merges separately 🔸 Queries work either way just faster once indexed (8x improvement) It turns out that sometimes the best time to build an index is "not right now.""
X Link 2025-12-11T17:00Z 14K followers, 1503 engagements
""Just add an index" doesn't quite work the same way in ClickHouse. This post explores the actual mechanics of making queries fasterstarting with how ClickHouse's sparse primary indexes use binary search across granules instead of individual rows. The practical bits: - Using projections as automatically-synced "hidden tables" with different sort orders - When pre-computing aggregates actually helps (and when it's overkill) - Why increasing max_threads from X to XX doubled query speed but increased memory usage by XX% It's a technical deep dive but with concrete examples you can actually try"
X Link 2025-12-12T12:03Z 14K followers, 1675 engagements
"EMQ enables real-time data integration. ClickHouse makes it possible to process large-scale data in real time. Read how @EMQTech is using @ClickHouseDB to power AI-assisted analytics for the intelligent data-driven factories of the future 👇"
X Link 2025-12-15T17:00Z 14K followers, 1291 engagements
""We've consistently run into scaling and performance bottlenecks that limited our ability to deliver the kind of analytics features our users needed. ClickHouse gave us the breakthrough we needed to deliver the kind of features wed been holding back." - Dennis Tang GitLab"
X Link 2025-10-27T14:51Z 14K followers, 2.5M engagements
"At Netflix scale drives everything. Their logging system ingests X PB/day averaging 10M+ events/sec across 40K+ microservices to serve 300M+ subscribers. See how they did it with some key optimizations in fingerprinting serialization and queries"
X Link 2025-10-27T15:07Z 14K followers, 8.9M engagements
"Some of the most interesting performance work never fits into release notes. This post is a first-person engineering write-up on how ClickHouse parallelized aggregation merges for FixedHashMap-based GROUP BY queries including what didnt work what broke and how the final design emerged"
X Link 2025-12-16T16:00Z 14K followers, 5779 engagements