DATABASE_URL

• When you wanna run postgres using docker on your local machine. Map postgres container port:5432 to ur mac machine port:5432

DATABASE_URL=postgresql://postgres:mysecretpassword@localhost:5432/postgres

• When you wanna run postgres container and connect to it via app container. Map postgres container port:5432 to app container port:5432 via network you need to specify postgres container —name

DATABASE_URL=postgresql://postgres:mysecretpassword@postgres_container:5432/postgres

• When you are using docker-compose.yml. All services are connected via network ( you don’t have to externally specify it ) and postgres gets automatically pulled from docker-hub

DATABASE_URL=postgresql://postgres:mysecretpassword@postgres:5432/postgres

Error Faced

psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: role "postgres" does not exist

# Check if port is already in use
lsof -i :5432

• If local postgres is running on your machine it gets binded to localhost:5432 first, so postgres running on docker container couldn’t get mapped.

brew services stop postgresql #Stop postgres locally

Setting up a nodejs project locally using Docker/Docker Compose

package.json scripts

 "build" : "tsc -b",
 "dev:docker" : "npx prisma migrate dev && node dist/index.js",
 "dev" : "npm run build && npm run dev:docker"

Contributing.md

contributing: |
  # 🤝 Contributing Guide

  Thank you for considering contributing to this project! This document will help you set up the environment and guide you through submitting changes.

  ## 🛠 Manual Installation

  - Install Node.js locally: <https://nodejs.org/en/download>
  - Install Docker & Docker Compose: <https://www.docker.com/products/docker-desktop>
  - Clone the repository:

    ```bash
    git clone <https://github.com/RitikaxG/Docker-Compose.git>
    cd Docker-Compose
    ```

  - Install dependencies:

    ```bash
    npm install
    ```

  - Create volume for the Postgres container:

    ```bash
    docker volume create postgres_volume
    ```

  - Create a Docker network:

    ```bash
    docker network create postgres_network
    ```

  - Start Postgres DB locally using Docker:

    ```bash
    docker run --name postgres_container \
      --volume postgres_volume:/var/lib/postgresql/data \
      --network postgres_network \
      -e POSTGRES_PASSWORD=mysecretpassword \
      -p 5432:5432 \
      -d postgres
    ```

    **OR** go to <https://neon.tech> and get your `DATABASE_URL` (PostgreSQL connection string)

  - Update the `.env` file with your database credentials. Example:

    ```env
    DATABASE_URL=postgresql://postgres:mysecretpassword@loaclhost:5432/postgres
    ```
    this will allow you to run postgres using docker on your mac machine

  - Run Prisma migration:

    ```bash
    npx prisma migrate dev
    ```

  - Generate the Prisma client:

    ```bash
    npx prisma generate
    ```

  - Start the development server:

    ```bash
    npm run dev
    ```

  The server should be running on <http://localhost:3000> 🚀

  ## Docker Installation

  - Install Docker
  - Create volume for the Postgres container:

    ```bash
    docker volume create postgres_volume
    ```

  - Create a Docker network:

    ```bash
    docker network create postgres_network
    ```

  - Start Postgres DB locally using Docker:

    ```bash
    docker run --name postgres_container \
      --volume postgres_volume:/var/lib/postgresql/data \
      --network postgres_network \
      -e POSTGRES_PASSWORD=mysecretpassword \
      -p 5432:5432 \
      -d postgres
    ```

  - Update the `.env` file with your database credentials. Example:

    ```env
    DATABASE_URL=postgresql://postgres:mysecretpassword@postgres_container:5432/postgres
    ```

    this allow you to run postgres using docker (postgres_container) and use it inside another docker container (docker-app:v1) which you start by specifying --network postgres_network (imp)

  - Build the image

    ```bash
    docker build --network=host -t docker-app:v1 .
    ```

  - Start the image

  ```bash
  docker run --network postgres_network -p 3000:3000 -d docker-app:v1

The server should be running on http://localhost:3000 🚀

Docker Compose Installation

• Install Docker, Docker Compose

stop already running postgres container if any, (postgres image is directly pulled from docker_hub and started )

• Run docker-compose up