services:
  db:
    container_name: template_postgres_db
    image: postgres:latest
    environment:
      POSTGRES_USER: ${DATABASE_USER}
      POSTGRES_PASSWORD: ${DATABASE_PASSWORD}
      POSTGRES_DB: ${DATABASE_NAME}
    ports:
      - "5432:5432"
    restart: always
    volumes:
      - postgres_data:/var/lib/postgresql/data
    networks:
      - my_network

  web:
    build: .
    ports:
      - "3000:3000"
    env_file:
      - ./env.production
    depends_on:
      - db
    networks:
      - my_network

volumes:
  postgres_data:

networks:
  my_network:
    name: my_network
    driver: bridge

FROM node:18-alpine AS base

# Install pnpm globally
RUN npm install -g pnpm

# Stage 1: Install dependencies
FROM base AS deps
WORKDIR /app
COPY package.json pnpm-lock.yaml ./
RUN pnpm install --frozen-lockfile
COPY . .

RUN pnpm db:generate
RUN pnpm db:push

# Stage 2: Build the application
FROM base AS builder
WORKDIR /app
COPY --from=deps /app/node_modules ./node_modules
COPY . .
RUN pnpm run build

# Stage 3: Production server
FROM base AS runner
WORKDIR /app
ENV NODE_ENV=production
COPY --from=builder /app/public ./public
COPY --from=builder /app/.next/standalone ./
COPY --from=builder /app/.next/static ./.next/static

EXPOSE 3000
CMD node server.js

NODE_ENV=production
# Database
DATABASE_USER=my_user
DATABASE_PASSWORD=my_password
DATABASE_HOST=db
DATABASE_PORT=5432
DATABASE_NAME=my_database
DATABASE_URL=postgresql://my_user:my_password@db:5432/my_database

services:
  db:
    container_name: template_postgres_db
    image: postgres:latest
    environment:
      POSTGRES_USER: ${DATABASE_USER}
      POSTGRES_PASSWORD: ${DATABASE_PASSWORD}
      POSTGRES_DB: ${DATABASE_NAME}
    ports:
      - "5432:5432"
    restart: always
    volumes:
      - postgres_data:/var/lib/postgresql/data
    networks:
      - my_network

  migrations:
    build: .
    command: ["pnpm", "db:generate && pnpm db:push"]  # Run Drizzle migrations
    depends_on:
      db:
        condition: service_healthy  # Wait for DB to be ready
    env_file:
      - ./env.production
    networks:
      - my_network

  web:
    build: .
    ports:
      - "3000:3000"
    env_file:
      - ./env.production
    depends_on:
      migrations:
        condition: service_completed_successfully  # Wait for migrations
    networks:
      - my_network

volumes:
  postgres_data:

networks:
  my_network:
    name: my_network
    driver: bridge

healthcheck:
      test: ["CMD-SHELL", "pg_isready -U ${DATABASE_USER} -d ${DATABASE_NAME}"]
      interval: 5s
      timeout: 5s
      retries: 5

Attaching to migrations-1, web-1, postgres_db
migrations-1  |
migrations-1  | > template@0.1.0 db:generate /app
migrations-1  | > pnpm drizzle-kit generate              
migrations-1  |
migrations-1  | undefined                                 
migrations-1  |  ERR_PNPM_RECURSIVE_EXEC_FIRST_FAIL  Command "drizzle-kit" not found
migrations-1  |  ELIFECYCLE  Command failed with exit code 254.                                                                                                         
migrations-1 exited with code 254
Gracefully stopping... (press Ctrl+C again to force)

#!/bin/sh

# Wait for Postgres to be ready
until pg_isready -h postgres -p 5432 -U postgres
do
  echo "Waiting for postgres..."
  sleep 2
done

echo "PostgreSQL started"
pnpm prisma db push
pnpm start

postgres_db  | 2025-03-04 03:34:46.974 UTC [7689] ERROR:  relation "todos" does not exist at character 60
postgres_db  | 2025-03-04 03:34:46.974 UTC [7689] STATEMENT:  select "id", "description", "created_at", "completed" from "todos" order by "todos"."id"
web-1        |  ⨯ error: relation "todos" does not exist                         
web-1        |     at async (.next/server/chunks/158.js:7:36596)
web-1        |     at async m (.next/server/app/(core)/todos/page.js:2:7144) 
....

import dotenv from 'dotenv';
import path from 'path';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import { client, db } from './drizzle';

dotenv.config();

async function main() {
  await migrate(db, {
    migrationsFolder: path.join(process.cwd(), './lib/db/migrations'),
  });
  console.log(`Migrations complete`);
  await client.end();
}

main();

Both the Next.js app and PostgreSQL database will be up and running in Docker containers. To set up your database, you could install npm inside your Postgres container and use the Drizzle scripts, or you can use psql:

> docker exec -it myapp-db-1 sh
> apk add --no-cache postgresql-client
> psql -U myuser -d mydatabase -c '
> CREATE TABLE IF NOT EXISTS "todos" (
>   "id" serial PRIMARY KEY NOT NULL,
>   "content" varchar(255) NOT NULL,
>   "completed" boolean DEFAULT false,
>   "created_at" timestamp DEFAULT now()
> );'

CREATE TABLE IF NOT EXISTS "todos" (
  "id" serial PRIMARY KEY NOT NULL,
  "content" varchar(255) NOT NULL,
  "completed" boolean DEFAULT false,
  "created_at" timestamp DEFAULT now()
);

FROM ...
# rest of your config
RUN apk add --no-cache postgresql-client

# do all the building and stuff here 
RUN chmod +x run_server.sh
CMD ["/run_server.sh"]

#!/bin/sh
until pg_isready -h postgres -d 5432 -U postgres
do 
  echo "Waiting for Postgres to start"
  sleep 2
done

echo "Postgresql Started. Running migrations..."
node ./scripts/run-migrations.js
echo "Ran migrations. Starting the server..."
pnpm start