sqlite-wal

What problem does it solve?

Prevents silent genealogy data loss when SQLite databases are copied or restored, by ensuring the database never ends up in WAL mode that depends on missing sidecar files.

Core Features & Use Cases

• Enforces DELETE journaling as a project rule: ensures the app and any related tooling sets PRAGMA journal_mode = DELETE instead of WAL.
• Guides safe review of journal_mode usage: tells maintainers what to check when reviewing any PRAGMA journal_mode code paths.
• Provides a WAL downgrade rescue procedure: explains how to detect WAL-tagged databases and how to recover them without losing authored data.

Quick Start

Verify whether a user database is WAL-tagged by inspecting its header bytes write_v/read_v, then run the provided walfix recovery script to downgrade it back to DELETE mode.