docker-compose.yml

services:
    postgresql:
        image: library/postgres:16
        hostname: ${POSTGRES_HOST}
        restart: unless-stopped
        env_file:
            - .envrc
        volumes:
            - postgresql-data:/var/lib/postgresql/data
        ports:
            - "${PGPORT}:${PGPORT}"

    sqlrunner:
        build:
            context: .
            dockerfile: sqlrunner/Dockerfile
        env_file:
            - .envrc
        environment:
            DATABASE_URL: ${DOCKER_DATABASE_URL}
        depends_on:
            - postgresql

    redis:
        image: library/redis:latest
        hostname: ${REDIS_HOST}
        restart: unless-stopped
        env_file:
            - .envrc
        ports:
            - "${REDIS_PORT}:${REDIS_PORT}"

    server:
        build:
            context: .
            dockerfile: server/Dockerfile
        restart: unless-stopped
        env_file:
            - .envrc
        environment:
            DATABASE_URL: ${DOCKER_DATABASE_URL}
            KV_URL: ${DOCKER_KV_URL}
        ports:
            - "${SERVER_PORT}:${SERVER_PORT}"
        depends_on:
            - postgresql
            - sqlrunner
            - redis

    pgadmin:
        image: elestio/pgadmin:latest
        restart: unless-stopped
        env_file:
            - .envrc
        ports:
            - "${PGADMIN_PORT}:80"
        volumes:
            - pgadmin-data:/var/lib/pgadmin
        depends_on:
            - postgresql

    # llm:
    #     image: ollama/ollama:latest
    #     hostname: ${LLM_HOST}
    #     restart: unless-stopped
    #     tty: true
    #     ports:
    #         - "${LLM_PORT}:${LLM_PORT}"
    #     volumes:
    #         - llm:/root/.ollama

    # llm-setup:
    #     build:
    #         context: .
    #         dockerfile: llm/Dockerfile
    #     restart: unless-stopped
    #     env_file:
    #         - .envrc

volumes:
    postgresql-data:
    pgadmin-data:
    # llm: