5.1. PostgreSQL Standard

5.1.1. Mandatory Use Declaration

All relational databases in TQS certified projects must use PostgreSQL. Other RDBMS such as MySQL, MariaDB, or Oracle are not permitted.

Item	Requirement
RDBMS	PostgreSQL
Minimum Version	15 or higher
Recommended Version	16 or higher (latest stable version)
Character Set	UTF-8

5.1.2. Local Development Environment

In the local development environment, PostgreSQL must be configured using Docker Compose.

# docker-compose.yml
version: '3.8'

services:
  postgres:
    image: postgres:16-alpine
    container_name: flowin-postgres
    environment:
      POSTGRES_DB: flowin
      POSTGRES_USER: flowin
      POSTGRES_PASSWORD: flowin1234
    ports:
      - "5432:5432"
    volumes:
      - postgres-data:/var/lib/postgresql/data

volumes:
  postgres-data:

# Start
docker compose up -d

# Verify connection
docker compose exec postgres psql -U flowin -d flowin

Caution

The password in docker-compose.yml is for local development only. Passwords for production environments must be managed through environment variables or a secret manager.