Production-ready, cloud-native application that automatically processes Georgian government budget data and provides interactive analytics through web interfaces. It demonstrates modern software engineering practices including infrastructure as code, CI/CD automation, and scalable cloud architecture.

Core Application Components

Money Flow Frontend

A responsive web dashboard built with Flask that provides interactive budget analysis tools for end users.

Technology: Flask, HTML/CSS/JavaScript, Chart.js
Deployment: Cloud Run (serverless)
Features: Interactive charts, filters, real-time data
Connections: Communicates with Backend API for data

Money Flow Backend

A robust FastAPI service that provides RESTful endpoints for budget data and analytics.

Technology: FastAPI, PostgreSQL, Cloud SQL
Deployment: Cloud Run (serverless)
Features: RESTful API, data validation, health monitoring
Connections: Serves Frontend, connects to Database & Cloud Storage

Money Flow Functions

Automated data processing pipeline that fetches, transforms, and stores budget data from government sources.

Technology: Python, datapackage-pipelines, Cloud Functions
Deployment: Cloud Functions (serverless)
Features: Automated data fetching, Georgian translation, CSV/JSON output
Connections: Downloads from geostat.ge, uploads to Cloud Storage
Framework: datapackage-pipelines - Modular data processing framework

Developer Experience

make start

↓

Docker Compose

↓

Fixtures

PostgreSQL

--
↓

API

moneyflow-back

--
--
↓

UI

moneyflow-front

--
↓
↓
↓

localhost:5000

Browser

localhost:8000

Browser

localhost:5000

Infrastructure Architecture

Staging Configuration

Production Configuration

↓

terraform apply

↓

Networking

VPC Network
Load Balancer
VPC Connector
Firewall Rules
SSL Certificate

Database

Cloud SQL Instance
PostgreSQL Database
Database User
Secure Password

Compute

Cloud Functions
Cloud Scheduler
Service Accounts
Pub/Sub Topics

Storage

Function Source Bucket
Folder Structure
Lifecycle Rules

Monitoring

Uptime Checks
Alert Policies
Monitoring Dashboard
Email Notifications

CI/CD

Cloud Build Triggers
Artifact Registry
Build Service Account
Auto-deployment

Security

Secret Manager
Database URL Secret
IAM Permissions
Access Control
graph TB %% Development & Deployment Flow GITHUB[Git Push] CLOUDBUILD[Cloud Build
Automated CI/CD] ARTIFACT[Artifact Registry] %% Core Infrastructure Services LOADBALANCER[Global Load Balancer
SSL, CDN, Routing] %% VPC Subgraph containing all internal services subgraph VPC ["VPC Network
(Private Subnet, Firewall)"] %% Application Services FRONTEND[Frontend Web App
Cloud Run] BACKEND[Backend API
Cloud Run] CLOUDFUNCTION[Cloud Functions
Data Processing Pipelines] %% Data & Storage CLOUDSTORAGE[Cloud Storage] CLOUDSQL[Cloud SQL] SECRETMANAGER[Secret Manager] %% Monitoring & Scheduling CLOUDSCHEDULER[Cloud Scheduler] MONITORING[Cloud Monitoring
Uptime, Alerts] end %% External Data Source EXTERNAL[Geostats.ge] %% Deployment Flow GITHUB --> CLOUDBUILD CLOUDBUILD --> ARTIFACT ARTIFACT --> FRONTEND ARTIFACT --> BACKEND CLOUDBUILD --> FRONTEND CLOUDBUILD --> BACKEND %% Load Balancer Routing FRONTEND <--> LOADBALANCER BACKEND <--> LOADBALANCER %% Service Communication FRONTEND <--> BACKEND BACKEND -->|VPC Connector| CLOUDSQL BACKEND <--> CLOUDSTORAGE BACKEND --> SECRETMANAGER %% Data Pipeline Flow CLOUDFUNCTION <--> EXTERNAL CLOUDFUNCTION --> CLOUDSTORAGE CLOUDSCHEDULER --> |Pub/Sub Trigger| CLOUDFUNCTION %% Monitoring & Observability MONITORING --> LOADBALANCER MONITORING --> FRONTEND MONITORING --> BACKEND %% Security & Access Control SECRETMANAGER --> BACKEND SECRETMANAGER --> CLOUDFUNCTION MONITORING --> EMAIL[Email Notifications] %% Styling classDef deployment fill:#e3f2fd,stroke:#1976d2,stroke-width:2px classDef infrastructure fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px classDef application fill:#e8f5e8,stroke:#388e3c,stroke-width:2px classDef data fill:#fff3e0,stroke:#f57c00,stroke-width:2px classDef monitoring fill:#fce4ec,stroke:#c2185b,stroke-width:2px classDef external fill:#f1f8e9,stroke:#689f38,stroke-width:2px class GITHUB,CLOUDBUILD,ARTIFACT deployment class LOADBALANCER infrastructure class FRONTEND,BACKEND,CLOUDFUNCTION application class CLOUDSTORAGE,CLOUDSQL,SECRETMANAGER data class CLOUDSCHEDULER,MONITORING monitoring class EXTERNAL external

Data Flow & Processing

Cloud Scheduler

Triggers the functions with pubsub topic

Cloud Function

Automated processing with datapackage-pipelines

Data Pipelines

Unpivot, Clean data, Translate, Add metadata, Export to JSON and CSV

Cloud Storage

Processed CSV and JSON files