clickhouse-local-dev-loop

# ClickHouse Local Dev Loop ## Overview Run ClickHouse in Docker for local development with fast schema iteration, seed data, and integration testing using vitest. ## Prerequisites - Docker or Docker Compose installed - Node.js 18+ with `@clickhouse/client` ## Instructions ### Step 1: Docker Compose Setup ```yaml # docker-compose.yml services: clickhouse: image: clickhouse/clickhouse-server:latest ports: - "8123:8123" # HTTP interface - "9000:9000" # Native TCP (clickhouse-client CLI) volumes: - clickhouse-data:/var/lib/clickhouse - ./init-db:/docker-entrypoint-initdb.d # Auto-run SQL on first start environment: CLICKHOUSE_USER: default CLICKHOUSE_PASSWORD: dev_password CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT: 1 # Enable SQL-based user management ulimits: nofile: soft: 262144 hard: 262144 volumes: clickhouse-data: ``` ```bash docker compose up -d # Verify: curl http://localhost:8123/ping → "Ok.\n" ``` ### Step 2: Init Script (Auto-Run on First Start) ```sql -- init-db/001-schema.sql CREATE DATABASE IF NOT EXISTS app; CREATE TABLE IF NOT EXISTS app.events ( event_id UUID DEFAULT generateUUIDv4(), event_type LowCardinality(String), user_id UInt64, properties String, -- JSON string created_at DateTime DEFAULT now() ) ENGINE = MergeTree() ORDER BY (event_type, created_at) PARTITION BY toYYYYMM(created_at); ``` ### Step 3: Seed Data Script ``...