🚀 Heading to AWS Unicorn Day Malaysia next week?. Visit us at the Startup Zone AMA booth to meet our database experts, ask questions, and see live ClickHouse demos in action. Learn how startups are scaling globally with the fastest open-source analytics database:

It’s been a while since we shared a @markhneedham video, but here’s a quick one on the Variant data type in ClickHouse. ▶️ If you’re dealing with data that doesn’t fit neatly into a fixed schema - maybe different types in the same column or evolving.

🔗

Have you seen our benchmark comparing JSON performance across popular database systems?. We tested ClickHouse's new JSON data type against MongoDB, Elasticsearch, DuckDB, and PostgreSQL, processing and querying 1 billion JSON documents. The results speak for themselves:.

We're excited to sponsor and speak at AWS Startup Dev Day Melbourne — happening next Friday! 🇦🇺. Join us and other technical founders, CTOs, and engineers for a day of deep dive sessions exploring the latest GenAI innovations. Don't miss our lightning talk and demo at 2:00 PM on

@tylerhannan @ApacheIceberg @databricks @iskakaushik And that's a wrap. Check our reading corner at below. Try 25.7. Join us at See you soon!

@tylerhannan @ApacheIceberg @databricks @iskakaushik But how does it work?. Check out -

@tylerhannan @ApacheIceberg @databricks As a bonus, we have @iskakaushik sharing with us about. "ClickHouse Client Agent" - writing queries in natural language via LLM

@tylerhannan Also in 25.7 we support inserts into existing @ApacheIceberg tables. AND . with 25.7 we support @databricks managed Iceberg tables!

@tylerhannan And now. something interesting. LIGHTWEIGHT UPDATES. We've released a post about this today you should read in detail.

@tylerhannan We promised JOIN optimization in every release. here they are!

@tylerhannan Now, we are moving toward a variety of performance improvements. (I won't enumerate each of them. you should watch).

@tylerhannan In 25.7 we add READ and WRITE grants for external data via configuration so you can enable grants separately!.

@tylerhannan And now. and I quote "Boring Security Features". But your database should be secure, and we are making it moreso.

@tylerhannan Sometimes words fail me when describing a ClickHouse feature. So I share the slide directly ;). "Compressed Numeric Vectors"

@tylerhannan colorful brackets in ClickHouse Client?. developer experience matters!

@tylerhannan um. functions for conversion in color spaces?. sRGB to OKLCH!. and yes, a live demo.

@tylerhannan a screenshot for context. ;)

@tylerhannan In 25.7 we expand our geo support by adding 'polygonsIntersectCartesian' and 'polygonsIntersectSpherical'. Also. "wkb" (It's a well known binary. do you know it?).

@tylerhannan Does "InternatlRateofReturn" matter to you?. You'll love this. Alos, tell us why this matters to you. We love to hear your stories!