Basic Data Pipeline
End-to-end pipeline project that extracted raw Foundry VTT Pathfinder 2e data from GitHub, transformed it into SQLite, and exposed it through Flask.
Problem Solved
Raw source data from the Foundry VTT Pathfinder 2e implementation was difficult to query and use directly, so I wanted a cleaner structured format and simple interface for exploration.
Outcome
Built a foundational pipeline that extracted source data from GitHub, transformed it into a relational schema in SQLite, and connected it to a Flask-based web interface.
Technologies
This project is an early portfolio exercise in data pipeline design and lightweight application delivery that is still ongoing and currently in progress.
The concept of this project is to extract the Pathfinder 2e implementation raw data from the GitHub source code of the Foundry Virtual Table Top application, design database schema, and then use Python and SQLite to process it. For easy exploration, I created a web application by designing a Flask-based UI for the processed data.
This project gave me an opportunity to develop skills that go from the extraction phase all the way to storing and visualization stages.