What guarantees SQLite provides for recovery after an interrupted schema upgrade?
Goal: ensure that a SQLite database can be returned to a consistent, usable state after a process crashes while a schema‑changing statement (e.g., ALTER TABLE, CREATE INDEX) is being committed. SQLite relies on its rollback journal or Write‑Ahead Log (WAL) to undo partial writes, and the PRAGMA integrity_check procedure can verify B‑tree and index consistenc
sqlite