sqlite

What problem does it solve?

This Skill provides guidance on designing, optimizing, and using SQLite effectively in embedded environments, addressing common pitfalls and best practices for performance, reliability, and data integrity.

Core Features & Use Cases

• Type Affinity and Constraints: How to model data with SQLite's dynamic typing and the STRICT tables feature (3.37+).
• Performance Tuning: WAL mode, PRAGMAs, indexing strategies for read/write workloads.
• Real-world Scenarios: Mobile apps storing local data, edge devices needing small-footprint DB, offline-first apps.

Quick Start

Start by enabling WAL, define FK constraints, and evaluate query plans for critical paths. Then test with realistic datasets and adjust PRAGMAs accordingly.