01.10.RDB Features

01.10. RDB Features

This document outlines the core features and functionalities of the bnc-cpt-rdb (Relational Database) project.

Database Management & Operations

CloudSQL Administration: Automated tools for listing and managing GCP CloudSQL instances across environments.
Data Ingestion: High-speed import of SQL or binary database dumps from Google Cloud Storage (GCS) to CloudSQL.
Remote Connectivity: Automated setup of secure SSH tunnels for remote database access, including pre-configured connections for PHP Adminer.

Data Synchronization & Backups

GCS Synchronization: Robust utilities for syncing data between the local filesystem and GCS buckets.
Cross-Region/Bucket Sync: Tools for replicating data between different GCS source and target buckets.
Automated Cleanup: Policy-based removal of aged GCS files to manage backup storage costs.

Infrastructure Automation

Project Orchestration: Creation and deletion of GCP projects specifically tailored for database workloads.
Resource Provisioning: Management of Secret Manager secrets, GCS buckets, and DNS record exports.
Serverless Integration: Deployment of Cloud Functions and execution of Cloud Build triggers related to database tasks.

Project & Git Replication

Codebase Replication: Sophisticated tools for replicating full projects, specific directories, or individual files from a source to a target.
Git State Sync: Automated replication of git changes across related repositories.
Bulk Repository Management: Unified commands to pull or push all application-related repositories.

Credential & Workflow Management

Secure Secret Access: Integration with KeePassXC (.kdbx) for secure retrieval of database credentials and other secrets.
CI/CD Integration: Direct triggering of GitHub Actions workflows from the command line.
Secret Manager to Env: Exporting GCP Secret Manager secrets directly into .env files for application use.