PostgreSQL Blob Storage Setup

This project has been updated to store uploaded files as blobs in PostgreSQL using Prisma ORM.

Database Schema

The File model in prisma/schema.prisma:

id: Unique identifier (CUID)
filename: Original filename
mimetype: File MIME type
size: File size in bytes
data: File content as binary data (PostgreSQL ByteA type)
createdAt: Timestamp when file was uploaded
updatedAt: Last update timestamp

Setup Instructions

1. Start PostgreSQL Database

# Using Docker Compose
docker-compose up -d postgres

# Or use your own PostgreSQL instance
# Update DATABASE_URL in .env accordingly

2. Database Migration

# Run Prisma migrations
npx prisma migrate dev --name init

# Generate Prisma Client
npx prisma generate

3. Start Development Server

npm run dev

API Endpoints

Upload File

POST /api/upload
Content-Type: multipart/form-data
Body: Form data with file field
Response: File metadata (id, filename, mimetype, size, createdAt)

List Files

GET /api/files
Response: Array of file metadata (excluding binary data)

Download File

GET /api/files/[id]
Response: File content with appropriate headers
Headers: Content-Type, Content-Disposition, Content-Length

Testing

Open http://localhost:3000 to test with the main application
Use test-upload.html for simple testing
Use Prisma Studio for database inspection:
```
npx prisma studio
```

Environment Variables

DATABASE_URL: PostgreSQL connection string
ROOT_PATH: Project root path (for legacy file system operations)

Docker Setup

The project includes Docker Compose configuration for easy PostgreSQL setup:

PostgreSQL 15 with persistent storage
Automatic database creation
Port mapping: localhost:5432