sqlite

What problem does it solve?

This collection provides comprehensive guidance for effective SQLite usage, covering core pragmas, schema design, JSON/FTS features, indexing strategies, upserts, and migration patterns to reduce boilerplate and risk.

Core Features & Use Cases

• WAL configuration and PRAGMA best practices for concurrent reads and safe writes.
• Schema design patterns (STRICT tables, WITHOUT ROWID, generated columns, and CHECK constraints) with concrete examples.
• JSON1/FTS5 usage, external content tables, and advanced query techniques (RETURNING, EXPLAIN, window functions, upsert).
• Performance optimization through covering indexes, partial and expression indexes, and ANALYZE workflows.
• Migration and deployment patterns for Python and JavaScript environments, including D1-like patterns in edge contexts.

Quick Start

Install or import the patterns into your project, apply the recommended PRAGMAs, configure WAL, and adopt the showcased indexing and migration strategies for immediate improvements.