Catalog section · FAIL

Storage durability

19 planned items in Reliability, Failsafes & Edge Pathways.

SQLite WAL mode with synchronous=FULL for money tables

FAIL-0001 Planned Lite and Pro Core

Durable commits

Depends on: PLAT-0001

Foreign keys and CHECK constraints enforced

FAIL-0002 Planned Lite and Pro Core

Referential integrity

Depends on: FAIL-0001

Single-writer queue

FAIL-0003 Planned Lite and Pro Core

Serialize writes to avoid SQLITE_BUSY

Depends on: FAIL-0001

Busy-timeout and retry policy

FAIL-0004 Planned Lite and Pro Core

Handle SQLITE_BUSY

Depends on: FAIL-0001

Periodic WAL checkpoint (PASSIVE/TRUNCATE at idle)

FAIL-0005 Planned Lite and Pro Core

Keep WAL small

Depends on: FAIL-0001

WAL file kept with DB on copy/move

FAIL-0006 Planned Lite and Pro Core

Never separate -wal/-shm

Depends on: FAIL-0001

Pin SQLite ≥3.51.3 (WAL-reset bug fix)

FAIL-0007 Planned Lite and Pro Core

Use patched SQLite

Depends on: FAIL-0001

Single-process DB access rule

FAIL-0008 Planned Lite and Pro Core

Avoid multi-process writers where possible

Depends on: FAIL-0001

Integrity check at startup (quick_check)

FAIL-0009 Planned Lite and Pro Core

Detect corruption early

Depends on: FAIL-0001

Periodic full integrity_check

FAIL-0010 Planned Lite and Pro Standard

Scheduled

Depends on: FAIL-0001

Automatic DB snapshot before risky ops

FAIL-0011 Planned Lite and Pro Core

Migrations, imports, restore

Depends on: FAIL-0001

Dual-write journal (event log file)

FAIL-0012 Planned Lite and Pro Standard

Secondary append-only transaction journal

Depends on: FAIL-0001

Journal replay recovery

FAIL-0013 Planned Lite and Pro Standard

Rebuild DB from journal

Depends on: FAIL-0001

Checksum on attachments

FAIL-0014 Planned Lite and Pro Standard

Detect bit-rot

Depends on: FAIL-0001

Disk-space monitoring

FAIL-0015 Planned Lite and Pro Core

Warn before full disk

Depends on: FAIL-0001

Disk-full graceful handling

FAIL-0016 Planned Lite and Pro Core

Block new sales safely, never corrupt

Depends on: FAIL-0001

Low-battery safe mode

FAIL-0017 Planned Lite and Pro Core

Flush and warn

Depends on: FAIL-0001

Filesystem error handling

FAIL-0018 Planned Lite and Pro Core

Retry/alternate path

Depends on: FAIL-0001

Storage on SD card warnings (Android)

FAIL-0019 Planned Lite and Pro Standard

Prefer internal storage

Depends on: FAIL-0001