docker-compose.yml

services:
  database:
    image: docker.io/mariadb:latest
    restart: unless-stopped
    labels:
      - "traefik.enable=true"
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD}
      MYSQL_DATABASE: ${MYSQL_DATABASE}
      MYSQL_USER: ${MYSQL_USER}
      MYSQL_PASSWORD: ${MYSQL_PASSWORD}
    volumes:
      - ./database_data:/var/lib/mysql
    ports:
      - "3306"
    networks:
      vpcbr:
        ipv4_address: 172.21.0.2

  phpmyadmin:
    image: docker.io/phpmyadmin/phpmyadmin
    restart: unless-stopped
    labels:
      - "traefik.enable=true"
      - "traefik.http.routers.phpmyadmin.rule=PathPrefix(`/dappma`)"
      - "traefik.http.routers.phpmyadmin.middlewares=strip-phpmyadmin-prefix"
      - "traefik.http.middlewares.strip-phpmyadmin-prefix.stripPrefix.prefixes=/dappma"
      - "traefik.http.routers.phpmyadmin.entrypoints=web"
    environment:
      PMA_HOST: database
      PMA_ABSOLUTE_URI: http://${HOSTNAME}/dappma/
    volumes:
      - ./config.user.inc.php:/etc/phpmyadmin/config.user.inc.php
    networks:
      vpcbr:
        ipv4_address: 172.21.0.3
    depends_on:
      - database

###> doctrine/doctrine-bundle ###
  database:
    image: postgres:${POSTGRES_VERSION:-16}-alpine
    environment:
      POSTGRES_DB: ${POSTGRES_DB:-app}
      # You should definitely change the password in production
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-!ChangeMe!}
      POSTGRES_USER: ${POSTGRES_USER:-app}
    healthcheck:
      test: ["CMD", "pg_isready", "-d", "${POSTGRES_DB:-app}", "-U", "${POSTGRES_USER:-app}"]
      timeout: 5s
      retries: 5
      start_period: 60s
    volumes:
      - database_data:/var/lib/postgresql/data:rw
      # You may use a bind-mounted host directory instead, so that it is harder to accidentally remove the volume and lose all your data!
      # - ./docker/db/data:/var/lib/postgresql/data:rw
###< doctrine/doctrine-bundle ###

networks:
  vpcbr:
    driver: bridge
    ipam:
      config:
        - subnet: 172.21.0.0/16
          gateway: 172.21.0.1

volumes:
###> doctrine/doctrine-bundle ###
  database_data:
###< doctrine/doctrine-bundle ###