libsqlgestion/docker-compose.yml at main · Benchav/libsqlgestion · 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
services:
  sqld:
    image: ${LIBSQL_SERVER_IMAGE:-ghcr.io/tursodatabase/libsql-server:latest}
    command:
      - /bin/sqld
      - --enable-namespaces
      - --http-listen-addr=0.0.0.0:8080
      - --admin-listen-addr=0.0.0.0:9090
      - --auth-jwt-key-file=/var/lib/sqld/auth.pem
      - --db-path=/var/lib/sqld/data
    expose:
      - '8080'
      - '9090'
    volumes:
      - ${SQLD_DATA_DIR_HOST:-./backend/data/sqld}:/var/lib/sqld
    restart: unless-stopped
    networks:
      - coolify
    labels:
      - "traefik.enable=true"
      - "traefik.http.routers.sqld.rule=HostRegexp(`{subdomain:[a-z0-9-]+}.${DATABASE_PUBLIC_DOMAIN:-localhost}`)"
      - "traefik.http.services.sqld.loadbalancer.server.port=8080"

  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'
      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_PERFORMANCE_PROFILE: ${SQLITE_PERFORMANCE_PROFILE:-performance}
    env_file:
      - ./backend/.env
    volumes:
      - ${BACKEND_DATA_DIR_HOST:-./backend/data}:/app/data
      - /var/run/docker.sock:/var/run/docker.sock
    extra_hosts:
      - 'host.docker.internal:host-gateway'
    depends_on:
      - sqld
    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