Add comprehensive Podman configuration for local development: - docker-compose.yml: Main compose file with all services (PostgreSQL, RabbitMQ, API, Frontend) - docker-compose.dev.yml: Development-specific overrides with hot-reload - Dockerfile.api: Backend API service Dockerfile - Dockerfile.frontend: Frontend Next.js service Dockerfile - Updated Dockerfile: Podman-compatible production build with better layer caching - .env.example: Environment variable template - .dockerignore: Exclude unnecessary files from builds - Makefile: Convenient commands for common Podman operations - scripts/db/: Database initialization scripts directory - Updated README.md: Comprehensive Podman setup and usage documentation Features: - Rootless Podman support with SELinux compatibility - Development mode with volume mounts for hot-reload - Health checks for service dependencies - Proper build stage optimization - All services networked together
17 lines
543 B
SQL
17 lines
543 B
SQL
-- LightSaver Database Initialization Script
|
|
-- This script runs automatically when the PostgreSQL container starts for the first time
|
|
|
|
-- Create extensions if needed
|
|
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
|
|
|
|
-- Add your table definitions here
|
|
-- Example:
|
|
-- CREATE TABLE IF NOT EXISTS users (
|
|
-- id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
|
|
-- email VARCHAR(255) UNIQUE NOT NULL,
|
|
-- created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
-- updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
-- );
|
|
|
|
-- Add initial seed data here if needed
|