Sprint 3 — Social Post Service

[zerexei]

Sprint Dates: 2026-07-20 to 2026-07-24 (Monday to Friday only)

Goal: Post composing, S3 media management, and post scheduling.

Tasks & Sub-tasks

• Post Database & Models
  • Create posts table (content, status, user_id)
  • Create scheduled_posts table (status, scheduled_at, timezone)
  • Create database relations and indexes
• Media Pipeline
  • Configure S3 storage connection
  • Implement secure upload endpoint with file size/type validation
  • Handle image cleanup on draft deletion
• Composer & Validation
  • Enforce per-platform character limits and formatting rules
  • Implement post draft lifecycle endpoints (create, update, delete)
• Scheduling & History APIs
  • Implement future-date scheduler validation
  • Build post history index with pagination, search, and status filtering