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.
Search Articles — Sudonull
Search Results
In this project
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.
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.
https://sudonull.com/mysql-solutions-in-postgresql-polar-architecture-for-high-performance
How Tantor Polar integrates MySQL technologies into PostgreSQL. Compute/storage separation architecture, RDMA and NVMe-oF. Technical details for developers.
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
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.
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.
Trending Now
Docker Container Networking Explained: A Practical Guide
Docker container networking explained in depth: learn bridge vs host networks, DNS, port publishing, and how to build secure, scalable multi-container apps.
How to Build an AI Agent with LangChain: Step-by-Step Guide
Learn how to build an AI agent with LangChain in this step-by-step tutorial. Set up tools, integrate LLMs, and create autonomous agents with memory.
What Is a Vector Database? Beginner's Guide to AI Search
What is a vector database? Learn how vector databases power AI search, RAG, and recommendations. Discover key concepts and when to use them. Start here.
MongoDB vs PostgreSQL When to Use Each: Key Differences
MongoDB vs PostgreSQL when to use each: compare ACID compliance, scalability, schema flexibility, and query power. Choose the right database for your project.
Top 10 Breakthrough Technologies 2026 from WEF: Full Analysis
Analysis of trends, hidden risks, and geopolitical implications of Top 10 Emerging Technologies 2026. Who benefits from new developments and who loses. Read the analytics.
What Is Object Oriented Programming? Core Concepts Explained
Learn what is object oriented programming, its four pillars, real-world examples, and why it matters for building scalable, maintainable software. Start mastering OOP today.
15 Prompt Engineering Best Practices for Better AI Results
Master prompt engineering best practices with 15 proven techniques. Learn to craft effective prompts, reduce errors, and get better AI results. Start optimizing now.
How to Choose a Database for Your System: Expert Guide
Learn how to choose a database for your system with this evidence-based framework. Compare SQL, NoSQL, graph, and time-series databases to make the right decision.
How to Implement JWT Authentication: Step-by-Step Guide
Learn how to implement JWT authentication securely in your web API. This complete guide covers token issuance, validation, best practices, and production security.
GPT-4 vs Claude Comparison: Which AI Model Is Best?
Read our data-driven GPT-4 vs Claude comparison covering accuracy, coding, hallucinations, and cost. Discover which AI model fits your needs in 2026.