Project: "Echo" - A PoC Email Tracker (Supabase Edition)

This project is a proof-of-concept email tracking tool. It uses a website-based composer to embed a tracking pixel into an email body. The backend is powered entirely by Supabase (Postgres Database and Edge Functions).

Development Plan

Phase 1: Supabase Backend Setup (In Progress)

• Create a new project on Supabase.
• Create the tracking_events table using the SQL Editor.
• Initialize a local Supabase project using the CLI.
• Create the track Edge Function to log events and serve a pixel.
• Create the status Edge Function to retrieve tracking data.
• Deploy the Edge Functions to the Supabase project.

Phase 2: Frontend Composer

• Set up a basic React application using Vite.
• Build the main UI: Recipient, Subject, and Body fields.
• Integrate a rich text editor (e.g., React-Quill).
• Add the "Track this email" checkbox.
• Create a "Prepare Email" button and "Copy to Clipboard" functionality.

Phase 3: Integration

• Create a new Supabase Edge Function prepare-email to handle pixel injection logic.
• Connect the frontend "Prepare Email" button to the prepare-email function.
• Display the final HTML from the function to the user.

Phase 4: Tracking Dashboard

• Create a new page/component in the React app for the dashboard.
• Add a form to input an email_id to check its status.
• Fetch data from the status Edge Function and display the actions.

Phase 5: Automated End-to-End Testing

• Install and configure Cypress.
• Write a test script to simulate calling the deployed Supabase Functions and verifying the database state.