Fresh + PostgreSQL

Key Features

• Island architecture with selective hydration reduces JavaScript bundle sizes by 90% compared to traditional SPAs
• Zero-config TypeScript and JSX serving directly from Deno runtime without build steps
• File-based routing system with automatic code splitting and lazy loading
• PostgreSQL JSONB support enables hybrid relational-document data models within Fresh components
• Preact-based islands with automatic client-server state synchronization
• Built-in Deno PostgreSQL drivers with type-safe query builders and prepared statements
• Fresh's edge-ready SSR combined with PostgreSQL's logical replication for global deployments
• Advanced PostgreSQL features like full-text search, window functions, and CTEs accessible through Deno APIs

Common Use Cases

• 1E-commerce platforms requiring fast page loads with complex product catalogs and inventory management
• 2Content management systems leveraging PostgreSQL's full-text search and Fresh's island architecture for editorial interfaces
• 3SaaS dashboards with real-time data visualization using PostgreSQL's JSON aggregation and Fresh's selective hydration
• 4Multi-tenant applications utilizing PostgreSQL's row-level security with Fresh's server-side rendering
• 5Geospatial applications combining PostGIS extensions with Fresh's lightweight client-side mapping components
• 6Developer portfolios and blogs with PostgreSQL-backed content and Fresh's near-instant page transitions
• 7Progressive web applications requiring offline-first capabilities with PostgreSQL's advanced transaction handling

Prerequisites

• Minimum 1GB RAM for PostgreSQL with recommended 2GB+ for production workloads
• Deno runtime knowledge including import maps and permission system concepts
• Basic understanding of Preact/React component patterns and JSX syntax
• PostgreSQL experience with SQL queries, indexing strategies, and connection pooling
• Port 8000 available for Fresh development server and standard PostgreSQL port 5432
• Familiarity with island architecture concepts and server-side rendering principles

docker-compose.yml

1services: 
2  fresh: 
3    image: denoland/deno:latest
4    container_name: fresh
5    working_dir: /app
6    command: run -A main.ts
7    environment: 
8      DATABASE_URL: postgresql://${DB_USER}:${DB_PASSWORD}@postgres:5432/${DB_NAME}
9    volumes: 
10      - ./:/app
11    ports: 
12      - "8000:8000"
13    depends_on: 
14      - postgres
15    networks: 
16      - fresh-network
17
18  postgres: 
19    image: postgres:16-alpine
20    environment: 
21      POSTGRES_DB: ${DB_NAME}
22      POSTGRES_USER: ${DB_USER}
23      POSTGRES_PASSWORD: ${DB_PASSWORD}
24    volumes: 
25      - postgres_data:/var/lib/postgresql/data
26    networks: 
27      - fresh-network
28
29volumes: 
30  postgres_data: 
31
32networks: 
33  fresh-network: 
34    driver: bridge

.env Template

1DB_NAME=fresh
2DB_USER=fresh
3DB_PASSWORD=changeme

Usage Notes

Individual Services(2 services)

Copy individual services to mix and match with your existing compose files.

fresh:
  image: denoland/deno:latest
  container_name: fresh
  working_dir: /app
  command: run -A main.ts
  environment:
    DATABASE_URL: postgresql://${DB_USER}:${DB_PASSWORD}@postgres:5432/${DB_NAME}
  volumes:
    - ./:/app
  ports:
    - "8000:8000"
  depends_on:
    - postgres
  networks:
    - fresh-network

postgres:
  image: postgres:16-alpine
  environment:
    POSTGRES_DB: ${DB_NAME}
    POSTGRES_USER: ${DB_USER}
    POSTGRES_PASSWORD: ${DB_PASSWORD}
  volumes:
    - postgres_data:/var/lib/postgresql/data
  networks:
    - fresh-network

Quick Start

1# 1. Create the compose file
2cat > docker-compose.yml << 'EOF'
3services:
4  fresh:
5    image: denoland/deno:latest
6    container_name: fresh
7    working_dir: /app
8    command: run -A main.ts
9    environment:
10      DATABASE_URL: postgresql://${DB_USER}:${DB_PASSWORD}@postgres:5432/${DB_NAME}
11    volumes:
12      - ./:/app
13    ports:
14      - "8000:8000"
15    depends_on:
16      - postgres
17    networks:
18      - fresh-network
19
20  postgres:
21    image: postgres:16-alpine
22    environment:
23      POSTGRES_DB: ${DB_NAME}
24      POSTGRES_USER: ${DB_USER}
25      POSTGRES_PASSWORD: ${DB_PASSWORD}
26    volumes:
27      - postgres_data:/var/lib/postgresql/data
28    networks:
29      - fresh-network
30
31volumes:
32  postgres_data:
33
34networks:
35  fresh-network:
36    driver: bridge
37EOF
38
39# 2. Create the .env file
40cat > .env << 'EOF'
41DB_NAME=fresh
42DB_USER=fresh
43DB_PASSWORD=changeme
44EOF
45
46# 3. Start the services
47docker compose up -d
48
49# 4. View logs
50docker compose logs -f

One-Liner

Run this command to download and set up the recipe in one step:

1curl -fsSL https://docker.recipes/api/recipes/fresh-postgres/run | bash

Troubleshooting