pfw-sqlite-data

Persist Swift model data to SQLite with iCloud sync using SQLiteData.

16|2|Updated Mar 29, 2018
One-click install
npx skills add https://github.com/khoi/dotfiles --skill pfw-sqlite-data-khoi
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: pfw-sqlite-data
Source: https://github.com/khoi/dotfiles/tree/main/chezmoi/dot_pfw/skills/sqlite-data
Command: npx skills add https://github.com/khoi/dotfiles --skill pfw-sqlite-data-khoi

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Persist model data to SQLite with iCloud synchronization and sharing using the SQLiteData library.

Core Features & Use Cases

  • Persist data locally with SQLite via a safe schema, migrate schemas safely, and enable iCloud-backed synchronization and share records across devices.
  • Provide developer guidance for best practices, including structured queries, migrations, and iCloud metadata management.
  • Use cases include apps needing reliable offline storage with cloud sync and collaborative data sharing.

Quick Start

Configure your project to integrate SQLiteData, add the SQLiteData dependency, and import the library.

Frequently Asked Questions about pfw-sqlite-data

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

FAQPage Schema
How do I sync SQLite data with iCloud in a Swift app?

To sync SQLite data with iCloud, you can use the SQLiteData library to enable cloud-backed synchronization and share records across devices in your Swift app. It provides guidance on iCloud configuration and metadata management.

What's the best way to handle SQLite schema migrations safely in Swift?

Handling SQLite schema migrations safely involves using the SQLiteData library with GRDB and the @Table schema approach. This enforces safe SQL migrations during bootstrapping to prevent data corruption.

Can I share SQLite records across multiple devices using iCloud?

Yes, you can share SQLite records across multiple devices using iCloud synchronization. The SQLiteData library supports collaborative data sharing and cloud-backed sync for reliable offline storage.

Does the SQLiteData library work with GRDB for local data persistence?

Yes, the SQLiteData library works with GRDB to enforce safe SQL migrations and local data persistence. It uses the @Table schema approach and SQLiteData APIs for structured queries in Swift-based apps.

How do I test SQLite data persistence and iCloud sync in Swift?

Testing SQLite data persistence and iCloud sync involves using the SQLiteData library's structured query guidance and testing protocols. It enforces safe schema migrations through GRDB and the @Table schema approach.

What do I need to configure before adding SQLiteData to my Swift project?

Before adding SQLiteData to your Swift project, you need to configure your project to integrate the library, add the SQLiteData dependency, and import it to enable local persistence and iCloud sync.