Case Study • Software Architecture • Single Source of Truth

Retail ERP Re-Platform

Enterprise • Private Repository

Executive Summary

Key Metrics

97
PostgreSQL Tables
~131K
Lines of Code
36
Vue Views
~77×
Read Path Speedup

System Architecture

Single-source-of-truth flow: files ingest into PostgreSQL, builders read the DB, results fan out to snapshots and a build-less Vue frontend.

PostgreSQL 16 FastAPI Vue 3 Docker
NAS Files PKL · CSV Ingest Pipeline cron · format guard PostgreSQL 16 Single Source of Truth 97 tables · 5 layers Builders db_master_loader Snapshots time-series Vue 3 36 views Raw → Cleansed → Marts → Snapshot → Outputs

Scope & Ownership

Codebase

Database

Surface Area

Data Platform Principles

Single Source of Truth

Snapshot Time-Series

Build-less Frontend

Performance Engineering

Host OOM Root-Cause & Isolation

Serialization Codec Swap

Service-Level Cache (~77×)

Ingest Pipeline & Guardrails

Frontend Standard (dev-blueprint)

Technology Stack

Frontend
Vue 3 (CDN) Chart.js ES Modules
Backend
FastAPI Python SQLAlchemy orjson
Data
PostgreSQL 16 Snapshot Tables Partition / Index
Pipeline & Ops
Docker Compose cron NAS Sync

Impact

Reliability

Performance

Scale

Architecture