skills.rest
abdoulayesow
abdoulayesowCOMMUNITY
Explore all skills by this author →
GitHub

seri-offline

Integrates a local database with a cloud backend for seamless offline/online sync.

Updated Aug 27, 2026
Search Tags:#serverless#synchronization#offline#Neon#PWA#Dexie.js#Prisma-Neon
One-click install
npx skills add https://github.com/abdoulayesow/pharmacy-guinea-app-002-2026 --skill seri-offline
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: seri-offline
Source: https://github.com/abdoulayesow/pharmacy-guinea-app-002-2026/tree/main/.claude/skills/seri-offline
Command: npx skills add https://github.com/abdoulayesow/pharmacy-guinea-app-002-2026 --skill seri-offline

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires dexie, @neondatabase/serverless, @prisma/adapter-neon, @prisma/client, ws, and includes scripts (resource) components.

What problem does it solve?

The Seri app is hampered by unreliable offline functionality and fragmented data sync across local and cloud stores. This Skill provides an offline-first architecture and a robust sync mechanism to keep stock, sales, and expenses consistent when connectivity is intermittent.

Core Features & Use Cases

  • Offline storage: Local IndexedDB via Dexie.js to operate 100% offline.
  • Background synchronization: Automatic queue processing when online to push local changes to Neon.
  • Cloud persistence: Neon PostgreSQL as the central data store with Prisma Neon adapter.
  • Use Case: A pharmacist records a sale during a power outage; once online, the sale is synced to Neon and stock is updated.

Quick Start

Launch the Seri app in offline mode and perform a sample sale; then bring the device online and observe the sync process.

Frequently Asked Questions about seri-offline

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

FAQPage Schema
How do I implement offline-first data synchronization with IndexedDB and PostgreSQL?▼

Offline-first data synchronization uses Dexie.js for local IndexedDB storage and a Neon PostgreSQL serverless API for cloud persistence, queuing local changes in the browser to sync automatically when network connectivity returns.

Can I use Prisma with the Neon serverless adapter for background sync?▼

Yes, the Prisma Neon adapter connects Prisma Client directly to Neon PostgreSQL, enabling a Next.js API route to process queued local changes from the client and persist them to the cloud database.

How does Dexie.js handle background synchronization when connectivity is intermittent?▼

Dexie.js stores data locally in IndexedDB to maintain full offline operation, queuing database mutations until the device is online, at which point the sync mechanism pushes changes to the Neon PostgreSQL backend.

What is the best way to sync pharmacy sales records during a network outage?▼

Record sales directly to local IndexedDB using Dexie.js while offline, and a background synchronization process will automatically push those transactions to Neon PostgreSQL once the application regains network connectivity.

Do I need a Next.js API route to sync Dexie.js with Neon PostgreSQL?▼

Yes, a Next.js API route is required to bridge the client and cloud, receiving queued local changes from Dexie.js and applying them to Neon PostgreSQL using the Prisma Neon adapter.

Why does offline data sync fail without a serverless PostgreSQL connection?▼

Without a serverless PostgreSQL connection like Neon, the application lacks a centralized cloud endpoint to receive pushed data, causing local IndexedDB queues to build up indefinitely without cloud persistence.

Related Skills

Explore More Software Engineering Skills→
MacPhobosMacPhobos

Neon Serverless Postgres Skill

Create and manage Neon Serverless Postgres databases with connection strings and ORM integrations.

Community
Advanced
jamshujamshu
4

create-odoo-pwa

Generate offline-first Odoo-backed PWAs with SvelteKit, React, or Vue scaffolding.

Community
Advanced
diadia0000diadia0000

save

Persist game world and player data to IndexedDB using Dexie.

Community
Intermediate
ArieGoldkinArieGoldkin
10

streaming-api-patterns

Implement real-time streaming with SSE, WebSockets, and ReadableStream APIs.

Community
Basic