Campus Catdex
Giving every campus cat at Adamson a name, a photo and a guardian.
- Year
- 2026
- Type
- App
- From
- Personal
Context
Adamson has a lot of campus cats, and nobody had one place to keep track of them. So I built Campus Catdex. Any student can log where they saw a cat, add a photo and build that cat's profile with everyone else, no account needed.
My contribution
- Moved every write into Postgres functions that check input and cap posting at 30 sightings an hour per phone and 200 per network, since the whole campus shares one Wi-Fi address.
- Built shareable guardian cards with a rank and an invite link, so sharing the app is part of using it.
- Tested every database migration and API route against an in-memory Postgres before each deploy.
Engineering
- Vanilla JS
- Vercel Functions
- Neon Postgres
- Vercel Blob
Challenges
Someone uploaded a meme instead of a cat. I didn't want to slow everyone down with full moderation, so a phone's first photo now waits for my approval. After that, its photos post right away.
Outcome
Launched to the Adamson community on October 28, 2026. It runs entirely on free tiers.