Database

Our database layer is powered by Supabase, providing a robust, scalable Postgres database with real-time capabilities. The database schema was designed to model the core entities of our platform: users, videos, and gallery items. The users table stores basic profile information and is linked to generated videos through foreign keys. The videos table includes metadata like the prompt used for generation, video resolution, generation status (pending, processing, completed), and a link to the video file hosted on cloud storage.

The gallery table is used to display curated content that the admin team selects for public showcasing. This structure allows us to efficiently query and filter data, enabling features like personalized dashboards, activity history, and featured content sections. We use Supabase’s built-in row-level security policies to ensure that users can only access and modify their own data. Additionally, we leverage Supabase’s real-time subscriptions to provide immediate feedback when new videos are generated or existing content is updated, enhancing the interactive feel of the platform.