// Personal project
I built a full-stack platform for cataloging, ranking, and tracking characters across different fictional universes, combining a tier-based power ranking system, an interactive timeline of major events, and organizations that group characters into factions.
The data model needed to stay consistent as it grew, so relational integrity was a priority from the start.
Fan-made character databases are usually flat spreadsheets or wikis with no real structure connecting characters, timelines, and factions, and no consistent way to compare power levels across different universes.
I modeled the data relationally in PostgreSQL via Prisma so everything stays linked, added optimistic UI updates so the app feels instant, and used Gemini to help auto-generate lore content instead of requiring everything to be written by hand.






