Go Fiber + PostgreSQL

Key Features

• Zero memory allocation HTTP router with Express-inspired API design
• Fasthttp engine providing 10x faster performance than standard Go net/http
• ACID compliance with advanced PostgreSQL transaction support and isolation levels
• Built-in middleware support for authentication, CORS, logging, and request validation
• PostgreSQL JSON/JSONB columns for hybrid relational-document data models
• Advanced SQL capabilities including window functions, CTEs, and table partitioning
• Go's native concurrency with goroutines handling thousands of simultaneous database connections
• PostgreSQL full-text search with ranking and highlighting for content-heavy applications

Common Use Cases

• 1High-performance REST APIs serving mobile applications with complex data relationships
• 2E-commerce platforms requiring ACID transactions for inventory and payment processing
• 3Real-time analytics dashboards with PostgreSQL's advanced aggregation functions
• 4Content management systems leveraging PostgreSQL's full-text search capabilities
• 5Financial applications where data integrity and transaction safety are critical
• 6Multi-tenant SaaS applications using PostgreSQL's row-level security features
• 7IoT data collection services requiring fast ingestion with relational data analysis

Prerequisites

• Docker and Docker Compose installed with at least 1.5GB available RAM
• Go development knowledge including struct tags and error handling patterns
• PostgreSQL/SQL experience for database schema design and query optimization
• Port 3000 available for the Fiber application HTTP server
• Understanding of database connection pooling and Go's database/sql package
• Familiarity with environment variable configuration for database credentials

docker-compose.yml

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

.env Template

1DB_NAME=goapp
2DB_USER=gouser
3DB_PASSWORD=changeme

Usage Notes

Individual Services(2 services)

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

app:
  build: .
  container_name: go-fiber
  environment:
    DATABASE_URL: postgres://${DB_USER}:${DB_PASSWORD}@postgres:5432/${DB_NAME}?sslmode=disable
  ports:
    - "3000:3000"
  depends_on:
    - postgres
  networks:
    - gofiber

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

Quick Start

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

Troubleshooting