⓪ηηωεε忧世
477436b55d
- Add migrations 002-009: organizations, users, user_organizations, integration_connections, customers, customer_events, health_scores, health_score_history, stripe_subscriptions, stripe_payments, alert_rules, alert_history - Add idempotent seed script with 1 org, 3 users, 50 customers, 500 events, health scores, subscriptions, payments, and alert rules - Add pgxpool-based connection pool with configurable tuning - Add transaction wrapper (WithTx) and query helpers - Add development query logger via pgx.QueryTracer - Add base repository pattern - Update config with MaxConnLifetime and HealthCheckSec - Add make seed and make migrate-down-all targets Closes #46, #47, #48, #49, #50, #51, #52, #53, #54, #55
27 lines
809 B
YAML
27 lines
809 B
YAML
services:
|
|
postgres:
|
|
image: postgres:16-alpine
|
|
container_name: pulsescore-postgres
|
|
restart: unless-stopped
|
|
ports:
|
|
- '${DB_PORT:-5434}:5432'
|
|
environment:
|
|
POSTGRES_USER: ${POSTGRES_USER:-pulsescore}
|
|
POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-pulsescore}
|
|
POSTGRES_DB: ${POSTGRES_DB:-pulsescore_dev}
|
|
volumes:
|
|
- pgdata:/var/lib/postgresql/data
|
|
- ./scripts/init-db:/docker-entrypoint-initdb.d
|
|
healthcheck:
|
|
test:
|
|
[
|
|
'CMD-SHELL',
|
|
'pg_isready -U ${POSTGRES_USER:-pulsescore} -d ${POSTGRES_DB:-pulsescore_dev}',
|
|
]
|
|
interval: 5s
|
|
timeout: 5s
|
|
retries: 5
|
|
|
|
volumes:
|
|
pgdata:
|