SQLite database expert for Tauri/desktop apps with SQL injection prevention, migrations, FTS search, and secure data handling.

• 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 indexing for efficient text queries
• Provides TDD-first testing patterns using in-memory SQLite, migration versioning with rollback capability, and performance optimization through indexing and VACUUM scheduling
• Includes Rust/Tauri integration examples using rusqlite and sea-query, plus common mistakes and pre-implementation checklists for schema design and security review