Part 1: Introduction & Architecture
What is ClickHouse, why is it so fast, and how does it work under the hood?
Welcome to my data engineering journey!
Join me on a journey from ClickHouse newcomer to confident practitioner. Just practical learning with a dash of humor.
What is ClickHouse, why is it so fast, and how does it work under the hood?
Get ClickHouse up and running in minutes using Docker or native binaries.
Understanding the core engine of ClickHouse: MergeTree, Sorting, and Partitioning.
Best practices for schema design, primary keys, and denormalization in ClickHouse.
Getting data into ClickHouse: INSERTs, Formats, and Integrations.
Mastering SQL in ClickHouse: Aggregations, PREWHERE, and performance tips.
Unlock the power of Arrays, Maps, and Window Functions in ClickHouse.
Real-time analytics made easy with ClickHouse Materialized Views.
Squeeze every ounce of performance out of ClickHouse with these tuning tips.
Going global: Sharding, Replication, and managing ClickHouse at scale.
Learn how to build resilient, distributed applications with CockroachDB. From architecture to production operations.
What is CockroachDB, why is it named after an insect, and how does it survive anything?
Spinning up a local CockroachDB cluster with Docker in under 5 minutes.
It speaks SQL, but it's not Postgres. Understanding the wire protocol and key differences.
How to design tables for a distributed system. Why UUIDs are your best friend and SERIAL is your enemy.
Killing nodes for fun and profit. How CockroachDB survives failures without waking you up at 3 AM.
ACID isn't just a buzzword. How CockroachDB guarantees serializable isolation.
Making it fly. Indexes, EXPLAIN, and why you shouldn't scan the whole cluster.
The killer feature. Pinning data to specific regions to reduce latency and comply with GDPR.
Writing code that survives. Why you need retry logic for serializable transactions.
Day 2 operations. Backups, upgrades, and keeping the lights on.
Get notified when I publish new tutorials and insights.