adding-sqlite-stores

What problem does it solve?

This Skill streamlines the process of creating and managing SQLite-backed data stores within the application, ensuring data persistence and efficient data access.

Core Features & Use Cases

• Store Class Pattern: Implements the store class pattern with static methods for creating instances, initializing, and managing data.
• Idempotent Migrations: Supports idempotent migrations for maintaining data integrity without duplication.
• JSON Serialization: Enables JSON serialization for storing complex data types and facilitating easy data exchange.
• Column Whitelisting: Enforces security by only allowing updates to pre-defined columns, mitigating SQL injection risks.
• Wiring into App Lifecycle: Provides clear guidance on how to integrate the created stores into the application's lifecycle.

Quick Start

Initialize a new SQLite store for the 'widgets' domain.