skills.rest
WilliansHerrera
WilliansHerreraCOMMUNITY
Explore all skills by this author →
GitHub

offline-first-sync

Queues and reconciles SQLite changes with a Laravel API when connectivity returns.

Updated Aug 23, 2026
Search Tags:#offline#sqlite#sync#mysql#conflict-resolution#offline-first#pos
One-click install
npx skills add https://github.com/WilliansHerrera/inventario-w --skill offline-first-sync
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: offline-first-sync
Source: https://github.com/WilliansHerrera/inventario-w/tree/main/.agent/skills/offline-first-sync
Command: npx skills add https://github.com/WilliansHerrera/inventario-w --skill offline-first-sync

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Esta skill ofrece un marco de estrategias para la sincronización entre SQLite (Local) y MySQL (Laravel API), gestionando colas de envío y actualizaciones de inventario en modo offline.

Core Features & Use Cases

  • Sincronización offline-first entre base de datos local y servidor, con cola de ventas pendientes y delta sync para minimizar datos transferidos.
  • Resolución de conflictos y conciliación de inventario para garantizar que el servidor (MySQL) sea la fuente de verdad en eventos de discrepancias.
  • Detección de conectividad y envío en lotes cuando la conexión retorna, manteniendo la coherencia entre dispositivos POS y backend.

Quick Start

Ejecuta la capa de sincronización offline-first para mantener SQLite y MySQL sincronizadas cuando la conectividad regrese.

Frequently Asked Questions about offline-first-sync

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How does offline-first sync handle conflicts between local SQLite and a MySQL server?▼

Offline-first sync handles conflicts by designating the MySQL server as the source of truth, resolving local discrepancies during inventory reconciliation when connectivity is restored.

What is the best way to queue POS sales data when internet connectivity is intermittent?▼

Queuing POS sales data requires lightweight frontend middleware that detects connectivity loss, batches pending operations locally, and syncs them to the Laravel API upon reconnection.

How do I minimize data transfer during SQLite and MySQL synchronization?▼

To minimize data transfer during SQLite and MySQL synchronization, implement delta synchronization, which transmits only the modified records rather than the entire local database.

Can I use this offline-first sync framework for inventory updates across multiple POS devices?▼

Yes, this offline-first sync framework handles product, sales, and inventory updates across multiple POS devices by batching pending operations and maintaining coherence between local and server databases.

Do I need a Laravel API to reconcile offline inventory changes?▼

Yes, a Laravel API is required to act as the central backend server that receives batched data, processes inventory reconciliation, and resolves data conflicts from offline POS devices.

Related Skills

Explore More Software Engineering Skills→
Cap-goCap-go
58

capacitor-offline-first

Implement offline-first data synchronization for Capacitor apps with SQLite.

Official
Advanced
usecompaiusecompai
24

shopify-inventory-sync

Synchronize inventory data across Shopify, POS systems, and 3PL providers.

Official
Intermediate
toilahuonggtoilahuongg
10

shopify-pos

Develop custom Shopify POS UI extensions using React and POS APIs.

Community
Advanced
OpenDCAIOpenDCAI
114

implementing-realtime-sync

Implement real-time communication using SSE, WebSocket, WebRTC, and CRDTs.

Official
Advanced