Echo + PostgreSQL

Key Features

• Echo's optimized HTTP router with radix tree implementation for sub-microsecond route matching
• Built-in HTTP/2 server support with automatic protocol negotiation and server push capabilities
• Native WebSocket support with Echo's context binding for real-time applications
• PostgreSQL JSONB integration for hybrid relational-document data models
• Echo middleware chain with PostgreSQL connection pooling for optimal database performance
• Automatic Let's Encrypt TLS certificate provisioning and renewal
• PostgreSQL's advanced indexing (GIN, GiST, BRIN) optimized for Echo's query patterns
• Built-in request validation and binding that maps directly to PostgreSQL constraints

Common Use Cases

• 1High-throughput REST APIs serving mobile applications with complex relational data requirements
• 2Real-time analytics dashboards using Echo's WebSocket support and PostgreSQL's window functions
• 3Multi-tenant SaaS platforms leveraging PostgreSQL's row-level security and Echo's JWT middleware
• 4E-commerce backends requiring ACID transactions for order processing and inventory management
• 5Geospatial applications using PostGIS extension with Echo's JSON response optimization
• 6Microservices architecture where individual services need both performance and data consistency
• 7Content management systems requiring full-text search capabilities and rapid content delivery

Prerequisites

• Go 1.19 or higher installed for building Echo applications and dependency management
• Minimum 1GB RAM for PostgreSQL optimal performance with connection pooling
• Port 1323 available for Echo web server and port 5432 for PostgreSQL connections
• Understanding of Go modules, goroutines, and interface-based programming patterns
• Familiarity with SQL and PostgreSQL-specific features like JSONB and array types
• Knowledge of HTTP middleware concepts and RESTful API design principles

docker-compose.yml

1services: 
2  echo: 
3    build: .
4    container_name: echo
5    environment: 
6      DATABASE_URL: postgres://${DB_USER}:${DB_PASSWORD}@postgres:5432/${DB_NAME}
7    ports: 
8      - "1323:1323"
9    depends_on: 
10      - postgres
11    networks: 
12      - echo-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      - echo-network
24
25volumes: 
26  postgres_data: 
27
28networks: 
29  echo-network: 
30    driver: bridge

.env Template

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

Usage Notes

Individual Services(2 services)

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

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

Quick Start

1# 1. Create the compose file
2cat > docker-compose.yml << 'EOF'
3services:
4  echo:
5    build: .
6    container_name: echo
7    environment:
8      DATABASE_URL: postgres://${DB_USER}:${DB_PASSWORD}@postgres:5432/${DB_NAME}
9    ports:
10      - "1323:1323"
11    depends_on:
12      - postgres
13    networks:
14      - echo-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      - echo-network
26
27volumes:
28  postgres_data:
29
30networks:
31  echo-network:
32    driver: bridge
33EOF
34
35# 2. Create the .env file
36cat > .env << 'EOF'
37DB_NAME=echo
38DB_USER=echo
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/echo-postgres/run | bash

Troubleshooting