https://sudonull.com/summingmergetree-and-aggregatingmergetree-in-clickhouse
Incremental aggregation in ClickHouse: how SummingMergeTree and AggregatingMergeTree speed up dashboards by 100 times. Examples, materialized views, pitfalls, and comparison.
https://sudonull.com/clickhouse-materialized-views-triggers-on-insert
How MV work in ClickHouse: incremental aggregation, chains minute→hour→day, Null+Kafka pattern, POPULATE and its dangers. Examples with SummingMergeTree and AggregatingMergeTree.
https://sudonull.com/parser-acceleration-by-3-times-transition-from-rust-wasm-to-typescript
Performance analysis: why abandoning WASM and porting the parser to TypeScript with an incremental algorithm resulted in 3x faster stream processing. Practical benchmarks and conclusions.
https://sudonull.com/aria-snapshots-playwright-for-ai-agents
Learn how Playwright generates semantic YAML ARIA snapshots for web agents. Token optimization, incremental deltas, DOM processing. For middle/senior dev.
MongoDB vs PostgreSQL when to use each: compare ACID compliance, scalability, schema flexibility, and query power. Choose the right database for your project.
Learn how to use Terraform with AWS step by step. Master provider setup, state management, security, and production-grade deployments. Start building today.
Master how to negotiate a software developer salary offer with data-driven tactics, psychological strategies, and legal tips. Maximize your total compensation today.
Learn what is the difference between vpn and proxy, from encryption to scope. Discover which tool fits your privacy needs with our expert comparison.
Learn what are data structures and why they are important for efficient software. Discover types, real-world impact, and how they shape modern computing.
Learn how to reduce hallucination in LLMs with 7 proven techniques from peer-reviewed research. Boost accuracy and reliability in your AI applications today.
What is React used for? Learn how this JavaScript library builds fast, scalable UIs with components and Virtual DOM. Discover its real-world uses and benefits.
Kubernetes architecture explained with examples: understand control plane, worker nodes, Pods, and deployment flow. Learn how clusters work with practical use cases.
Compare REST API vs GraphQL side-by-side. Learn which architecture fits your project with data on performance, caching, cost, and scalability. Make the right choice.
Learn how to set up CI/CD pipeline with GitHub Actions. Step-by-step guide with YAML examples for automated testing, Docker builds, and deployment.