Optimize embedded SQLite schemas with WAL, indexing, and pragma tuning.
npx skills add https://github.com/simplerick0/com.ackhax.configs --skill sqlite
Please help me install this Agent Skill. Skill: sqlite Source: https://github.com/simplerick0/com.ackhax.configs/tree/main/skills/database/sqlite Command: npx skills add https://github.com/simplerick0/com.ackhax.configs --skill sqlite
This Skill provides guidance on designing, optimizing, and using SQLite effectively in embedded environments, addressing common pitfalls and best practices for performance, reliability, and data integrity.
Start by enabling WAL, define FK constraints, and evaluate query plans for critical paths. Then test with realistic datasets and adjust PRAGMAs accordingly.
High-intent search queries and answers about installing and using this skill.
SQLite pragma tuning optimizes read and write workloads by adjusting cache sizes, journal modes, and synchronous settings. Test pragmas like journal_mode and synchronous with realistic datasets to balance transactional integrity against throughput.
SQLite type affinity dynamically coerces stored values based on column declarations rather than enforcing rigid types. The STRICT tables feature introduced in 3.37+ overrides this behavior, ensuring columns only accept data matching their declared datatype.
FTS5 integration enables fast full-text search within embedded SQLite databases by creating specialized virtual tables. This approach suits local applications needing low footprint query capabilities across large text fields without external search servers.
Evaluating SQLite query plans involves running EXPLAIN commands to inspect index usage and scan patterns for critical data paths. Adjust indexing strategies based on these query plans to achieve fast queries in read and write workloads.
SQLite provides reliable transactional integrity for offline-first desktop applications through its ACID-compliant embedded database engine. Its small footprint and local storage model make it ideal for desktop environments needing consistent data operations without server dependencies.
dennisonbertramAutomate SQLite database management tasks for development and testing.
jrajasekeraOptimizes SQLite performance through WAL mode, PRAGMA configuration, indexing, and query tuning.
JNZader-VaultProvide embedded SQLite storage with sync queue patterns for offline-first applications.
Leonard-DataProvide a serverless relational database with SQL queries and ACID transactions.
