TraceTogether

Inspiration

TraceTogetherOnline was born out of a moment that highlighted a broader need for change. While walking home one evening, my wife's phone was stolen—a distressing experience that many can unfortunately relate to. What followed was a maze of steps: filing police reports, contacting mobile providers, and notifying various platforms. It quickly became clear how fragmented and overwhelming the process was, especially during an already stressful time.

This experience sparked a realization: what if there were a single, unified platform that could simplify this process—not just for us, but for anyone facing similar circumstances? We also learned that many stolen devices are rapidly moved across borders, making local efforts less effective. That insight inspired us to think globally.

TraceTogetherOnline was created to empower individuals and organizations with a centralized, accessible tool to report, track, and verify stolen items—helping reduce theft, support recovery, and bring peace of mind to people around the world.

What it does

TraceTogetherOnline is a comprehensive global platform designed to combat item theft and protect consumers. It serves as a centralized database for reporting and verifying stolen items across a wide array of categories, including:

Mobile devices
Vehicles
Computers
Cameras
Smartwatches
Tablets
Gaming consoles

Key Features:

Universal Item Search: Instantly verify an item's status using IMEI, VIN, or serial numbers.
Multi-Category Reporting: Dynamic forms tailored to each item type.
Personal Dashboard: Track and manage reported items.
Bulk Reporting for Organizations: CSV upload support for telecoms and law enforcement.
Admin Tools: Advanced search, bulk updates, and data export.
Subscription Plans: Tiered access with usage tracking.
Real-Time Notifications: Stay updated on report status changes.
Bulk Fetch for Organisations: Blacklist any reported Item in your system.

How we built it

This whole project including design,implementation, backend and deployment, all was created and managed on bolt. No other tooling was required to manage any aspect. TraceTogetherOnline is a modern web application built with:

Frontend: React 18 + TypeScript, Tailwind CSS, Lucide Icons, React Hook Form + Zod for dynamic form validation.
Backend: Supabase (PostgreSQL, Auth, Storage, Edge Functions).
Deployment: Netlify for CI/CD and hosting.

The dynamic reporting forms are powered by a item_categories table in Supabase, allowing flexible expansion of supported item types.

Challenges we ran into

Data Integrity: Ensuring that unique identifiers (like IMEI, VIN, serial numbers) are truly unique across the entire database, and preventing duplicate reports for the same item, was paramount. This required careful design of database constraints, unique indexes, and custom Supabase functions (validate_imei_uniqueness, check_imei_before_report) to enforce uniqueness and provide immediate feedback during reporting.
Authentication & Authorization: Implementing granular access control for different user roles (individual user, telecom provider, admin) using Supabase's Row Level Security (RLS) was intricate. Defining policies that allowed users to manage their own data, while enabling admins to oversee all data, and restricting bulk reporting to verified organizations, demanded meticulous configuration and testing.
Dynamic Forms: Creating a flexible reporting system where form fields and their validation rules adapt based on the selected item category was challenging. We overcame this by storing category-specific field definitions and validation rules in the database and dynamically rendering forms on the frontend using React Hook Form and Zod.
Cross-Border Data Handling: While the database is centralized, the concept of a "global" database implies potential future integrations with various national and international bodies, each with their own data standards and legal requirements. Designing the schema to be extensible for such future needs was a consideration.
Real-Time Notifications: Implementing a robust system to notify users about changes to their report status, especially when administrative actions are taken, required careful integration of database triggers and notification mechanisms.

Accomplishments that we're proud of

Unified Global Database Concept: Successfully laying the foundation for a single, comprehensive database that can track stolen items across various categories and potentially international borders. Robust RLS Implementation: Achieving a secure and finely-tuned RLS setup in Supabase, ensuring data privacy and proper access control for all user types.
Dynamic Reporting System: Developing a highly flexible and extensible system for reporting items, allowing for easy addition of new categories and customization of reporting forms without extensive code modifications.
Functional Bulk Reporting: Implementing a working bulk reporting feature for organizations, which is crucial for large-scale data submission and a significant step towards broader adoption.
User-Friendly Interface: Creating an intuitive and aesthetically pleasing user experience that simplifies the process of reporting and searching for items, even for non-technical users.

What we learned

Supabase Capabilities: We deepened our understanding of Supabase's powerful features, particularly its RLS, custom functions, and storage capabilities, and how they can be leveraged to build secure and scalable full-stack applications.
Advanced Form Management: We honed our skills in building complex, dynamic forms with React Hook Form and Zod, appreciating their efficiency in handling validation and state management.
Importance of Data Modeling: The project underscored the critical importance of a well-designed database schema for managing diverse data types and ensuring data integrity in a multi-faceted application.
Security Best Practices: We reinforced our knowledge of security principles, especially in the context of user authentication, authorization, and data protection in a public-facing application.
Project Management: The iterative process of identifying challenges, designing solutions, and implementing them provided practical experience in managing a complex development project