[ML 0.7/LL.01] - API Design & Core Pagination

🎯 The objective

Define the architectural contract for data fetching and implement the foundational pagination logic for standard folders. This milestone sets the stage for how the app will handle local database queries combined with remote data fetching.

🎒 Resources

• Android Paging3 Documentation
• Store5
• #10409

🦮 Rules of the Road

🟢 In Scope

• Define the MessageListRemoteMediator API interface.
• Build cursor-based pagination logic for standard folders (non-unified).

🔴 Out of Scope

• Implementation of the Remote Mediator (just the API definition here).
• Pagination for Unified Folders (scheduled for LL.02).
• UI Integration.

🚧 Technical and/or Business Requirements

• API Definition:
  • Must support retrieving data from a single entry point.
  • Must support requesting newer data (push to refresh).
  • Ideally use Flow for data retrieval.
• Pagination Logic:
  • Use Cursor pagination based on sorting criteria (e.g., Date) + ID/Date as tiebreakers.