Search Articles — Sudonull

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.

Dictionaries in ClickHouse: fast lookup without JOIN

https://sudonull.com/dictionaries-in-clickhouse-fast-lookup-without-join

How to use ClickHouse dictionaries to replace JOIN with microsecond in-memory lookup. Types: flat/hashed/range, data sources, dictGet, and examples for gambling.

Loot boxes for children: restrictions in Russia

https://sudonull.com/loot-boxes-for-children-restrictions-in-russia

Deputy Milonov proposed restricting loot boxes for minors. We analyze the essence of the initiative, international experience, and possible consequences for the gaming industry.

From other projects

Premier League Gambling Ban Causes £80M Sponsorship Void

https://lrivo.com/premier-league-gambling-ban-causes-80m-sponsorship-void

Premier League clubs face an estimated £80M loss as a gambling ad ban forces them to seek new shirt sponsors. Understand the financial impact and market shift.

Kalshi Wins Federal Court Ruling on Prediction Markets

https://ymaho.com/kalshi-wins-federal-court-ruling-on-prediction-markets

A federal appeals court ruled Kalshi's prediction markets are federally regulated—not gambling. Learn what this means for users nationwide.

Trending Now