InsightUBC
A full-stack dataset query engine and campus explorer built for CPSC 310. Upload course or room datasets, then query and visualise them on an interactive campus map.
200+
tests written
4
test methodologies
2
dataset types
CPSC 310
course
What it does
Upload. Query. Explore.
InsightUBC is a campus dataset engine with a web frontend — course data and room data, queryable and explorable from a single interface.
Dataset ingestion
Upload zip files containing UBC course section data or campus room data. The engine parses, validates, and persists every record — datasets survive crashes and server restarts.
Custom query language
Query datasets using a structured JSON-based language — filter by any field, compose conditions, and specify exactly which columns to return and how to order them.
Campus map explorer
Room datasets are visualised on an interactive campus map. Buildings are geolocated during ingestion, and rooms can be browsed, searched, and compared side-by-side.
In-engine persistence
No external database. All parsing, validation, execution, and disk-write logic is handled by the engine itself. Datasets are written to disk and reloaded on startup.
