webservice/docker-compose.yml at dev · trakli/webservice · GitHub

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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
name: trakli

services:
    app:
        image: ghcr.io/whilesmartphp/laravel-dev:8.4
        ports:
            - '${APP_PORT:-8000}:80'
        tty: true
        volumes:
            - '.:/var/www/html'
        networks:
            - trakli
        depends_on:
            - mysql

    worker:
        image: ghcr.io/whilesmartphp/laravel-dev:8.4
        # queue:listen (not queue:work) reboots the framework per job so code
        # edits are picked up without restarting the worker.
        command: php artisan queue:listen --tries=3 --timeout=120
        tty: true
        volumes:
            - '.:/var/www/html'
        networks:
            - trakli
        depends_on:
            - mysql

    reverb:
        image: ghcr.io/whilesmartphp/laravel-dev:8.4
        # The websocket server for real-time chat streaming. The browser
        # connects on the published port; the app publishes to it over the
        # trakli network as host "reverb".
        command: php artisan reverb:start --host=0.0.0.0 --port=8080
        ports:
            - '${REVERB_HOST_PORT:-6001}:8080'
        tty: true
        volumes:
            - '.:/var/www/html'
        networks:
            - trakli
        depends_on:
            - mysql

    mysql:
        image: 'mysql:8.0'
        ports:
            - '${FORWARD_DB_PORT:-3306}:3306'
        environment:
            MYSQL_ROOT_PASSWORD: '${DB_PASSWORD}'
            MYSQL_DATABASE: '${DB_DATABASE}'
            MYSQL_USER: '${DB_USERNAME}'
            MYSQL_PASSWORD: '${DB_PASSWORD}'
            MYSQL_ALLOW_EMPTY_PASSWORD: 'yes'
        volumes:
            - 'trakli_mysql:/var/lib/mysql'
        networks:
            - trakli
        healthcheck:
            test: ["CMD", "mysqladmin", "ping", "-p${DB_PASSWORD}"]
            retries: 3
            timeout: 5s

    mysql-test:
        image: 'mysql:8.0'
        environment:
            MYSQL_ROOT_PASSWORD: '${DB_PASSWORD}'
            MYSQL_DATABASE: 'trakli_test'
            MYSQL_USER: '${DB_USERNAME}'
            MYSQL_PASSWORD: '${DB_PASSWORD}'
            MYSQL_ALLOW_EMPTY_PASSWORD: 'yes'
        volumes:
            - 'trakli_test_mysql:/var/lib/mysql'
        networks:
            - trakli
        healthcheck:
            test: ["CMD", "mysqladmin", "ping", "-p${DB_PASSWORD}"]
            retries: 3
            timeout: 5s

    phpmyadmin:
        image: 'phpmyadmin/phpmyadmin:latest'
        ports:
            - '${PMA_PORT:-8080}:80'
        environment:
            PMA_HOST: mysql
            PMA_USER: '${DB_USERNAME}'
            PMA_PASSWORD: '${DB_PASSWORD}'
        depends_on:
            - mysql
        networks:
            - trakli

    mailhog:
        image: 'mailhog/mailhog:latest'
        ports:
            - '${MAILHOG_SMTP_PORT:-1025}:1025'
            - '${MAILHOG_UI_PORT:-8025}:8025'
        networks:
            - trakli

    smartql:
        image: 'ghcr.io/smartql/smartql:latest'
        ports:
            - '${SMARTQL_PORT:-5000}:8000'
        environment:
            SMARTQL_CONFIG: /app/smartql.yml
            DB_HOST: mysql
            DB_PORT: 3306
            DB_DATABASE: '${DB_DATABASE}'
            DB_USERNAME: '${DB_USERNAME}'
            DB_PASSWORD: '${DB_PASSWORD}'
            LLM_PROVIDER: '${LLM_PROVIDER:-gemini}'
            LLM_MODEL: '${LLM_MODEL:-gemini-2.0-flash}'
            GEMINI_API_KEY: '${GEMINI_API_KEY:?GEMINI_API_KEY must be set for SmartQL}'
            LLM_TEMPERATURE: '${LLM_TEMPERATURE:-0.1}'
            LLM_RETRIES: '${LLM_RETRIES:-3}'
        volumes:
            - './smartql.yml:/app/smartql.yml:ro'
        depends_on:
            - mysql
        networks:
            - trakli
        command: ["smartql", "serve", "-c", "/app/smartql.yml", "--host", "0.0.0.0", "--port", "8000"]

networks:
    trakli:
        driver: bridge
volumes:
    trakli_mysql:
        driver: local
    trakli_test_mysql:
        driver: local