Ralphy
A full-stack campaign and reward platform built for brands and creators to collaborate, with QR code receipts, Supabase Edge Functions, and custom analytics dashboards.
Tech Stack
About Ralphy
Ralphy is a creator reward system where brands launch campaigns and users upload receipts to enter giveaways. Built as a modern marketing alternative to influencer tracking, it features campaign management, and secure user authentication.
One challenge faced while building this platform was the database design. I chose to work with POSTGreSQL, via a Supabase hosted backend. Defining the relations between campaigns, receipts, and users was crucial to ensure that each receipt could be linked to the correct campaign and user. This involved creating a robust schema that could handle complex queries and relationships, while also ensuring data integrity and security.
The platform also includes a dynamic dashboard for campaign management, built with shadcn/ui components, allowing brands to filter and view campaigns easily. The admin view features signed URL generation for secure receipt previews, ensuring that sensitive data is protected while still accessible to authorized users.
Key Features
- •
Dynamic dashboard with campaign filtering and modals via shadcn/ui.
- •
Signed URL generation for secure receipt preview in admin view.
- •
Automatic linking of receipt entries to campaigns using creator codes.
- •
Pagination-ready API design and filtering via PostgreSQL views.
- •
Custom CORS headers and RLS policies for secure data access.
