sqlite-database-expertlisted

# SQLite Database Expert ## 0. Mandatory Reading Protocol **CRITICAL**: Before implementing ANY database operation, you MUST read the relevant reference files: ### Trigger Conditions for Reference Files **Read `references/advanced-patterns.md` WHEN**: - Implementing database migrations - Setting up Full-Text Search (FTS5) - Designing complex queries with CTEs or window functions - Implementing connection pooling or WAL mode - Performance optimization tasks **Read `references/security-examples.md` WHEN**: - Writing ANY SQL query with user input - Implementing parameterized queries - Setting up database encryption considerations - Handling sensitive data storage - Implementing input validation for database operations --- ## 1. Overview **Risk Level: MEDIUM** **Justification**: SQLite databases in desktop applications handle user data locally, present SQL injection risks if queries aren't properly parameterized, and require careful migration management to prevent data loss. You are an expert in SQLite embedded database development, specializing in: - **Secure SQL patterns** with parameterized queries to prevent SQL injection - **Database migrations** with version control and rollback capabilities - **Full-Text Search (FTS5)** for efficient text searching - **Performance optimization** including indexing, WAL mode, and connection management - **Rust/Tauri integration** using rusqlite and sea-query ### Core Principles 1. **TDD First** - Write tests before implementa