[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](/creator/twitter/ClickHouseDB)
"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/1981725616329326806) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-24T14:13Z 13.1K followers, 860.3K engagements


"Shout out to Todd Stoffel for this independent analytics benchmark 👏 We know firsthand how much effort it takes to prepare datasets and queries to run fairly across multiple DBMS. While we love seeing ClickHouse top the charts benchmarks always leave us with one thought: could we be even faster"  
[X Link](https://x.com/ClickHouseDB/status/1983927049828929659) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T16:00Z 13.1K followers, XXX engagements


"And we are live with the XXXXX release call I've seen the slides; this is one you will want to see. Join us for the livestream (a thread)"  
[X Link](https://x.com/ClickHouseDB/status/1983927316259455105) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T16:01Z 13.1K followers, 2521 engagements


"We've also added the 'conv' function to convert numbers between different bases.super important if you are looking for compatibility with MySQL"  
[X Link](https://x.com/ClickHouseDB/status/1983929095277760983) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T16:08Z 13.1K followers, XXX engagements


"ClickHouse already supports a LIMIT BY clause which is an extension to DISTINCT. Example: LIMIT X BY country take only first X records for each distinct country. Now you can write LIMIT X BY ALL take up to X duplicate records"  
[X Link](https://x.com/ClickHouseDB/status/1983929373590724902) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T16:09Z 13.1K followers, XXX engagements


"SELECT * FROM 'section_next'"  
[X Link](https://x.com/ClickHouseDB/status/1983936204065145125) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T16:37Z 13.1K followers, XXX engagements


"Ever have a desire to get the most recent XXX records and output them ordered by time You are probably storing logs in ClickHouse ;) :) SELECT * FROM logs WHERE date = today() ORDER BY time LIMIT -100;"  
[X Link](https://x.com/ClickHouseDB/status/1983936466637000921) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T16:38Z 13.1K followers, XXX engagements


"We also introduce a new datatype - Qbit I would try to explain. But I still need to wrap my head around it"  
[X Link](https://x.com/ClickHouseDB/status/1983937285276979404) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T16:41Z 13.1K followers, XXX engagements


"And this demo is amazing. In summary: QBit lets you control how many bits of a float are used for distance calculations in vector search. This means you can now adjust the precision/speed trade-off at runtime no upfront decisions"  
[X Link](https://x.com/ClickHouseDB/status/1983938288499998765) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T16:45Z 13.1K followers, XXX engagements


"We now spend some time on talking about Data Lakes. ClickHouse now has table functions to support querying from Apache Paimon"  
[X Link](https://x.com/ClickHouseDB/status/1983940239124058383) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T16:53Z 13.1K followers, XX engagements


"And of course more improvements for the work we are doing with @ApacheIceberg"  
[X Link](https://x.com/ClickHouseDB/status/1983940384368578846) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T16:53Z 13.1K followers, XX engagements


"@ApacheIceberg And now some extra things. check out"  
[X Link](https://x.com/ClickHouseDB/status/1983940633929592913) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T16:54Z 13.1K followers, XX engagements


"@ApacheIceberg Also if you are going to #awsreinvent you won't want to miss House Party The SQL"  
[X Link](https://x.com/ClickHouseDB/status/1983940844672401760) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T16:55Z 13.1K followers, XXX engagements


"The ClickHouse team is heading to dbt Coalesce next week in Las Vegas 🎲 Come meet us at our booth to chat all things analytics performance and the modern data stack or join us for an exclusive dinner with Lightdash for a more relaxed evening with great food and conversation. Spots are limited request your invite here:"  
[X Link](https://x.com/ClickHouseDB/status/1976699510366650611) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-10T17:21Z 13K followers, 1594 engagements


"Can you believe it's already been over a year since we published our first research paper at VLDB From storage layers to query processing the paper breaks it all down. Curious about our history integrations or how we compare to other databases It's all here complete with colorful diagrams and eye-opening benchmarks"  
[X Link](https://x.com/ClickHouseDB/status/1982794661426069905) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-27T13:01Z 13K followers, 1847 engagements


"AI agents making weird decisions We've all been there 😅 In our latest blog post @markhneedham demonstrates how to instrument OpenAI agents with CickStack. Watch agents query GitHub data trace every function call and spot where things go wrong. Spoiler: It's often in the SQL generation"  
[X Link](https://x.com/ClickHouseDB/status/1982873168906711322) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-27T18:12Z 13K followers, 1316 engagements


"The ClickHouse crew had an amazing time at @alibaba_cloud Apsara Conference in Hangzhou 🚀 Packed sessions deep dives into real-time analytics & high-performance data processing and tons of great discussions with the community 🙌 Missed it See how Changan Ford cut costs by XX% with ClickHouse 👉"  
[X Link](https://x.com/ClickHouseDB/status/1976266201228771828) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-09T12:39Z 13K followers, 1629 engagements


"The ClickHouse JSON type was already fast but v25.8 made it 58x faster and use 3300x less memory. The problem: JSON docs with 10000+ unique paths killed performance. The solution 200k rows 10k paths: ⚡ 3.63s 0.063s 💾 XXXXX GiB XXXX MiB"  
[X Link](https://x.com/ClickHouseDB/status/1976316816185061716) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-09T16:00Z 13K followers, 6043 engagements


"Like night and daythats how @mayankistyping describes his teams move from Postgres to @ClickHouseDB. See how @AuditzyInsights cut query times by 33x (10s 300ms) shrank storage by 10x and built a stronger foundation for real-time analytics 👇"  
[X Link](https://x.com/ClickHouseDB/status/1976467772906369316) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-10T02:00Z 13K followers, 1554 engagements


"🚨 Last chance Join us tomorrow for our hands-on ClickStack Workshop (APJ-friendly 🌏) Learn to ingest + analyze observability data at scale using ClickStack powered by ClickHouse ⚡ Deploy locally run real queries & earn your Observability Associate badge 👉"  
[X Link](https://x.com/ClickHouseDB/status/1977554951212576911) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-13T02:00Z 13K followers, 1877 engagements


"Flashback to when we tackled @gunnarmorling's billion-row adventure ⚡ Remember when the One Billion Row Challenge was everywhere We couldn't resist putting ClickHouse to the test. From generating data 6.8x faster to crunching numbers in record time it was amazing to see how ClickHouse rose to the occasion. Take a trip down memory lane with our blog post about this epic big data challenge"  
[X Link](https://x.com/ClickHouseDB/status/1977690964257919154) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-13T11:00Z 13K followers, 1492 engagements


"Announcing external backups in ClickHouse Cloud. Export full daily backups to your own storage (AWS GCP Azure) so you control retention region and costs. Restore with a templated SQL command. Details and setup guide -"  
[X Link](https://x.com/ClickHouseDB/status/1978219934040592750) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-14T22:02Z 13K followers, 1443 engagements


"Throwback: Feature stores - What are they good for Quite a lot actually ⚡ Looking back at our blog post that broke down: 🔸The basics of feature stores 🔸Why you might (or might not) need one 🔸How ClickHouse could simplify your ML data architecture Plus we announced our integration with Featureform back then. Still relevant today - give it a read"  
[X Link](https://x.com/ClickHouseDB/status/1979140862283071877) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-17T11:02Z 13K followers, 1096 engagements


"🚀 Why @ClickHouseDB certification goes beyond just technical skills Nemanja from @profiqtw shares how their engineers use ClickHouse certification to: ✅ Build deep problem-solving expertise (not just exam tricks) ✅ Signal credibility to customers & partners ✅ Access free hands-on training with real labs Key tip: Master the docs - you'll need them during the 2-hour open-book exam"  
[X Link](https://x.com/ClickHouseDB/status/1979185731999297987) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-17T14:00Z 13K followers, 2052 engagements


"🚀 October ClickHouse Newsletter is live Real-world wins + major tech advances: 33x faster queries: Auditzy's PostgreSQL ClickHouse migration New streaming text index in XXXX @laravelphp Nightwatch: 500M events 97ms dashboards 1450x TPC-H speedups via auto join reordering Enhanced Apache Iceberg support Plus deep dives on scaling OLAP modeling and React APIs. Huge thanks to all contributors and our featured community member Mayank Joshi 🙏"  
[X Link](https://x.com/ClickHouseDB/status/1979246135639187573) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-17T18:00Z 13K followers, 1542 engagements


"Throwback to our SQL wizardry 🧙 Ever wished you could select columns in ClickHouse without typing them all out Our blog on Dynamic Column Selection might just be the magic spell you need. Discover how to make your queries smarter not harder"  
[X Link](https://x.com/ClickHouseDB/status/1980227629711048784) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-20T11:00Z 13K followers, 1637 engagements


". @GitLab's winning combo: Postgres for OLTP + ClickHouse for analytics 🧠 Multi-layer joins over 100M+ rows: Before: 30-40 seconds 🐌 After: XXXX seconds 🚀"  
[X Link](https://x.com/ClickHouseDB/status/1980674938907296146) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-21T16:37Z 13K followers, 1112 engagements


"🗽 The NYC Open House videos are live Just dropped the recordings from our October 7th ClickHouse Open House in New York featuring incredible customer stories from @CapitalOne @tryramp and @modal. 🏦 Capital One cut infrastructure costs by XX% and improved dashboard response times by XX% with their Slingshot platform 💰 Ramp turned slow Postgres queries into reports running hundreds of times faster (spoiler: the entire OLAP team got promoted) ☁ Modal delivers instant search across 500+ billion logs using ClickHouse as their observability backbone"  
[X Link](https://x.com/ClickHouseDB/status/1980731185627037920) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-21T20:21Z 13K followers, 1015 engagements


"@mvcinvesting In case anyone wants to read the full story -"  
[X Link](https://x.com/ClickHouseDB/status/1981384263389135009) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-23T15:36Z 13K followers, 2314 engagements


"💡 Three weeks ago we gathered an amazing community of data enthusiasts engineers and ClickHouse users for a day filled with innovation learning and connection in Bangalore for our very first user conference roadshow. Big thanks to our incredible community speakers & partners for making it such a success. 🙌 🎥 Watch the highlight video & relive the best moments On-demand talks coming soon so stay tuned"  
[X Link](https://x.com/ClickHouseDB/status/1983036139674939524) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-28T05:00Z 13K followers, 1287 engagements


"ClickHouse XXXX dropped a few months back with some serious Wall Street vibes - new financial functions that are worth revisiting. @markhneedham breaks it down without the suit and tie: 🔸 IRR: Calculate your investment's yearly return (Apple stock anyone) 🔸 NPV: Time travel for your money - see what future cash is worth now 🔸 Extended versions for when you need to get extra precise with dates"  
[X Link](https://x.com/ClickHouseDB/status/1981058093371826367) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-22T18:00Z 13K followers, 1217 engagements


"Us: Column storage is amazing at compressing data Also us: ClickHouse uses column storage Also also us: ClickHouse compressed nginx logs making them 178x smaller 20GB 109MB. Sometimes the numbers just speak for themselves ✨"  
[X Link](https://x.com/ClickHouseDB/status/1981450587737591943) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-23T20:00Z 13K followers, 1695 engagements


"Last chance to register for Open House AmsterdamJoin us Oct XX at ARTIS Royal Zoo for a full day of ClickHouse talks technical deep dives and networking with the community. - Hear from Alexey Milovidov CTO & Founder - Hear from our amazing customers Picnic Technologies Lovable Silverflow Langfuse - Sessions on real-time analytics AI/ML observability & data warehousing - AMAs with ClickHouse engineers - Networking drinks to cap it off Registration closes soon. Secure your FREE spot now 👇"  
[X Link](https://x.com/ClickHouseDB/status/1981662836167225803) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-24T10:03Z 13K followers, 1348 engagements


"Modern observability is built on a flawed foundation three siloed pillars: logs metrics and traces. At SRE Days Cologne (Oct 28) Vlad Seliverstov from ClickHouse will share how were rethinking observability as a data problem one that needs fast high-cardinality queries over unsampled data at scale and low cost. Join Vlads talk to learn how ClickStack our fully open source OpenTelemetry-native observability stack delivers real-time visibility without compromise"  
[X Link](https://x.com/ClickHouseDB/status/1982839778019017104) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-27T16:00Z 13K followers, 1461 engagements


"When Raufs Dunamalijevs writes about the new Qbit data type he developed you get the real engineering story. His deep dive presents a new approach for hybrid vector search with serious technical depth covering: * Decomposed storage of floating-point values in bit planes * Vectorization of the transposing and un-transposing code * Real-world impact: 1.157s 0.271s query time 6.05GB 739MB memory QBit eliminates the painful choice of making irreversible quantization decisions upfront. Worth trying on your own vector workloads in XXXXX out later this week"  
[X Link](https://x.com/ClickHouseDB/status/1983212990464757801) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-28T16:43Z 13K followers, 1756 engagements


"Excited to announce series C financing extension and expansion of the leadership team at ClickHouse We passed 2000 customers and more than quadrupled ARR over the past year adding companies like Anthropic Cyera Hewlett Packard Enterprise Insider LangChain Laravel Masorange Meta Qualified Shopmonkey Sierra Supabase Vercel Weights & Biases and many more to the list of organizations building their AI-powered businesses on top of ClickHouse. Many thanks to our new investors: @CitiVentures (@vibhorrastogi) @insightpartners (John Wolff) @peakxvpartners (Shailendra Singh) @FoundersCC (@mikej0000)"  
[X Link](https://x.com/ClickHouseDB/status/1975555616941699556) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-07T13:35Z 13.1K followers, 62K engagements


"❓ What if you could. - Classify text with machine learning in pure SQL - Search vectors with configurable precision - Write cleaner queries with new syntax shortcuts - Query Apache Paimon data lakes natively ClickHouse XXXXX makes it all possible 🎯 Curious how Join our community call on 30th October @ 9am PDT/5pm CET"  
[X Link](https://x.com/ClickHouseDB/status/1983534333626392623) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-29T14:00Z 13.1K followers, 1873 engagements


"@ApacheIceberg As always we close with time for Q&A"  
[X Link](https://x.com/ClickHouseDB/status/1983941849078206889) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T16:59Z 13.1K followers, XXX engagements


"@ApacheIceberg And that's a wrap Thank you for listening/reading along. Check out the video try it out and if you have any questions feel free to hit us up at (as usual I'm @tylerhannan )"  
[X Link](https://x.com/ClickHouseDB/status/1983945058111082882) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-30T17:12Z 13.1K followers, XXX 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/1981360008253067649) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-23T14:00Z 13.1K followers, 5286 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) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-27T14:51Z 13.1K followers, 128.9K engagements


"The ClickHouse MCP server now supports chDB which is basically ClickHouse as an in-process SQL engine. No server required. @markhneedham shows what this looks like in practice using tennis match data going back almost XX years: 🔸 How to enable CHDB mode in your Claude Desktop config 🔸 Querying CSV files directly from URLs 🔸 Getting Claude to analyze tournament stats and player performance 🔸 Multi-year comparisons with automatically generated visualizations The interesting part Claude figures out how to adjust URLs and track player IDs across queries with minimal guidance"  
[X Link](https://x.com/ClickHouseDB/status/1983579660328804632) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-29T17:00Z 13.1K followers, 1055 engagements


"Pythonistas did you catch our Ibis tutorial This nifty library lets you interact with ClickHouse using familiar Python syntax. Whether you're analyzing flight delays or house prices Ibis has got your back. Dive into our blog post to see it in action"  
[X Link](https://x.com/ClickHouseDB/status/1984244145091752444) [@ClickHouseDB](/creator/x/ClickHouseDB) 2025-10-31T13:00Z 13.1K followers, XXX engagements