sqlite-local-storage

You can implement local SQLite storage with full-text search in an Electron app using better-sqlite3 and FTS5. This Skill provides a robust schema with indexed metadata, enabling fast keyword retrieval and transactional integrity for offline-first file management.

Yes, better-sqlite3 supports vector search when integrated with sqlite-vec. This Skill leverages sqlite-vec to enable semantic retrieval alongside FTS5 full-text search, allowing you to perform accurate similarity searches on local file metadata.

The best way to handle SQLite schema migrations in a desktop application is using a system with built-in schema evolution and transactional integrity. This Skill provides reliable schema initialization and migration support for long-term iterative development.

WAL mode improves SQLite concurrency by enabling simultaneous concurrent read and write operations. This Skill uses WAL mode to promote high-throughput local database operations, ensuring data integrity during batch indexing and background synchronization.

Yes, you can use SQLite for offline-first data management in Electron. This Skill provides a local storage system designed specifically for desktop apps to manage file metadata, comments, tasks, and AI history with reliable transactional integrity.

You can manage file metadata and AI chat history locally using SQLite through structured tables and indexed schemas. This Skill stores paths and modification times in a files table while persisting logs and conversation history for reliable offline access.