8+ Yrs Exp · 5y Data Engineer · 3y Project Manager · Fullstack & Math Tutor

Making sense of data, getting lost in game worlds, and capturing the moments in between.

I’m Yudho Prakoso (@yudopr). I architect data platforms to find clarity in chaos, immerse in virtual worlds for the stories they leave behind, and write about life whenever inspiration strikes.

Explore Systems & Code Watch Chronicles Read Field Notes

SYSTEMS & ARCHITECTURE

Featured Systems & Case Studies

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

All projects

Open Lakehouse on GCP (StarRocks + Apache Iceberg)

Case Study

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

Read Case Study

Cuan

Live

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

Learn about Cuan

Scitia Exam

In Development

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

Visit Scitia Edu

PostgreSQL Data Warehouse & CDC Pipeline

Case Study

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

Read Case Study

VISUAL CHRONICLES

Watch on YouTube & TikTok

Data engineering walkthroughs, deep dives into game worlds & lore, and candid life shorts.

YouTube

Persona vs Trails in the Sky - Story & Game Mechanics Breakdown

Aug 5, 2026Watch on YouTube

TikTok

SQL Challenge: Compressed Mean - Data Engineering Teardown

Jun 17, 2023Watch on TikTok

FIELD NOTES & ESSAYS

Data, Stories & Life Telemetry

Reflections on data systems, narrative game analyses, and honest moments from everyday life.

View all articles

Bypassing the Walled Gardens: How I Turn Any Social Media Stream into an RSS Feed

Why I ditched expensive APIs and manipulative algorithms. Here is how I generate clean, chronological RSS feeds from TikTok, Instagram, and X using RSS-Bridge and RSS.app—and how I power the video shelf on this site.

2026-08-14• 7 min read

Building an Open Lakehouse on GCP with StarRocks, Apache Iceberg, Polaris, and Airbyte

A deep dive into designing a production-oriented open data lakehouse on GCP using Apache Iceberg, Apache Polaris REST catalog, StarRocks, Airbyte, and Superset.

2026-08-13• 17 min read

Building Cuan: A Local-First Financial Engine

Why I rewrote my personal finance tracker from scratch to run entirely in the browser using WASM, PGlite, OPFS, and zero-knowledge encryption.

2026-08-12• 6 min read