Search Articles — Sudonull

Search Results

In this project

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.

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.

Link Theory in Data Models

https://sudonull.com/link-theory-in-data-models

Study link theory: from relational n-tuples to unified duplets R → R². Comparison with graphs and SQL for middle/senior developers. Dive into the formalism.

ClickHouse in Docker: launch analytics in 2 minutes

https://sudonull.com/clickhouse-in-docker-launch-analytics-in-2-minutes

Step-by-step guide to running ClickHouse in Docker: docker run, docker-compose for dev and production, replication with ZooKeeper, ClickHouse + Kafka + Redis stack. Ready configs.

From other projects

AlphaFold DB: How AI Predicted 200 Million Proteins

https://ymaho.com/alphafold-db-how-ai-predicted-200-million-proteins

DeepMind's AlphaFold database contains over 200 million protein structures. Learn how this accelerates drug discovery and transforms science. Read more in the article.

Women's Health Centers Moscow: A New Standard

https://ymaho.com/women-s-health-centers-moscow-a-new-standard

How the Reform of Women's Health Centers in Moscow Is Changing the Market: Free IVF, Cryopreservation, and a Unified Database. Find Out What Awaits Private Medicine.

From the web

Database - Wikipedia

https://en.wikipedia.org/wiki/Database

In computing, a database is an organized collection of data or a type of data store based on the use of a database management …

Introduction to Database - GeeksforGeeks

https://www.geeksforgeeks.org/dbms/what-is-database/

Apr 28, 2026 · Databases work by organizing and storing information in a structured or unstructured format, allowing easy access, …

Database | Supabase

https://supabase.com/database

Every Supabase project is a dedicated Postgres database. 100% portable with no vendor lock-in.

SQL DATABASE - W3Schools

https://www.w3schools.com/SQL/sql_ref_database.asp

Well organized and easy to understand Web building tutorials with lots of examples of how to use HTML, CSS, JavaScript, SQL, …

What Is a Database? - Oracle

https://www.oracle.com/database/what-is-database/

Nov 24, 2020 · A database is an organized collection of structured information, or data, typically stored electronically in a computer …

PostgreSQL: The world's most advanced open source database

https://www.postgresql.org/

1 day ago · PostgreSQL is a powerful, open source object-relational database system with over 35 years of active development that …

Base de données — Wikipédia

https://fr.wikipedia.org/wiki/Base_de_donn%C3%A9es

Une base de données permet de stocker et de retrouver des données structurées, semi-structurées ou des données brutes ou de l' …

DBMS Tutorial - GeeksforGeeks

https://www.geeksforgeeks.org/dbms/dbms/

Mar 14, 2026 · Understand the basics of DBMS, explore how it works, and learn about different database architectures used in real …

AI Database - Oracle

https://www.oracle.com/database/

AI is natively architected into Oracle AI Database and SQL, making it simpler, faster, more secure, and more trustworthy, while also …

What Is a Database? Definition, Types, and Examples

https://whatisdatabase.com/understanding-databases-importance-and-benefits-explained

Apr 5, 2025 · A database is an organized collection of information that can be stored, searched, updated, and managed efficiently. …

Trending Now