Solve embedded SQLite challenges with patterns for locking, schema evolution, and concurrency.
npx skills add https://github.com/zzoohub/mealio --skill sqlite-zzoohub
Please help me install this Agent Skill. Skill: sqlite Source: https://github.com/zzoohub/mealio/tree/main/.claude/skills/sqlite Command: npx skills add https://github.com/zzoohub/mealio --skill sqlite-zzoohub
SQLite problem-solving patterns tailored for embedded and edge deployments, helping developers address database locks, schema evolution, and platform-specific quirks without overhauling architecture.
Describe your embedded SQLite issue (for example, "database is locked") and then apply the corresponding pattern from this guide.
High-intent search queries and answers about installing and using this skill.
To resolve a SQLite database is locked error, apply connection patterns using WAL mode, configure busy_timeout, and implement robust retry strategies to handle concurrent access safely.
The best way to handle SQLite ALTER TABLE limitations is performing a safe table rebuild procedure that preserves indexes while migrating data to the new schema structure.
SQLite FTS5 enables fast full-text searches by creating virtual tables optimized for text queries, allowing efficient keyword lookups and dynamic data retrieval within embedded applications.
Yes, SQLite supports JSON handling and addresses dynamic typing quirks through STRICT tables, ensuring reliable data storage and query optimization for edge deployments.
SQLite concurrency limitations include potential write locking bottlenecks, mitigated by setting PRAGMA busy_timeout values and employing WAL mode to allow simultaneous read and write operations.
SQLite auto-vacuum considerations are crucial for mobile and edge maintenance, providing practical backup strategies alongside manual vacuum usage to manage storage fragmentation efficiently.
Probably-GroupDesign secure SQLite schemas and CRUD code with WAL mode and FTS5.
erikstmartinOptimize PostgreSQL schemas, queries, and operations for reliability and performance.
xtrm-devSearch and manage Obsidian vault notes using the vaultctl CLI.
erikstmartinDesign SQLite schemas, migrations, and performance tuning for embedded apps.
