Implement Comments System with Threading

[Christiantyemele]

Description

Build a complete comments system that allows users to add, edit, delete, and reply to comments on tasks and projects with threaded conversations.

Tasks

• Create comments API routes (/api/comments)
• Implement comment creation form on task detail page
• Implement comment creation form on project detail page
• Add comment editing functionality
• Add comment deletion with confirmation
• Implement threaded replies (nested comments)
• Add comment author avatars and timestamps
• Implement real-time comment updates using Supabase Realtime
• Add comment count badges on tasks/projects

Database Schema

The comments table already exists with:

• Self-referential parent_comment_id for threading
• task_id and project_id for association
• author_id for ownership

Acceptance Criteria

• Users can add comments to tasks and projects
• Users can reply to comments creating threaded conversations
• Users can edit and delete their own comments
• Comments appear in real-time without page refresh
• Comment count is displayed on parent entities