https://sudonull.com/special-clickhouse-engines-when-mergetree-is-not-needed
Overview of ClickHouse Memory, Buffer, Null, Log, URL, S3, and PostgreSQL Engines. Examples for coefficient cache, buffering inserts from Kafka, and live data from external databases.
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.
SpaceX and KDDI launched satellite communication for smartphones in Japan. Learn how Starlink Direct-to-Cell works, who can access it, and what hidden geopolitical goals this project pursues.
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 is microservices architecture, its benefits, challenges, and key patterns like Saga and API Gateway. Understand when to use this modern approach.
Learn what is a large language model, how AI like ChatGPT works, key capabilities, limitations, and practical uses. Understand LLMs in plain English.
CERN successfully transmitted entangled photons over 50 km in a real urban network. Learn how White Rabbit technology is changing the quantum communications market and who benefits from this breakthrough.
Learn how Netflix scales its streaming infrastructure with AWS, Open Connect CDN, and chaos engineering. Discover the tech behind 270M subscribers and sub-100ms latency.
Explore the history of the semiconductor industry and how does it work. Learn chip design, fabrication, and the global impact of this vital technology. Discover more.
Google introduced Gemini Ultra 2.0 with a context of up to 10 million tokens, surpassing GPT-5. Learn about the breakthrough architecture, price of $0.0005, and impact on the AI market. Read the full analysis.
Learn what are the ethical concerns in artificial intelligence, from bias to job loss. Backed by research, this guide offers a practical framework for evaluation.
Nvidia reached $5.4 trillion capitalization, outpacing the 10 largest companies in Europe. Analysis of growth reasons, overheating risks, and forecasts for the AI chip market. Read the review.