CampusLove was my first serious tour of PostgreSQL from the application side. Beyond the matchmaking surface, the project is a study of how to design schemas you can query fast, index thoughtfully, and migrate safely over time.
What I practiced
- PostgreSQL schema design with referential integrity and indexes
- Parameterized SQL queries (no string concatenation, ever)
- Modular console commands split by feature
- Separation between persistence models and domain shape
It looks like a toy app on the outside, but it's where I internalized the habits I now rely on at work when designing production schemas.