services:
  share-db: 
    environment: 
      POSTGRES_DB: share-db
      POSTGRES_PASSWORD: password
      POSTGRES_USER: postgres
    image: postgres
    restart: always
    volumes: 
      - ./data/sharedb:/var/lib/postgresql/data
  noco:
    container_name: noco
    image: nocodb/nocodb:latest
    depends_on:
      - noco-db
    ports:
      - 3006:8080
    environment:
      NC_DB: pg://noco-db:5432?u=postgres&p=password&d=database-noco
      VIRTUAL_HOST: sheets.phillybotc.com
      LETSENCRYPT_HOST: sheets.phillybotc.com
      LETSENCRYPT_EMAIL: ${EMAIL}
    volumes: 
      - ./noco:/usr/app/data
  noco-db: 
    environment: 
      POSTGRES_DB: database-noco
      POSTGRES_PASSWORD: password
      POSTGRES_USER: postgres
    image: postgres
    restart: always
    volumes: 
      - ./data/nocodb:/var/lib/postgresql/data
  metabase:
    container_name: metabase
    image: metabase/metabase:latest
    depends_on:
      - metabase-db
    ports:
      - 4018:3000
    environment:
      MB_DB_TYPE: postgres
      MB_DB_DBNAME: ${PGDATABASE:-postgres}
      MB_DB_PORT: 5432
      MB_DB_USER: ${PGUSER:-postgres}
      MB_DB_PASS: ${PGPASSWORD}
      MB_DB_HOST: ${PGHOST}
      VIRTUAL_HOST: "dash.phillybotc.com"
      LETSENCRYPT_HOST: "dash.phillybotc.com"
      LETSENCRYPT_EMAIL: ${EMAIL}
  metabase-db:
    container_name: metabase-db
    image: postgres:15.4
    restart: always
    environment:
      POSTGRES_PASSWORD: ${PGPASSWORD}
      POSTGRES_USER: ${PGUSER:-postgres}
      POSTGRES_DB: ${PGDATABASE:-postgres}
    volumes:
      - ./data/metabase:/var/lib/postgresql/data
networks:
  default:
    name: nginx-proxy
    external: true