docker-compose.yml

# Local services for differential testing. The CI workflow uses GitHub
# Actions service containers with the same images and ports — keep the
# versions and config in sync.
#
# DuckDB is in-process via duckdbex; no service needed.
# SQLite is in-memory via ecto_sqlite3; no service needed.
#
# Bring up:
#   docker compose up -d clickhouse
#
# Then run the differential tests:
#   mix test --include clickhouse
#
# Tear down:
#   docker compose down -v

services:
  postgres:
    image: postgres:16
    container_name: spire-postgres
    # Map to 5433 on the host so we don't clash with a developer's
    # locally-installed Postgres on the default 5432.
    ports:
      - "5433:5432"
    environment:
      POSTGRES_DB: spire_test
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgres
      POSTGRES_HOST_AUTH_METHOD: trust
    healthcheck:
      test: ["CMD-SHELL", "pg_isready -U postgres"]
      interval: 2s
      timeout: 2s
      retries: 30

  clickhouse:
    image: clickhouse/clickhouse-server:24.10
    container_name: spire-clickhouse
    ports:
      - "8123:8123" # HTTP — what `ch` / `ecto_ch` connect to
      - "9000:9000" # Native protocol (unused by us, exposed for psql-like tooling)
    environment:
      CLICKHOUSE_DB: spire_test
      CLICKHOUSE_USER: default
      CLICKHOUSE_PASSWORD: ""
      # Lets us CREATE/DROP tables freely in tests.
      CLICKHOUSE_DEFAULT_ACCESS_MANAGEMENT: 1
    ulimits:
      nofile:
        soft: 262144
        hard: 262144
    healthcheck:
      test: ["CMD", "wget", "--no-verbose", "--tries=1", "--spider", "http://localhost:8123/ping"]
      interval: 2s
      timeout: 2s
      retries: 30