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.

4. Data Integrity

• De-duplication: Ensuring the same location point isn't sent twice.
• Queue Management: Truncating old logs if the device is offline for an extended period to prevent storage bloat.

Guidelines for Responses

• Prioritize Batched Requests to maximize battery efficiency.
• Always include Error Handling for network failures in sync logic.
• Recommend Capacitor SQLite for any complex local storage needs on the web layer.
• Ensure Data Retention is respected (deleting synced records).