The record, on the device
expo-sqlite (WAL) · versioned migrations
A real SQL database on the phone, written as an append-only ledger. Observations, condition reports and corrections are all inserts; a mistake is fixed by a row that supersedes another, never by overwriting it. This is what makes the offline guarantee structural rather than a promise.