sqlite-single-writer

What problem does it solve?

SQLite allows only one writer at a time across processes. When multiple processes attempt to write concurrently, you get SQLITE_BUSY errors. This skill provides a cross-process locking pattern that serializes writes using a separate lock file, WAL mode, timeout handling, and crash-safe release.

Core Features & Use Cases

• Cross-process write serialization using a dedicated lock file (db.lock) to coordinate access.
• Write-Ahead Logging (WAL) mode enables concurrent reads while writes are serialized.
• Timed lock acquisition with exponential backoff and diagnostic timeout messages when contention occurs.
• Automatic lock release on process crash and crash-recovery hints for debugging.

Quick Start

Wrap all write operations with the provided WriteLocker to serialize access.