flutter-working-with-databases

SKILL.md

SQLite and offline-first data layer architecture for Flutter apps with structured local persistence.

Separates data layer into stateless Services (raw data wrappers) and business-logic Repositories (single source of truth per domain entity)

Implements offline-first synchronization: reads yield cached local data immediately then fetch remote updates; writes save locally first, then attempt API sync with background queue fallback

Covers SQLite setup with safe parameterized queries, Domain Model transformation, and caching strategies for key-value, large datasets, and images

Includes complete code examples for Repository streams, Database Service implementation, and step-by-step workflows for adding new data features

Architecting the Data Layer

Contents

Core Architecture

Services Implementation

Repository Implementation

Caching Strategies

Workflows

Examples

Core Architecture

Construct the data layer as the Single Source of Truth (SSOT) for all application data. In an MVVM architecture, the data layer represents the Model. Never update application data outside of this layer.

Separate the data layer into two distinct components: Repositories and Services.