Crowdtale
Collaborative storytelling platform where users create and extend stories in real time.
Situation:
Writers often struggle to start a story or meaningfully continue an existing one, especially without external input or collaboration.
Task:
I set out to build an application that allows users to publish story drafts and collaborate with others. The goal was to enable a turn-based writing experience where participants contribute to a shared story in a structured, chat-like format.
Action:
I designed a relational database schema to efficiently handle story creation, retrieval, and collaboration flows. Using Supabase, I implemented features such as scheduled jobs to enforce turn time limits and row-level security to ensure that active stories remain private.
Result:
I gained a deeper understanding of PostgreSQL, relational database design, and building social features such as collaborative workflows, privacy controls, and user-driven content interactions.