[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 Avatar @ClickHouseDB ClickHouse

ClickHouse posts on X about clickhouse, realtime, ai, level the most. They currently have XXXXXX followers and XX posts still getting attention that total XXXXXXX engagements in the last XX hours.

Engagements: XXXXXXX #

Engagements Line Chart

Mentions: XX #

Mentions Line Chart

Followers: XXXXXX #

Followers Line Chart

CreatorRank: XXXXXX #

CreatorRank Line Chart

Social Influence

Social category influence technology brands XX% countries X% events #184 finance X% stocks X%

Social topic influence clickhouse #1, realtime #7, ai 10%, level 6%, snowflake #203, databricks #11, indonesia 4%, agentic #365, alerts #861, to the X%

Top accounts mentioned or mentioned by @markhneedham @carllindesvard @thenewstack @a_pangeran @galaxy001en @rinegade @amankabeer11 @chronark @benjaminwootton @mspartner @klaviyo @fabfunnel @alibabaclouds @canva @incidentio @websummit @streamfold @pumpdotco @saisrirampur @librechatai

Top assets mentioned Cloudflare, Inc. (NET)

Top Social Posts

Top posts by engagements in the last XX hours

"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, 32K engagements

"From ad bidding to AI incident command to glucose forecasting: see how teams used ClickHouse for realtime agents at the AWS MCP Hackathon in San Francisco. ⚡ Recap + spotlights"
X Link 2025-11-20T20:00Z 14K followers, XXX engagements

"A few years back we introduced ClickHouse Fiddle: a SQL playground where you can test queries without installing anything 💻 It's still one of the fastest ways to experiment with ClickHouse: 🔹 Run queries on any ClickHouse version from your browser 🔹 Create tables insert data and execute DDL statements 🔹 Share results with a unique link 🔹 Isolated execution via Docker containers (your data stays private) 🔹 Typical query execution in X seconds The architecture is elegant: for each request a fresh Docker container spins up with your chosen ClickHouse version runs your queries and gets torn"
X Link 2025-11-21T14:01Z 14K followers, 1750 engagements

"Are you joining the ClickHouse XXXXX Release Call this week There is feature overviews live demos time for Q&A. I bet you can find the changelog if you peruse our GitHub"
X Link 2025-11-24T12:55Z 14K followers, 1243 engagements

"Testing databases is hard. Testing them well is even harder. Earlier this year we shared how BuzzHouse was built to bridge a specific gap: generating complex correct SQL queries to find bugs that other fuzzers miss. The deep dive covers: - The fundamental challenges of database fuzzing (hint: TPC-H Q5 is a great example) - Different strategies for finding wrong results not just crashes - Why code coverage-guided fuzzing isn't always the answer - How probability distributions affect what bugs you'll ever find 100+ issues discovered and counting. The post offers a fascinating insight into the"
X Link 2025-11-24T14:01Z 14K followers, 1485 engagements

"Today is the XXXXX release & community call. Feature overview live demos Q&A. Will you be there"
X Link 2025-11-25T11:49Z 14K followers, 1387 engagements

"Join us for our year-end ClickHouse meetup in Jakarta 🎉 Come hang out with the community swap stories from 2025 and get a sneak peek of whats coming next. 📍 GoWork Plaza Indonesia Level X 📅 Tuesday December X 6:30 PM (start with networking and light dinner) Spots are limitedsave your seat and celebrate the end of the year with us 🚀"
X Link 2025-11-26T09:57Z 14K followers, 1030 engagements

"🍂 Thanksgiving dinner and production logs have something in common: there's a LOT to digest. Event Patterns in ClickStack help you sample what matters - automatically clustering similar logs surfacing anomalies and cutting through the noise. Its like having someone pre-slice the turkey so you can focus on whats actually important. Built on Drain3 running in your browser analyzing 10000 events in seconds. No prep work required"
X Link 2025-11-26T16:06Z 14K followers, 1376 engagements

"ClickHouse XXXXX added three SQL features that won't change your life but will definitely clean up some ugly queries. 🔸 IS NOT DISTINCT FROM for null comparisons that actually return true/false 🔸 Negative LIMIT and OFFSET to grab recent rows without ORDER BY gymnastics 🔸 LIMIT BY ALL as shorthand for multi-column deduplication @markhneedham walks through practical examples with UK property sales data"
X Link 2025-11-27T16:00Z 14K followers, 2338 engagements

"💡 Meet Us at @alibaba_cloud's SME AI Growth Day in Singapore on Thursday December X at Capital Tower Were excited to be joining Alibaba Clouds SME AI Growth Day where well be showcasing how ClickHouse Cloud brings lightning-fast scalable analytics to AI-driven businesses. Swing by our booth to chat with the team catch live demos and see how ClickHouse can help SMEs innovate and grow with data. Find out more at"
X Link 2025-11-28T03:01Z 14K followers, 1097 engagements

"Ever wondered what XXX billion test results look like Turns out: a Christmas tree. We run 5-9 million tests daily in ClickHouse and we've been saving every result since 2020. But here's the twistwe don't mute flaky tests. We make them more flaky on purpose. This post covers our counterintuitive approach to test reliability: - Why we randomize thread scheduling and add random sleeps - How we run new tests XXX times before merging - Why "maximum flakiness" actually prevents flaky tests Plus: an interactive visualization of XXX days 3772 tests that genuinely looks like a Christmas tree (with a"
X Link 2025-11-28T14:01Z 14K followers, 1505 engagements

"Ever needed to generate test data that actually looks. realistic Turns out ClickHouse has some surprisingly powerful random data generation functions. We're talking normal distributions Poisson distributions exponential curvesthe whole statistical toolkit. This post walks through: How to generate data that gravitates toward specific values (like real data does) Simulating time-based patterns with peaks and valleys Creating multi-modal distributions for seasonal trends Even adding realistic "noise" and errors to your test data Includes practical examples like generating clickstream data"
X Link 2025-12-01T12:00Z 14K followers, 1387 engagements

"Snowflake credits Databricks DBUs ClickHouse Cloud compute units BigQuery slots Redshift RPUs. Your bill depends on the engine not the runtime. We just published the clearest guide yet to how all X major cloud data warehouses turn queries into dollars. Perfect timing for #reinvent2025 Part X (the winner reveal) drops tomorrow 👀"
X Link 2025-12-01T16:00Z 14K followers, 1268 engagements

"Every second @canva generates 3M spans + 3M logs for 240M+ users and those numbers are doubling YoY 🤯 Their move to @ClickHouseDB delivered: ✔ XX% cheaper storage ✔ 10x faster search ✔ A better logging experience for engineers"
X Link 2025-12-01T20:00Z 14K followers, 25.6K engagements

"Say hello to clickhousebuild - the open source agentic CLI that helps you add ClickHouse to your existing Postgres-backed TypeScript application"
X Link 2025-12-02T17:33Z 14K followers, XXX 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

""Was it always this slow" ClickStack's new period comparison feature lets you overlay current performance with that of the previous period. No more squinting at graphs trying to remember what last week looked like. Also new in November: 🔸 @incident_io integration - route alerts directly no webhook config needed 🔸 Service Maps (beta) - visualize traffic flows and dependencies across your distributed system 🔸 Root span filtering - see only top-level spans in search results 🔸 Highlighted attributes - surface key fields instantly in traces and logs"
X Link 2025-12-04T17: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, 1383 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, 8306 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, 9453 engagements

"Can you 4x OTel thoughput with Rust Meet Rotel: pushing 460K spans/sec/core (vs 130k) The @streamfold team told us how it works - ClickHouse is fast at ingesting OpenTelemetry data - so fast that ingestion layers sometimes struggle to keep up. The OTel Collector can be resource-intensive and at petabyte scale every CPU cycle counts. Rotel is a lightweight OpenTelemetry collector implemented in Rust that can 4x throughput vs the standard OTel Collector while dramatically reducing CPU overhead. How By diving deep into Rust's threading model resolving allocator lock contention and reengineering"
X Link 2025-11-25T18:06Z 14K followers, 2228 engagements

"Jakarta Were headed your way Tuesday December X with two events same venue same day 📍 GoWork Plaza Indonesia Level X ☀ 2:005:00 PM: Hands-on Real-Time Analytics Workshop (Level 1) Few seats left register now: 🌙 6:308:30 PM: Year-End Database Meetup Featuring experts from Verihubs & Electrum RSVP: See you there 🚀"
X Link 2025-12-02T04:24Z 14K followers, XXX 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, 2538 engagements

"Ever found yourself staring at AWS Cost Explorer wondering why your cloud costs jumped XX% overnight See how @pumpdotco used @ClickHouseDB to build Pump View turning 5B records/day into fast searchable views for real-time cost visibility 👇"
X Link 2025-12-03T12:15Z 14K followers, XXX engagements

"From the outside Change Data Capture (CDC) appears straightforward - 'just read the WAL' - but real-world workloads reveal a very different reality. @saisrirampur (PeerDB founder) with an honest technical retrospective on a year of Postgres CDC in production. 100x customer growth 400+ companies 200TB of monthly data. However the real story lies in solving replication slot backpressure long-running transactions and the edge cases that only become apparent at midnight. Full breakdown of what shipped what broke and what's next"
X Link 2025-12-03T17:49Z 14K followers, 1309 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

"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, 4578 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, 1642 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, XXX engagements

"Were leaving re:Invent this year feeling incredibly grateful. Our booth was full from start to finish and our House Party reached capacity thanks to the amazing community that showed up with curiosity ideas and enthusiasm. To everyone who stopped by shared feedback asked questions or just came to connect: thank you. Your support and passion continue to shape the future of real-time analytics with ClickHouse. We appreciate you and we cant wait for whats ahead. 💛🚀 Ready to keep the momentum going Dive into our latest benchmarks blogs and user stories"
X Link 2025-12-08T18:33Z 14K followers, XXX 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, 1.9M 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.1M 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.3M 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, 9851 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, 1053 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, 2379 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, XXX 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, XXX engagements