services:
  postgres:
    # These aren't tagged yet, since there's no dependabot support for
    # docker-compose yet: https://github.com/dependabot/dependabot-core/issues/390
    image: "postgres:alpine"
    ports:
      - "5432:5432"
    environment:
      POSTGRES_DB: dummy
      POSTGRES_USER: root
      POSTGRES_PASSWORD: root
    volumes: &vol
      - ../data/chinook:/tmp/chinook:ro
  mysql:
    image: "mysql:oracle"
    ports:
      - "3306:3306"
    environment:
      MYSQL_DATABASE: dummy
      MYSQL_ROOT_PASSWORD: root
    command: --secure-file-priv=""
    volumes: *vol
  mssql:
    image: "mcr.microsoft.com/mssql/server"
    ports:
      - "1433:1433"
    # https://github.com/microsoft/mssql-docker/issues/668#issuecomment-1436802153
    platform: linux/amd64
    environment:
      ACCEPT_EULA: Y
      MSSQL_PID: Developer
      MSSQL_SA_PASSWORD: Wordpass123##
      LC_ALL: en_US.UTF-8
      MSSQL_COLLATION: Latin1_General_100_CS_AI_SC_UTF8
    volumes: *vol
  clickhouse:
    # TODO: unpinning this causes an error, would be good to unpin & fix.
    image: "clickhouse/clickhouse-server:23.12.4.15-alpine"
    ports:
      # 9004 is MySQL emulation port
      # https://clickhouse.com/docs/en/guides/sre/network-ports
      - "9004:9004"
    environment:
      CLICKHOUSE_DB: dummy
      # Skip `chown` to user_files_path
      # https://github.com/ClickHouse/ClickHouse/blob/01c7d2fe719f9b9ed59fce58d5e9dec44167e42f/docker/server/entrypoint.sh#L7-L9
      CLICKHOUSE_DO_NOT_CHOWN: "1"
    volumes:
      # ClickHouse can load csv only from user_files_path (default `/var/lib/clickhouse/user_files/`)
      # https://clickhouse.com/docs/en/operations/server-configuration-parameters/settings#server_configuration_parameters-user_scripts_path
      - ../data/chinook:/var/lib/clickhouse/user_files/chinook/:ro
  glaredb:
    build:
      context: dockerfiles
      dockerfile: glaredb.Dockerfile
    ports:
      - "6543:6543"
    volumes: *vol