yudopr.dev
SYSTEMS & ARCHITECTURE

Projects & Case Studies

Bringing structure to complexity, craft to systems, and clarity to scale.

AyoDance Texture Tools screenshotFull Stack

AyoDance Texture Tools

In Development

ACV Archive Tooling & AI Texture Upscaling

Python tools to extract, edit, upscale and repack AyoDance DDS textures, with ONNX/DirectML processing and an experimental Direct3D 9 renderer shim. No game assets are included; game modifications are prohibited and these tools are not approved for the live service.

PythonONNXDirectMLDDSC++Direct3D 9
Gamer Sidekick screenshotFull Stack

Gamer Sidekick

Beta

AI Agent That Reads Your Game Window

A zero-dependency pi package that binds a game window and captures a frame on demand, so an RPG walkthrough can answer from the screen you are actually looking at instead of a phone photo and a wiki tab.

TypeScriptWin32PowerShellPiOpen Source
Open Lakehouse on GCP (StarRocks + Apache Iceberg) screenshotData Engineering

Open Lakehouse on GCP (StarRocks + Apache Iceberg)

Case Study

Production Open Lakehouse with Iceberg, Polaris & StarRocks

Architected a cloud data lakehouse on GCP separating storage, metadata, and compute using Apache Iceberg, Apache Polaris REST Catalog, StarRocks, Airbyte CDC, and Terraform.

StarRocksApache IcebergApache PolarisAirbyteGCPTerraform
Cuan screenshotFull Stack

Cuan

Live

Local-First Personal Finance Engine

A zero-knowledge, offline-first personal finance app. All your financial data lives in a browser-embedded PostgreSQL database — never on our servers unencrypted. Works on planes, underground, anywhere.

PGliteOPFSWASMXChaCha20GoReact
Scitia Exam screenshotFull Stack

Scitia Exam

Live

Digital SAT & IELTS Online Exam Platform

A high-performance online examination & LMS platform tailored for Digital SAT and IELTS standards with WebAssembly AI proctoring and real-time LaTeX formula rendering.

GoPostgreSQLReactTypeScriptViteWASM ProctoringDocker
PostgreSQL Data Warehouse & CDC Pipeline screenshotData Engineering

PostgreSQL Data Warehouse & CDC Pipeline

Case Study

Near Real-Time CDC & Micro-Batch Data Warehouse

Architected an efficient analytical Data Warehouse using PostgreSQL, Debezium, and Kafka for CDC. Isolated analytical workloads from MySQL OLTP with sub-5-minute latency and zero cloud bloat.

PostgreSQLDebeziumKafkaCDCpg_cronETL/SQL