SQLite Database Expert - Secure SQLite development for desktop applications
Develops secure SQLite data storage for desktop applications, including parameterized queries, migrations, FTS5 search, and performance optimization.
Tags
Updated: 2026-09-29Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Use parameterized SQL queries
- Validate database inputs
- Manage schema migrations
- Implement FTS5 search
- Optimize database performance
- Manage transactions safely
- Integrate Rust with SQLite
- Write database tests first
Inputs
- SQLite database
- Database operation requirements
- Reference files
- Schema definitions
- User input data
Outputs
- Database schema changes
- Stored data changes
- Search results
- Migration status
- Database error messages
- Test results
Requirements
- Rust environment
- SQLite 3.35 or later
- rusqlite dependency
- sea-query dependency
- Optional connection-pooling dependencies