PROJECT 02 / MOBILE DEVELOPMENT / DATABASE DESIGNSenior project
Vent.
A social experience, meaningfully mapped.
Vent connects social interaction with location. User posts appear on a map, communities bring people together, and messaging connects users in realtime.
MY ROLE
Android lead · Database design
COLLABORATION
Three-developer senior project
TECHNOLOGIES
React NativeExpoSupabasePostgreSQLJavaScript
01 / EXPLORE THE PROJECTINTERACTIVE WALKTHROUGH
See how it connects.
vent / A MAP THAT GROWS WITH YOU01 / 04
OUTDOORS / C1
LOCAL FINDS / C2
P1 / U1
Morning on the trailPosted nearby
P2 / U2
A little fresh airPosted nearby
P3 / U3
Found a new favoritePosted nearby
P4 / U1
A corner full of colorPosted nearby
FICTIONAL NEIGHBORHOOD0 visible posts
YOUR MAP Watch the demo · or try it
Post cards and stored records arrive together
POSTGRESQL / SIMPLIFIED DATA VIEW0 pins stored
▤users
id · name
U1 · Alex
U2 · Sam
U3 · River
▤pins
id · author · content / location
P1 · U1 · Morning on the trailimage: trail · 40.72, -74.01
P2 · U2 · A little fresh airimage: mountains · 40.71, -74.02
P3 · U3 · Found a new favoriteimage: coffee · 40.73, -73.99
P4 · U1 · A corner full of colorimage: gallery · 40.71, -73.98
MAP RESULTNo matching postsAll 4 source records remain stored.
Fictional posts · Illustrative fields and community-associated layers. Message blips represent people communicating within their communities.
Illustrative app preview and simplified relationship diagram, based on the project’s features. Names, locations, and posts are fictional.
02 / MY CONTRIBUTION
Where I made an impact.
I led the Android version and primarily contributed the database schema and its implementation. Our three-person team collaborated on the shared application codebase.
03 / THE OUTCOME
What the work became.
A senior project spanning a shared mobile codebase and a relational backend. My central work connected the Android application to the data structures supporting the experience.