Altinity (@AltinityDB) header
Altinity (@AltinityDB) profile picture

Run affordable open source ClickHouse® anywhere with #AltinityCloud, Expert Support, BYOC, & real-time data lake integration to scale queries on cheap storage.

Berkeley, CA
Joined October 2015
Photo by Altinity (@AltinityDB)Photo by Altinity (@AltinityDB)Photo by Altinity (@AltinityDB)Photo by Altinity (@AltinityDB)Photo by Altinity (@AltinityDB)Photo by Altinity (@AltinityDB)Photo by Altinity (@AltinityDB)Photo by Altinity (@AltinityDB)Photo by Altinity (@AltinityDB)Photo by Altinity (@AltinityDB)
~10x cold read speedup vs AWS gp3. Database and workload on the same rack. $0 internal egress. ~70M rows/sec sustained from disk. That's #ClickHouse® on @nirvanalabsai, the new BYOC option for #AltinityCloud. Benchmarks & repos are public. 💪🏽 Learn more: hubs.la/Q04qTYZN0
4
12
766
Sorting keys, batching, less repeated work: 80 seconds on making ClickHouse® work smarter. Try @AltinityDB free, then choose Nirvana as your BYOC option for always hot data: altinity.com/ #ClickHouse #Database
1
6
217
Your enterprise customer says, “Run the database in our cloud.” Now what? 🫣 Next Thursday, Altinity CEO @dbcicero will break down #BYOC for databases with #ClickHouse®: when it fits & how to keep control of cost, data residency, & security. 📅 Nov. 5 🔗 hubs.la/Q04CBcwT0
2
86
⚠️ More #ClickHouse® data shouldn’t mean adding more compute. Tomorrow, Altinity CEO @dbcicero & CTO Alexander Zaitsev demo how #AntalyaBuilds make that possible, plus what’s new: OAuth & MCP, Databricks compatibility & CAS for shared #MergeTree storage. hubs.la/Q04Cj-2c0
1
99
An #AI agent dropped a production #ClickHouse® table. 🫠 It even changed a safety setting to do it. Nowadays, "don't touch production" isn't a security policy. We explore how scoped RBAC, read-only MCP access & agent sandboxing are the right guardrails: hubs.la/Q04Bwtlf0
2
1
3
175
⚡ Copy a statement. Run it. Copy the next one. Keep going. Or paste the whole script into the #AltinitySQLBrowser. It runs each #ClickHouse® statement in order, with its own result & timing, and stops on the first error. 🚀 Try the demo: hubs.la/Q04yqk4G0
3
107
🎉 We're proud to be the Platinum Sponsor of #OSACON 2026. 🎉 Join us & other data & #AI practitioners & builders on Nov. 2 (SF/online) as we deconstruct AI workloads, agents operating analytics platforms, #datalakes, open-source architectures, & more. hubs.la/Q04zWM1q0
1
1
92
🤔 What’s working? What broke? And what does the data stack look like when AI is part of it? Get the answers and leave with a playbook.
34
Data is growing, but query load isn't? CAS (experimental in #AltinityAntalya 26.6) lets #ClickHouse® #MergeTree tables use shared object storage. 📦 Storage scales independently of compute 🔗 Nodes share identical files Cold-tier use for now. See how 👇 hubs.la/Q04zTkz80
1
67
🔥 Hot data in #ClickHouse® MergeTree. Colder data in #Iceberg. One query across both. On Oct. 27, Robert Hodges & Alexander Zaitsev will show how #AntalyaBuilds combines Hybrid tables, swarms, OAuth, CAS for shared MergeTree storage, & MCP. 🕗 8am PT 🍿 hubs.la/Q04zrh7b0
3
113
↹ Changed a #ClickHouse® table & now need to figure out what else depended on it? #AltinitySQLBrowser maps the connections for you. Drag a database/table from the schema tree into the results pane & it builds a data-flow graph showing #materializedviews. hubs.la/Q04yqddk0
88
Detached ≠ disposable. 😬 Before deleting #ClickHouse® detached parts, check the reason. Some are cleanup candidates, some are temporary, and some need investigation first. ⚠️ Full guide: kb.altinity.com/altinity-kb-…
1
126
Will #AI create an extinction event for open-source DB projects? 💀 Altinity CEO @dbcicero will explore what AI is changing at the database layer, incl. security, MCP connectivity, & what comes next for open source at #OSACON 2026. 📅 Nov 2 | 10 am PT 🗣️ hubs.ly/Q04yKnSG0
1
71
🌮 Tomorrow evening: tacos + #observability, MCPs, #AI, OTel, & ClickHouse® at Grafana & Friends. We’ll join talks & conversations around some current engineering problems: safer AI data access, MCP + k6, OTel on #K8s, & stateless #ClickHouse® ingestion. hubs.la/Q04yqYrW0
3
107
📣 Raw EXPLAIN text can be a lot to parse. The #AltinitySQLBrowser turns #ClickHouse® EXPLAIN PIPELINE output into an interactive processor graph, so parallelism and Resize points are easier to spot. Pan, zoom, or open it fullscreen. 💡 Full docs: hubs.la/Q04ypVrf0
1
120
Slow #ClickHouse® query? Start with the built-in tools. 💪🏽 ▪ query_log: resources + runtime ▪ processors_profile_log: time per stage ▪ query_metric_log: live stats ▪ EXPLAIN + the chdig CLI 💡 Get the full breakdown: hubs.la/Q04xYzy60
1
111
Scaling #ClickHouse® storage without scaling compute? Meet CAS. 💥 Content-Addressed Storage (#CAS) adds shared object storage to existing MergeTree model, so storage can scale independently without replacing #MergeTree with a new engine. CAS explained: hubs.la/Q04y7dTR0
2
140
We're excited to have Joshua Lee, Developer Advocate for @AltinityDB, presenting "Observability is Broken and Open-Source (will be) the Solution" at #AllThingsOpen! 2026.allthingsopen.org/sessi…
1
1
291
0.65s vs. 1.42s on ~126M rows. Same #ClickHouse® table, same filter. The only change was the query’s ORDER BY. ⚡ If a query is sorting more than expected, check whether its ORDER BY matches the table’s: kb.altinity.com/engines/merg…
1
2
136
🎡 Hey Londoners, we'll be at the Data Engineering London #meetup tomorrow for an evening on Storage + #AI. Expect deep dives on Hot SSDs to #lakehouses, data movement, metadata performance, and more. 📍 London Art Bar | 6 pm 🍻 Food + drinks on us 🔗 hubs.la/Q04xY3Lt0
1
194
Your analytical database is columnar & your dataframe library is too. But the path between them often isn't. That can mean extra copies & transposes to move query results. 😓 See how #ApacheArrow & #ADBC can eliminate that in this Unevenly Distributed ep: hubs.la/Q04xRPlG0
82