Unexpected persistence of PRAGMA journal_mode after transaction rollback in expo-sqlite
When using expo‑sqlite to run schema migrations inside a transaction, developers rely on the BEGIN … COMMIT/ROLLBACK wrapper to revert CREATE, ALTER, or DROP statements on error. However, certain SQLite pragmas such as PRAGMA journal_mode=WAL are not undone by a ROLLBACK, which can leave the database in a state that differs from the pre‑migration configurati
sqlite
expo
redis