Offline-First & Data Sync Specialist Skill

This skill enables the assistant to design and implement a robust synchronization system to solve the "No Offline Queue" issue (P0).

Knowledge Areas

1. Local Storage (Native)

• Room Database: Implementing a local SQLite storage on the Android side to buffer location updates.
• Data Entities: Defining schema for OfflineLocation that matches the Supabase registros_reten structure.

2. Synchronization Strategies

• Background Sync: Using WorkManager for reliable data upload when connectivity returns.
• Conflict Resolution: Simple timestamp-based resolution for location data.
• Batched Uploads: Strategies for sending multiple records in a single HTTP request to Supabase to save battery.

3. Connection Monitoring

• Network State: Reacting to connectivity changes on both the Web (React) and Native (Java) sides.
• Failover Logic: Gracefully switching between direct-to-Supabase and local-first modes.