sqlite

Name: sqlite
Availability: InStock
Author: zzoo

Solve embedded SQLite challenges with patterns for locking, schema evolution, and concurrency.

Updated Mar 18, 2025

Search Tags:#database #concurrency #json #sqlite #embedded #fts

Ready to run

npx skills add https://github.com/zzoohub/mealio --skill sqlite-zzoohub

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

SQLite problem-solving patterns tailored for embedded and edge deployments, helping developers address database locks, schema evolution, and platform-specific quirks without overhauling architecture.

Core Features & Use Cases

Connection setup patterns: ensure safe, concurrent access with WAL, foreign_keys, and sensible busy_timeouts.
Schema evolution workarounds: safe ALTER TABLE via table rebuilds and index preservation when evolving schemas.
Data typing and query optimization: use STRICT tables, JSON handling, and FTS5 for fast, reliable searches.
Backup and maintenance: practical backup strategies, vacuum usage, and auto-vacuum considerations for mobile/edge.

Quick Start

Describe your embedded SQLite issue (for example, "database is locked") and then apply the corresponding pattern from this guide.

Frequently Asked Questions about sqlite

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I fix a SQLite database is locked error in embedded deployments?▼

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.

What is the best way to alter a SQLite table schema when ALTER TABLE is limited?▼

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.

How does FTS5 work with SQLite for fast text searches?▼

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.

Can I use SQLite for JSON data handling and dynamic typing in edge applications?▼

Yes, SQLite supports JSON handling and addresses dynamic typing quirks through STRICT tables, ensuring reliable data storage and query optimization for edge deployments.

What are the limitations of using SQLite for high concurrency applications?▼

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.

Do I need auto-vacuum for SQLite backup and maintenance on mobile devices?▼

SQLite auto-vacuum considerations are crucial for mobile and edge maintenance, providing practical backup strategies alongside manual vacuum usage to manage storage fragmentation efficiently.