render.yaml

services:
  # Main application (frontend + backend in one container)
  - type: web
    name: algoroom
    runtime: docker
    dockerfilePath: ./Dockerfile
    dockerContext: .
    plan: free  # or starter for production
    region: oregon  # Choose same region as database
    healthCheckPath: /health
    envVars:
      - key: DATABASE_URL
        fromDatabase:
          name: algoroom-db
          property: connectionString
      - key: REPOSITORY_TYPE
        value: postgres
      - key: DATABASE_POOL_SIZE
        value: "3"
      - key: DATABASE_MAX_OVERFLOW
        value: "5"

databases:
  - name: algoroom-db
    plan: free  # Free tier: 90 days, then expires
    region: oregon
    databaseName: algoroom
    user: algoroom