Blitz.js + PostgreSQL

Key Features

• Zero-API data layer enabling direct server function calls from React components without REST endpoints
• Built-in Prisma ORM integration with PostgreSQL for type-safe database operations and automatic migrations
• Blitz Auth system with session-based authentication, password hashing, and user management out of the box
• Rails-inspired code generators (blitz generate all) for rapid scaffolding of models, queries, and mutations
• PostgreSQL's JSONB support for storing complex application state alongside relational data with full indexing
• Full-text search capabilities using PostgreSQL's built-in search features with ranking and highlighting
• Automatic TypeScript configuration with end-to-end type safety from database to frontend components
• Hot reloading development environment with automatic database schema synchronization

Common Use Cases

• 1SaaS applications requiring user authentication, subscription management, and complex data relationships
• 2E-commerce platforms needing product catalogs, inventory management, and order processing with ACID transactions
• 3Content management systems leveraging PostgreSQL's full-text search for articles, documentation, or blogs
• 4Customer relationship management (CRM) tools with complex queries across related entities like contacts, deals, and activities
• 5Multi-tenant applications using PostgreSQL's row-level security and schema isolation features
• 6Analytics dashboards requiring complex aggregations and window functions across large datasets
• 7Social platforms needing user profiles, relationships, and activity feeds with real-time updates

Prerequisites

• Docker and Docker Compose installed with minimum 2GB RAM available for PostgreSQL operations
• Node.js 16+ knowledge and familiarity with React hooks and component patterns
• Basic understanding of SQL queries and relational database concepts for Prisma schema design
• Environment file (.env) configured with DB_NAME, DB_USER, and DB_PASSWORD variables
• Port 3000 available for Blitz.js development server and port 5432 for PostgreSQL connections
• Dockerfile present in project root for Blitz.js application build process

docker-compose.yml

1services: 
2  blitz: 
3    build: .
4    container_name: blitz
5    environment: 
6      DATABASE_URL: postgresql://${DB_USER}:${DB_PASSWORD}@postgres:5432/${DB_NAME}
7    ports: 
8      - "3000:3000"
9    depends_on: 
10      - postgres
11    networks: 
12      - blitz-network
13
14  postgres: 
15    image: postgres:16-alpine
16    environment: 
17      POSTGRES_DB: ${DB_NAME}
18      POSTGRES_USER: ${DB_USER}
19      POSTGRES_PASSWORD: ${DB_PASSWORD}
20    volumes: 
21      - postgres_data:/var/lib/postgresql/data
22    networks: 
23      - blitz-network
24
25volumes: 
26  postgres_data: 
27
28networks: 
29  blitz-network: 
30    driver: bridge

.env Template

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

Usage Notes

Individual Services(2 services)

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

blitz:
  build: .
  container_name: blitz
  environment:
    DATABASE_URL: postgresql://${DB_USER}:${DB_PASSWORD}@postgres:5432/${DB_NAME}
  ports:
    - "3000:3000"
  depends_on:
    - postgres
  networks:
    - blitz-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:
    - blitz-network

Quick Start

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

Troubleshooting