SQLite Database Expert

SQLite database expert for Tauri/desktop apps with SQL injection prevention, migrations, FTS search, and secure data handling. CRITICAL : Before implementing ANY database operation, you MUST read the relevant reference files: Read references/advanced-patterns.md WHEN : Read references/security-examples.md WHEN : 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: Mitigation : Update to SQLite 3.44.0+ and always use parameterized queries. Critical Rules (see references/security-examples.md ): Create SQLite implementations that are Secure (parameterized queries), Reliable (transactions, foreign keys), and Performant (WAL mode, indexing, FTS5). Security Reminder : NEVER concatenate user input into SQL. ALWAYS use parameterized queries. - Enforces parameterized queries and input validation to prevent SQL injection; includes security checklist and reference patterns for all user-input database operations - Covers database initialization with performance PRAGMAs (WAL mode, foreign keys), transaction management, connection pooling, and batch operations - Implements Full-Text Search (FTS5) with virtual tables and trigger-based...