offline-sync

Original：🇺🇸 English

Translated

Expert in data persistence, local-first architectures, and synchronization strategies for Capacitor/Android applications.

2installs

Added on2026-03-02

NPX Install

npx skill4agent add abelv22/project-foundation offline-sync

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

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.

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.

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.

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.

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).