Search Articles — Sudonull

Search Results

In this project

Architecture for 9 trillion records on a server

https://sudonull.com/architecture-for-9-trillion-records-on-a-server

Learn how to store trillions of Milky Way stars in sparse files with Z-encoding. Scalable system without indexes for middle/senior dev. Implement it yourself.

ruGPT3XL with 8k context: sparse attention

https://sudonull.com/rugpt3xl-with-8k-context-sparse-attention

Expansion of ruGPT3XL to 8k tokens via sparse attention and fine-tuning. PPL 13.00 on gazeta, Triton/SDPA optimization ×1.85. Instructions for developers.

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.

Speeding up regex search with trigrams in Cursor

https://sudonull.com/speeding-up-regex-search-with-trigrams-in-cursor

Local indexing of trigrams and sparse n-grams speeds up code search for AI agents. Reducing time from 15s to milliseconds in large repositories. More details for developers.

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.

From the web

20 hours ago ·

https://www.geocountries.com/states/finland

20 hours ago · Complete state-by-state directory of all administrative divisions of Finland with capital city, population , land area in km², population density per km², Top 10 most populous states, Top 10 largest states by area and Top 10 most densely populated states — updated 2026. Each state card links to its own detailed profile. Aggregate statistics include total number of states, combined national ...

Show more

https://www.whatthefinland.fi/fi/peersupport/

Are you new in Finland and looking for friendly, lived-experience support to help you navigate everyday life? At What the Finland , we connect you with peers who have firsthand experience settling in Finland . Our voluntary peer supporters offer guidance and share practical advice on housing, healthcare, employment, entrepreneurship, volunteering, and building community connections — all in ...

Jul 8, 2026 ·

https://georank.org/population-density/finland

Jul 8, 2026 · Finland has a population density of 48.1 people per square mile, compared to the average of 144.1 people in other countries. Finland has 645,248 sq ft of land per person and ranks 175th out of 197 countries (most to least densely populated). Finland has 0.07% of the world's population and 0.2% of the total land area of all countries.

1 day ago ·

https://www.britannica.com/place/Finland/People

1 day ago · Finland - Arctic, Nordic, Saami: Excavations undertaken in 1996 have led to a radical reconsideration of how long people have inhabited Finland . Finds in a cave near Kristinestad in the southwestern part of the country have led some to suggest that habitation of Finland goes back at least 100,000 years. Ancestors of the Sami apparently were present in Finland by about 7000 bce. As other groups ...

Oct 23, 2026 ·

https://nordicexpat.com/finland/sauna-culture-finland

Oct 23, 2026 · How Finnish sauna culture works for newcomers: etiquette, nudity norms, löyly, shared apartment-building saunas and public saunas, explained plainly.

20 hours ago ·

https://www.geocountries.com/finland

20 hours ago · Get complete Finland country profile covering total population , population rank in the world and in Europe, land and water area (km² & mi²), capital city Helsinki, official language, national currency (EUR), live local date and time, sunrise and sunset times, GPS coordinates, dialing code, internet domain, ISO country codes, political status and nearest neighboring country. Up-to-date ...

Demographics of Finland

https://www.kiinteistotiedot.com/

We offer a collection of tools and visualisations designed to help you make smarter decisions when buying, selling, or valuing real estate in Finland . Our portfolio offers insights into market trends, property valuations, and price dynamics, all powered by real data merged with AI to provide accurate and up-to-date analysis.

Trending Now