docker-compose.yml

services:
  clickhouse:
    # Pinned to the EXACT version running on ch-prod-01 (Hetzner) so local/CI
    # tests exercise the same engine as production — refreshable-MV semantics,
    # alias resolution and date/time functions can differ across CH releases.
    # Before changing this, re-check the live `SELECT version()` on ch-prod-01.
    image: clickhouse/clickhouse-server:26.3.10.60
    ports:
      - '8123:8123'
      - '9000:9000'
    volumes:
      - clickhouse-data:/var/lib/clickhouse
      - ./packages/prices-clickhouse/schema/init.sql:/docker-entrypoint-initdb.d/init.sql:ro
    environment:
      CLICKHOUSE_DB: prices
      CLICKHOUSE_USER: default
      CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT: 1
    healthcheck:
      test: ['CMD', 'clickhouse-client', '--query', 'SELECT 1']
      interval: 5s
      timeout: 3s
      retries: 10

volumes:
  clickhouse-data: