SQLite Database Expert

Prevent SQL injection in SQLite by enforcing parameterized queries and input validation. This Skill provides ready-to-use Rust patterns that whitelist dynamic query elements, ensuring secure user input handling for Tauri applications.

Implement rollback-capable schema migrations for SQLite by applying versioned migration systems. This approach safely evolves database schemas without data loss, allowing you to revert changes if issues arise during desktop application updates.

The best way to add full-text search to a local SQLite database in Rust is by implementing FTS5 indexing. This Skill optimizes search performance across locally stored user data, enabling fast queries in desktop applications.

You can optimize SQLite performance by configuring WAL mode and connection pooling. This Skill implements these specific optimizations alongside indexing strategies to resolve performance bottlenecks and ensure efficient data access.

Safely handle locally stored user information in a Tauri application by integrating secure query implementation and parameterized queries. This Skill eliminates vulnerabilities and manages local data persistence securely.

This SQLite Expert Skill works directly with rusqlite and sea-query, providing ready-to-use integration patterns. It supports Tauri command implementation for Rust desktop apps requiring local data persistence.