People still say #ClickHouse is append-only. That is an eight-year-old myth. Standard #SQL UPDATE shipped in 2025. Lightweight updates use patch parts, skip table rewrites, and run 1000x faster. I analyzed 100+ merged PRs to prove it. dataanalyticsguide.substack.com/p/clickhouse... #database

2,500x faster than #MongoDB. 10x faster than #Elasticsearch. 9,000x faster than #DuckDB. On 1 billion JSON documents. Single node. #ClickHouse's native JSON type is real, and it's been GA since v25.3.

#ClickHouse JOINs in 2026: 6 algorithms. Cost-based reordering. Parallel hash by default. Runtime bloom filters. Correlated subqueries decorrelated. I audited 50+ PRs from 2022 to 2026. The "avoid JOINs in ClickHouse" advice is 3 years out of date. dataanalyticsguide.substack.com/p/clickhouse...

Are ClickHouse JOINs Slow? A 2026 PR-by-PR Analysis

TL;DR The narrative that “ClickHouse can’t do JOINs” is outdated by four years and 50+ merged PRs.

dataanalyticsguide.substack.com

#OpenClaw's promise is great but the security model isn't there. I was already using #ClaudeCode and #WhatsApp constantly, so I built on that instead. Now I can text my assistant "prep me for my 2pm" or "latest for a customer project", seconds later I get a response right in my WhatsApp chat.

#Claude #Sonnet-4.6: 8% #PromptInjection success with all safeguards on. 0% in coding environments. Same model. The difference is the environment, not the model. Wrote detailed thoughts here manveerc.substack.com/p/prompt-inj...

The Prompt Injection Problem: A Guide to Defense-in-Depth for AI Agents

Claude Sonnet 4.6 shows 8% prompt injection success with all safeguards on. Here's the five-layer defense architecture for teams shipping agents into production.

manveerc.substack.com