Note: This template is freely reusable with attribution to Jenny Ouyang at buildtolaunch.ai

Project Overview

Product: [Your Name]'s Personal Website ([your-domain.com])

Status: Phase 1 Complete (Basic website deployed)

Remaining Phases: Blog Retrieval → AI Chat → Stripe Booking

Phase 1: Professional portfolio website with:

• Homepage with hero, about, work, services sections
• Individual pages: About, Work, Blog (empty), Services, Contact
• Responsive design with dark/light mode
• Next.js 15 + TypeScript + TailwindCSS
• Basic Supabase setup

Phase 2: Blog Content Integration

Requirements

Goal: Automatically sync and display [Your Name]'s blog content

Technical Specs:

• RSS URL: [<https://your-blog-platform.com/feed>] (e.g., Substack, Medium, Ghost)
• Storage: Supabase table blog_posts
• Update frequency: Manual trigger initially, automatic later

Database Schema:

CREATE TABLE blog_posts (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  title TEXT NOT NULL,
  excerpt TEXT,
  published_date TIMESTAMPTZ NOT NULL,
  substack_url TEXT UNIQUE NOT NULL,
  image_url TEXT,
  read_time INTEGER,
  created_at TIMESTAMPTZ DEFAULT NOW()
);