🔍 Implement Explore / Discovery Feature

[sensasi-delight]

Build an Explore page where users can discover trending and new posts.
The system should highlight popular content (based on likes/comments) and also allow users to browse by recent activity.

---

✅ Tasks

• Database / Logic

  • Query posts sorted by popularity (likes + comments).
  • Query posts sorted by most recent.
  • Implement pagination or infinite scroll for smooth navigation.

• UI/UX

  • Design Explore page layout with tabs: "Trending" and "Latest".
  • Add grid/list display for posts.
  • Add "Load More" / infinite scroll support.
  • Ensure consistent card design with feed posts.

• Fullstack Implementation

  • Create server actions for fetching trending and recent posts.
  • Integrate queries with Explore UI tabs.
  • Optimize queries to avoid N+1 issues with authors and comments.

• Testing & QA

  • Unit tests for queries (trending and latest).
  • Integration tests for Explore page rendering.
  • UI tests for tab switching and infinite scroll.

---

🏁 Acceptance Criteria

• Explore page exists with Trending and Latest tabs.
• Posts in Trending are sorted by popularity (likes + comments).
• Posts in Latest are sorted by most recent.
• Infinite scroll or "Load More" works smoothly.
• Explore UI matches the feed style for consistency.