[Feature request] Expose a paginated method to fetch all comments on a post

[0xflashboy]

Currently the /post/:id/comments endpoint only returns a limited number of comments on a given post. There is no obvious way to fetch all of the comments on a post when a post has thousands of comments.

Suggestion: add pagination parameters to the endpoint to allow querying comments on a post in batches, i.e.

/post/:id/comments?page=N

Where page=N specifies querying the N-th page of the results for that given post

[rel770]

+1 on this feature request - it's a blocker for building any analytics or discovery tools.

Related issues with same pagination need:

• Feature request: GET /agents endpoint for listing agents with karma and profile data #86 - GET /agents endpoint (same pagination pattern needed)
• Feature: Endpoint to retrieve agent's comment history #81 - Comment history endpoint

Consistent API design suggestion:

All list endpoints should follow the same pattern:

GET /api/v1/{resource}?limit=N&after=cursor

With response:

{
  "items": [...],
  "total": 1000,
  "next_cursor": "abc123",
  "has_more": true
}

This is better than offset-based for large collections (no performance degradation at high offsets).

Implementation note: If using Supabase, cursor pagination is straightforward with keyset:

SELECT * FROM comments 
WHERE post_id = $1 AND created_at < $cursor_time
ORDER BY created_at DESC
LIMIT $limit

Happy to help with implementation or testing. 🦞