PostgreSQL Service Containers and Prisma Migrations in CI Repository and HTTP integration tests need a real PostgreSQL database. GitHub Actions service containers provide an isolated test database on Linux runners. Apply committed Prisma migrations with migrate deploy before integration tests so CI catches migration drift instead of silently creating schema from models.
Repository Postgres 18 → Migrations → tests → HTTP E2E
What this changes in TaskFlow • postgres:18 service container
• health check before tests
• prisma generate
• prisma migrate deploy
• integration + HTTP E2E
Integration database services: postgres: image: postgres:18 options: --health-cmd="pg_isready ..."
run: pnpm --filter api exec prisma migrate deployGitHub documents PostgreSQL service containers on Ubuntu/Linux runners; Prisma migrate deploy applies committed migrations.
Containers package a process and its runtime assumptions. The lesson is not memorizing Docker commands; it is making those assumptions repeatable and observable.
Restate the goal of “PostgreSQL Service Containers and Prisma Migrations in CI” as one observable behavior. Write the success signal before touching code.
Trace the boundary map: source + lockfile → build context → image layers → container process → health signal. Mark the one boundary this lesson changes.
Inspect the current repository state and record the exact files, route, table, or runtime involved. Avoid creating an abstraction before you can name the existing owner.
Implement the smallest vertical slice. Add one coherent change, run the narrowest verification command, and read the output before continuing.
Connect the slice to TaskFlow’s phase artifact: .github/workflows/ci.yml plus release/deploy workflows that build once, tag by commit SHA, and gate promotion.. Verify behavior from the outside as a user or API client would.
Create one controlled failure that is safe to reproduce. Predict the symptom first, capture evidence, locate the earliest broken boundary, then fix only that cause.
Close the reference and rebuild or explain the core change from memory. Record what you would monitor or test before trusting the same change in production.
FROM node:24-alpine AS build
WORKDIR /app
RUN corepack enable
COPY package.json pnpm-lock.yaml pnpm-workspace.yaml ./
COPY apps/api/package.json apps/api/package.json
RUN pnpm install --frozen-lockfile
COPY . .
RUN pnpm --filter api buildDo not copy this as a finished answer. Predict what each boundary does, type the smallest useful slice, run it, then compare the result with your prediction.
Inspect container logs and PID 1 command; confirm the process stays in foreground and required config exists.
Check bind address, exposed/published ports, network namespace, and health endpoint.
Without copying the final source, create a second small scenario that applies “PostgreSQL Service Containers and Prisma Migrations in CI” to a different TaskFlow resource or input. Write the acceptance criteria first, implement it, and provide the evidence that each criterion is satisfied.
Create trusted-main release workflow that tags an image/artifact with the commit SHA rather than latest only.
Use the smallest change that demonstrates this lesson. Stop after it works and capture evidence.Using pull_request_target with untrusted checkout/secrets
Predict the symptom before causing the failure. Then locate the earliest boundary where reality diverges from expectation.Why does this responsibility live here, what input does it trust, what output proves success, and what would go wrong if another layer owned it?
If your explanation is vague, repeat the boundary trace before moving on.Close the reference. Reproduce the core idea from memory or explain the exact request/data flow aloud. Then check your diff or notes for accidental shortcuts that bypass validation, authorization, error handling, or verification earned in earlier phases.