1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
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:
- ../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
# TODO: reenable
# glaredb:
# build:
# context: dockerfiles
# dockerfile: glaredb.Dockerfile
# ports:
# - "6543:6543"
# volumes: *vol