Database Management

Manage system and project databases with interactive configuration and Docker integration.

start --db - Start Database Services

Start system or project databases with interactive configuration and Docker integration.

Usage:

apito start --db system    # Start system database
apito start --db project  # Start project database

Features:

• Interactive Database Selection: Choose from PostgreSQL, MySQL, MariaDB, MongoDB, Redis, SQL Server
• Credential Options: Use default credentials or enter custom configuration
• Smart Configuration: Automatic detection of existing database settings
• Overwrite Protection: Confirmation prompts before overwriting existing configuration
• Persistent Volumes: Named Docker volumes for data persistence
• Consistent Naming: Container names follow apito-{dbType}-{engine} pattern

Database Engines Supported:

• PostgreSQL (port 5432) - Professional-grade relational database
• MySQL (port 3306) - Popular open-source database
• MariaDB (port 3307) - MySQL fork with enhanced features
• MongoDB (port 27017) - Document-based NoSQL database
• Redis (port 6379) - In-memory key-value store
• SQL Server (port 1433) - Microsoft's enterprise database

Configuration Options:

• Default Credentials: Automatic setup with apito user, generated password, and apito database
• Custom Configuration: Full control over host, port, username, password, and database name
• Engine-Specific Fields: Special configuration options for databases like MongoDB

Examples:

# Start system database with interactive setup
apito start --db system

# Start project database with interactive setup
apito start --db project

# Start services without database (default behavior)
apito start

Volume Naming Convention:

• System Database: apito-system-{engine}_data (e.g., apito-system-postgres_data)
• Project Database: apito-project-{engine}_data (e.g., apito-project-mysql_data)

stop --db - Stop Database Services

Stop specific database services while keeping other services running.

Usage:

apito stop --db system    # Stop system database
apito stop --db project  # Stop project database

Examples:

# Stop only the system database
apito stop --db system

# Stop only the project database
apito stop --db project

# Stop all services (default behavior)
apito stop

restart --db - Restart Database Services

Restart specific database services while keeping other services running.

Usage:

apito restart --db system    # Restart system database
apito restart --db project  # Restart project database

Examples:

# Restart only the system database
apito restart --db system

# Restart only the project database
apito restart --db project

# Restart all services (default behavior)
apito restart