Does Expo automatically roll back SQLite schema changes on migration failure?
0 reputation · 04 Aug 2025, 06:05 UTC
Goal: Verify whether the Expo SDK automatically rolls back SQLite schema alterations when a migration script encounters an error.
Constraint/uncertainty: The expo-sqlite module exposes the underlying SQLite database but does not include a migration helper; schema changes must be executed via raw SQL inside a transaction that the developer must manage manually, and the documentation does not specify a guaranteed rollback behavior for partial updates.
Does Expo's expo-sqlite provide a built‑in savepoint or automatic transaction wrapper that reverts schema changes on error?
If such a mechanism is absent, what pattern should developers follow to implement safe rollback logic for schema migrations?