Create Dockerfile and docker-compose.yml for containerization

[cursor]

Description

The audit identified that the project lacks Docker containerization, which would improve deployment and development consistency.

Context

Current state:

• No Dockerfile
• No docker-compose.yml
• Manual deployment process
• Environment setup can be inconsistent

Requirements

1. Create Dockerfile

   • Multi-stage build (dev and production)
   • Optimize for Next.js standalone output
   • Include Prisma client generation
   • Proper layer caching

2. Create docker-compose.yml

   • PostgreSQL database service
   • Application service
   • Volume mounts for development
   • Environment variables

3. Documentation

   • Docker setup instructions
   • Development workflow with Docker
   • Production deployment guide

Acceptance Criteria

• Dockerfile created and tested
• docker-compose.yml for local development
• Application runs in container
• Database connection works
• Documentation updated

Related

• Audit Report: PR Project audit and review #63
• Audit Finding: CI/CD section - Docker missing

Priority

Medium - Deployment improvement