Repository navigation
Expand file tree
/
Copy pathdocker-compose.yml
More file actions
193 lines (189 loc) · 8.55 KB
/
Copy pathdocker-compose.yml
File metadata and controls
193 lines (189 loc) · 8.55 KB
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
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
services:
sqld:
image: ${LIBSQL_SERVER_IMAGE:-ghcr.io/tursodatabase/libsql-server:latest}
command:
- /bin/sqld
- --enable-namespaces
- --admin-listen-addr=0.0.0.0:9090
- --auth-jwt-key-file=/var/lib/sqld/auth.pem
environment:
# The libsql-server entrypoint already materializes these as CLI flags.
# Do not pass --db-path or --http-listen-addr in command as well.
SQLD_NODE: primary
SQLD_DB_PATH: /var/lib/sqld/data
SQLD_HTTP_LISTEN_ADDR: 0.0.0.0:8080
expose:
- '8080'
- '9090'
volumes:
- ${SQLD_DATA_DIR_HOST:-./backend/data/sqld}:/var/lib/sqld
restart: unless-stopped
networks:
coolify:
aliases:
- sqld
depends_on:
sqld-auth-init:
condition: service_completed_successfully
healthcheck:
test:
- CMD-SHELL
- timeout 3 bash -c 'exec 3<>/dev/tcp/127.0.0.1/9090' && timeout 3 bash -c 'exec 3<>/dev/tcp/127.0.0.1/8080' || exit 1
interval: 10s
timeout: 5s
retries: 10
start_period: 20s
labels:
- "traefik.enable=true"
- "traefik.docker.network=coolify"
# Base router is localhost-only. Public namespace routing is enabled by
# an explicit Coolify domain/override with literal values; do not rely on
# ${VAR:-default} interpolation inside Traefik labels under Coolify.
- "traefik.http.routers.sqld.rule=HostRegexp(`{subdomain:[a-z0-9-]+}.localhost`)"
# Keep the shared wildcard below dedicated runtime/namespace routers.
- "traefik.http.routers.sqld.priority=10"
- "traefik.http.services.sqld.loadbalancer.server.port=8080"
# Exact namespace routing is configured explicitly in Coolify or in an
# override file with literal values. Do not put `${VAR:-default}` in a
# Traefik label: Coolify may pass it through literally.
# Keep the auth bootstrap script inside the image. Bind-mounting it from the
# repo can fail under Coolify because compose runs from /artifacts inside the
# helper container while Docker resolves bind-mount paths on the host.
sqld-auth-init:
build:
context: ./backend
dockerfile: Dockerfile.auth-init
command:
- /bin/sh
- -c
- node /scripts/init-sqld-auth.mjs /data && (chown -R "$${SQLD_UID:-666}:$${SQLD_GID:-666}" /data 2>/dev/null || true)
env_file:
- path: ./backend/.env
required: false
volumes:
- ${SQLD_DATA_DIR_HOST:-./backend/data/sqld}:/data
restart: 'no'
networks:
- coolify
backend:
build:
context: ./backend
ports:
- '${BACKEND_PORT_BIND:-5000}:5000'
environment:
PORT: '5000'
DATABASE_FILE: /app/data/control.db
CORS_ORIGIN: ${CORS_ORIGIN:-http://localhost:5001}
SQLITE_STORAGE_ROOT: /app/data/sqlite
SQLITE_DISCOVERY_PATH: /app/data/sqlite
SQLITE_DISCOVERY_ADOPT: ${SQLITE_DISCOVERY_ADOPT:-false}
DATABASE_PUBLIC_HOST: ${DATABASE_PUBLIC_HOST:-host.docker.internal}
DATABASE_PUBLIC_PROTOCOL: ${DATABASE_PUBLIC_PROTOCOL:-http}
DATABASE_PUBLIC_DOMAIN: ${DATABASE_PUBLIC_DOMAIN:-localhost}
LIBSQL_ENABLE_NAMESPACES: 'true'
LIBSQL_ADMIN_URL: http://sqld:9090
LIBSQL_INTERNAL_URL: http://sqld:8080
SQLD_DATA_DIR: /app/data/sqld
LIBSQL_AUTH_DIR: /app/data/sqld
LIBSQL_SERVER_IMAGE: ${LIBSQL_SERVER_IMAGE:-ghcr.io/tursodatabase/libsql-server:latest}
LIBSQL_PROVISION_ASYNC: 'false'
# Imports default to local SQLite files. Set to auto/true only when the
# namespace public DNS/TLS setup is ready.
LIBSQL_NAMESPACE_IMPORTS: ${LIBSQL_NAMESPACE_IMPORTS:-false}
LIBSQL_IMPORT_RUNTIME: ${LIBSQL_IMPORT_RUNTIME:-false}
# libSQL-first policy: new bases/imports must be real libSQL primaries.
LIBSQL_REQUIRE_PRIMARY: ${LIBSQL_REQUIRE_PRIMARY:-true}
LIBSQL_ALLOW_LOCAL_FILE: ${LIBSQL_ALLOW_LOCAL_FILE:-false}
LIBSQL_PRIMARY_MODE: ${LIBSQL_PRIMARY_MODE:-auto}
LIBSQL_NAMESPACE_PUBLIC_ENABLED: ${LIBSQL_NAMESPACE_PUBLIC_ENABLED:-false}
LIBSQL_NAMESPACE_HOST: ${LIBSQL_NAMESPACE_HOST:-}
# "Make public libSQL" conversion: runtime | namespace | auto
LIBSQL_CONVERSION_MODE: ${LIBSQL_CONVERSION_MODE:-auto}
# Optional Traefik TLS labels for dynamically created dedicated runtimes.
# Leave empty if you use the shared sqld namespace router below.
TRAEFIK_CERT_RESOLVER: ${TRAEFIK_CERT_RESOLVER:-}
TRAEFIK_ENTRYPOINT: ${TRAEFIK_ENTRYPOINT:-}
# Docker network shared by the backend, Traefik and runtime containers.
# Empty = detect from the backend container (prefers "coolify"). The
# runtime never falls back to the default bridge network.
LIBSQL_RUNTIME_NETWORK: ${LIBSQL_RUNTIME_NETWORK:-}
LIBSQL_BACKEND_CONTAINER_ID: ${LIBSQL_BACKEND_CONTAINER_ID:-}
# Import uploads are staged on the data volume to avoid cross-device
# copies. The frontend shows progress; large files can use Server path.
IMPORT_STAGING_DIR: ${IMPORT_STAGING_DIR:-/app/data/tmp}
MAX_UPLOAD_SIZE_BYTES: ${MAX_UPLOAD_SIZE_BYTES:-524288000}
DB_CONNECTION_POOL_MAX_SIZE: ${DB_CONNECTION_POOL_MAX_SIZE:-256}
DB_CONNECTION_POOL_IDLE_TTL_MS: ${DB_CONNECTION_POOL_IDLE_TTL_MS:-1800000}
SQLITE_READ_POOL_SIZE: ${SQLITE_READ_POOL_SIZE:-4}
SQLITE_PERFORMANCE_PROFILE: ${SQLITE_PERFORMANCE_PROFILE:-performance}
SQL_QUERY_TIMEOUT_MS: ${SQL_QUERY_TIMEOUT_MS:-15000}
QUERY_HARD_MAX_ROWS: ${QUERY_HARD_MAX_ROWS:-1000}
ANALYTICS_ENABLED: ${ANALYTICS_ENABLED:-true}
ANALYTICS_RAW_RETENTION_DAYS: ${ANALYTICS_RAW_RETENTION_DAYS:-14}
ANALYTICS_FLUSH_INTERVAL_MS: ${ANALYTICS_FLUSH_INTERVAL_MS:-1000}
ANALYTICS_MAX_QUEUE: ${ANALYTICS_MAX_QUEUE:-10000}
ANALYTICS_STORAGE_SAMPLE_MINUTES: ${ANALYTICS_STORAGE_SAMPLE_MINUTES:-60}
ANALYTICS_STORAGE_RETENTION_DAYS: ${ANALYTICS_STORAGE_RETENTION_DAYS:-90}
ANALYTICS_TRAFFIC_ENABLED: ${ANALYTICS_TRAFFIC_ENABLED:-true}
SNAPSHOTS_ENABLED: ${SNAPSHOTS_ENABLED:-true}
SNAPSHOT_LIBSQL_ENABLED: ${SNAPSHOT_LIBSQL_ENABLED:-true}
SNAPSHOT_LIBSQL_VERIFY_REPLAY: ${SNAPSHOT_LIBSQL_VERIFY_REPLAY:-true}
SNAPSHOT_LIBSQL_MAX_BYTES: ${SNAPSHOT_LIBSQL_MAX_BYTES:-10737418240}
SNAPSHOT_LIBSQL_DUMP_TIMEOUT_MS: ${SNAPSHOT_LIBSQL_DUMP_TIMEOUT_MS:-900000}
SCHEMA_CACHE_TTL_MS: ${SCHEMA_CACHE_TTL_MS:-60000}
SCHEMA_CACHE_MAX_ENTRIES: ${SCHEMA_CACHE_MAX_ENTRIES:-200}
METRICS_CACHE_TTL_MS: ${METRICS_CACHE_TTL_MS:-5000}
RUNTIME_HEALTH_INTERVAL_MINUTES: ${RUNTIME_HEALTH_INTERVAL_MINUTES:-10}
RUNTIME_HEALTH_PUBLIC_TIMEOUT_MS: ${RUNTIME_HEALTH_PUBLIC_TIMEOUT_MS:-5000}
RUNTIME_HEALTH_STARTUP_DELAY_SECONDS: ${RUNTIME_HEALTH_STARTUP_DELAY_SECONDS:-20}
RUNTIME_HEALTH_CONCURRENCY: ${RUNTIME_HEALTH_CONCURRENCY:-4}
SNAPSHOT_INTERVAL_MINUTES: ${SNAPSHOT_INTERVAL_MINUTES:-60}
SNAPSHOT_FULL_WINDOW_HOURS: ${SNAPSHOT_FULL_WINDOW_HOURS:-24}
SNAPSHOT_SIX_HOURLY_WINDOW_HOURS: ${SNAPSHOT_SIX_HOURLY_WINDOW_HOURS:-72}
SNAPSHOT_RETENTION_DAYS: ${SNAPSHOT_RETENTION_DAYS:-14}
SNAPSHOT_SCHEDULER_TICK_MINUTES: ${SNAPSHOT_SCHEDULER_TICK_MINUTES:-5}
SNAPSHOT_TIMEZONE: ${SNAPSHOT_TIMEZONE:-UTC}
SNAPSHOT_MAX_CONCURRENT: ${SNAPSHOT_MAX_CONCURRENT:-1}
SNAPSHOT_MIN_FREE_BYTES: ${SNAPSHOT_MIN_FREE_BYTES:-1073741824}
SNAPSHOT_STALE_MINUTES: ${SNAPSHOT_STALE_MINUTES:-30}
SNAPSHOT_VERIFY_ON_RESTORE: ${SNAPSHOT_VERIFY_ON_RESTORE:-true}
SNAPSHOT_STORAGE_ROOT: ${SNAPSHOT_STORAGE_ROOT:-/app/data/sqlite/snapshots}
env_file:
- path: ./backend/.env
required: false
volumes:
- ${BACKEND_DATA_DIR_HOST:-./backend/data}:/app/data
- ${SQLD_DATA_DIR_HOST:-./backend/data/sqld}:/app/data/sqld
- /var/run/docker.sock:/var/run/docker.sock
extra_hosts:
- 'host.docker.internal:host-gateway'
depends_on:
sqld:
condition: service_started
restart: unless-stopped
networks:
- coolify
healthcheck:
test: ['CMD-SHELL', 'wget -qO- http://localhost:5000/api/v1/health 2>/dev/null || exit 1']
interval: 15s
timeout: 5s
retries: 8
start_period: 30s
frontend:
build:
context: ./frontend
args:
NEXT_PUBLIC_API_URL: ${NEXT_PUBLIC_API_URL:-http://localhost:5000/api/v1}
ports:
- '${FRONTEND_PORT_BIND:-5001}:5001'
environment:
NEXT_PUBLIC_API_URL: ${NEXT_PUBLIC_API_URL:-http://localhost:5000/api/v1}
INTERNAL_API_URL: ${INTERNAL_API_URL:-http://backend:5000/api/v1}
depends_on:
- backend
restart: unless-stopped
networks:
- coolify
networks:
coolify:
external: true