SQLite Database Expert

Implement secure SQLite data handling by using parameterized queries with rusqlite to prevent SQL injection. This Skill provides expert guidance on adhering to OWASP security standards to ensure database integrity in Rust desktop applications.

Manage SQLite database migrations robustly by implementing reliable schema version control and rollback capabilities. This Skill guides you through using sea-query to ensure safe schema changes and reliable migrations in Tauri desktop applications.

Implement full-text search with FTS5 in SQLite by integrating the FTS5 extension via rusqlite for powerful text searching. This Skill provides expert guidance on setting up and querying FTS5 tables to enable efficient search capabilities within your database.

Yes, r2d2 connection pooling improves SQLite performance by efficiently managing concurrent database connections. This Skill guides you through using r2d2_sqlite alongside WAL mode and indexing to optimize operations and prevent bottlenecks in desktop applications.

Yes, you can use sea-query with rusqlite to construct advanced query patterns including Common Table Expressions (CTEs) and window functions. This Skill demonstrates integrating sea-query-rusqlite to safely build and execute complex SQL queries in Rust.

Set PRAGMAs like WAL mode for concurrent performance and secure settings for data integrity when initializing an SQLite connection. This Skill guides you through configuring the necessary PRAGMAs for optimal security and performance in Rust desktop applications.