← all work

College · 2023

Flywise

My final college project: making flight booking feel less like filing taxes.

Next.jsTypeScriptPostgreSQL

The problem

Flight booking sites all seem designed by someone who has never been stressed at 11:52 PM trying to catch a 6 AM flight. Twelve tabs, five price differences, and a checkout flow that treats you like a suspect.

For my final college project I decided to build the version I actually wanted to use. The catch: it had to be defensible in front of two lecturers and a stopwatch.

What I built

What went wrong (and got fixed)

The fare logic and I had disagreements. Turns out "price changes while the user hesitates" is a feature airlines need, not a bug I can ignore. I learned to model it properly instead of praying users click fast.

What I'd tell past me

Ship the boring database design first. Every hour spent on indexes early paid for itself the night before the demo.