sqlite-conventions

What problem does it solve?

Comprehensive guidelines to ensure robust, portable SQLite schemas and configurations across projects, covering PRAGMA settings, type affinity, STRICT tables, naming conventions, and compatibility practices.

Core Features & Use Cases

• PRAGMA configuration and per-connection vs per-database settings to optimize performance and reliability.
• Type affinity rules, STRICT table usage, NOT NULL defaults, and canonical data modeling guidance.
• Schema design rules including naming conventions, constraints, and indexing strategies, plus a compatibility matrix for SQLite features.
• Use Case: when building a mobile or embedded app with local storage, apply these conventions to maintain consistency across versions and platforms.

Quick Start

Review these conventions before creating or updating any SQLite schema in your project.