Search Articles and Web Sources

Search Results

In this project

ORDER BY and PRIMARY KEY in ClickHouse: index selection

https://sudonull.com/order-by-and-primary-key-in-clickhouse-index-selection

How to correctly choose ORDER BY in ClickHouse: sparse index, column cardinality, equality vs range, verification via EXPLAIN. Rules and examples for gambling.

MBR 324 bytes STM32F407VE: compact bootloader

https://sudonull.com/mbr-324-bytes-stm32f407ve-compact-bootloader

Minimal primary bootloader for STM32F407VE (324 bytes). Vector validation, jump to 0x08060000, LED blinking on error. Code + Makefile for ARM-GCC.

AI Will Not Replace Copywriters: Reality Barrier

https://sudonull.com/ai-will-not-replace-copywriters-reality-barrier

Learn why AI doesn't write like a human due to lack of access to primary data. Analysis of LLM limitations for copywriters and journalists. Read the key differences.

MergeTree in ClickHouse: granules, parts, and sparse index

https://sudonull.com/mergetree-in-clickhouse-granules-parts-and-sparse-index

MergeTree structure using a bids table example: part, granule, mark, merge of parts, ORDER BY vs PRIMARY KEY, partitioning, EXPLAIN indexes, partition management.

From other projects

Renewable energy surpassed coal: what's next? | Analysis

https://ymaho.com/renewable-energy-surpassed-coal-what-s-next-analysis

In 2023, renewable energy became the primary source of electricity for the first time. Find out how this will change your bills and the global economy.

Stade de France: French Football's Long-Term Home

https://lrivo.com/stade-de-france-french-football-s-long-term-home

Discover how the French Football Federation secured Stade de France as its primary venue for major matches and the Coupe de France final until 2055. Learn about the phased agreement and future plans.

How Economic Sanctions Work in International Relations | Guide

https://ymaho.com/how-economic-sanctions-work-in-international-relations-guide

Learn how economic sanctions work in international relations, including primary vs secondary sanctions, compliance, effectiveness, and business risk assessment. Expert strategic guide.

Dollar exchange rate rises slightly ahead of Powell's final meeting

https://ymaho.com/dollar-exchange-rate-rises-slightly-ahead-of-powell-s-final-meeting

DXY index rose to 99.00, euro fell to $1.17. Markets await Fed verdict on 04/29/2026. Find out why Powell's departure on May 15 and the war in Iran make the dollar the world's primary safe-haven asset.