Part 1 of 10
Part 1: Introduction & Architecture
What is ClickHouse, why is it so fast, and how does it work under the hood?
ClickHouse Architecture OLAP
Blog
Welcome to my data engineering journey!
🚀 ClickHouse Mastery
Join me on a journey from ClickHouse newcomer to confident practitioner. Just practical learning with a dash of humor.
Part 2 of 10
Part 2: Installation & Quick Start
Get ClickHouse up and running in minutes using Docker or native binaries.
ClickHouse Installation Docker SQL
Part 3 of 10
Part 3: The MergeTree Family
Understanding the core engine of ClickHouse: MergeTree, Sorting, and Partitioning.
ClickHouse MergeTree Engines
Part 4 of 10
Part 4: Data Modeling
Best practices for schema design, primary keys, and denormalization in ClickHouse.
ClickHouse Data Modeling Schema Design
Part 5 of 10
Part 5: Ingestion
Getting data into ClickHouse: INSERTs, Formats, and Integrations.
ClickHouse Ingestion Formats Integrations
Part 6 of 10
Part 6: Querying Basics
Mastering SQL in ClickHouse: Aggregations, PREWHERE, and performance tips.
ClickHouse SQL Querying
Part 7 of 10
Part 7: Advanced Features
Unlock the power of Arrays, Maps, and Window Functions in ClickHouse.
ClickHouse Arrays Maps Window Functions
Part 8 of 10
Part 8: Materialized Views
Real-time analytics made easy with ClickHouse Materialized Views.
ClickHouse Materialized Views Real-time AggregatingMergeTree
Part 9 of 10
Part 9: Performance Tuning
Squeeze every ounce of performance out of ClickHouse with these tuning tips.
ClickHouse Performance Optimization Indexes
Part 10 of 10
Part 10: Scaling & Operations
Going global: Sharding, Replication, and managing ClickHouse at scale.
ClickHouse Scaling Sharding Replication Operations
🚀 CockroachDB: From Zero to Hero
Learn how to build resilient, distributed applications with CockroachDB. From architecture to production operations.
Part 1 of 10
Part 1: Introduction & Architecture
What is CockroachDB, why is it named after an insect, and how does it survive anything?
CockroachDB Architecture Distributed Systems
Part 2 of 10
Part 2: Installation & Cluster Setup
Spinning up a local CockroachDB cluster with Docker in under 5 minutes.
CockroachDB Installation Docker
Part 3 of 10
Part 3: SQL & PostgreSQL Compatibility
It speaks SQL, but it's not Postgres. Understanding the wire protocol and key differences.
CockroachDB SQL PostgreSQL
Part 4 of 10
Part 4: Data Modeling & Schema Design
How to design tables for a distributed system. Why UUIDs are your best friend and SERIAL is your enemy.
CockroachDB Data Modeling Schema
Part 5 of 10
Part 5: Fault Tolerance & High Availability
Killing nodes for fun and profit. How CockroachDB survives failures without waking you up at 3 AM.
CockroachDB High Availability Resilience
Part 6 of 10
Part 6: Transactions & Consistency
ACID isn't just a buzzword. How CockroachDB guarantees serializable isolation.
CockroachDB Transactions ACID
Part 7 of 10
Part 7: Performance Tuning
Making it fly. Indexes, EXPLAIN, and why you shouldn't scan the whole cluster.
CockroachDB Performance Tuning
Part 8 of 10
Part 8: Geo-Partitioning
The killer feature. Pinning data to specific regions to reduce latency and comply with GDPR.
CockroachDB Geo-Partitioning Multi-Region
Part 9 of 10
Part 9: Application Development
Writing code that survives. Why you need retry logic for serializable transactions.
CockroachDB Development Golang Python
Part 10 of 10
Part 10: Operations & Monitoring
Day 2 operations. Backups, upgrades, and keeping the lights on.
CockroachDB Operations DevOps
Stay in the Loop
Get notified when I publish new tutorials and insights.