07 · Tables A→ZI · Version, time-travel & recover
Roll back to a version number
Reset a table to an earlier Delta version. Destructive - discards everything after it.
rollback_table resets a table to an earlier version number. Use it when you
know the exact good version (from the history).
Heads up
Destructive: all versions after the target are
discarded. This is not a new commit layered on top - the forward history is
truncated. Always read the history and confirm
before running it.
Roll back
eddytor rollback table eddytor sales orders --version 41rollback_table(table="eddytor.cfg_xxx.<uuid>_orders", version=41)Open the table → History → select the target version → Roll back.
Find the target version first with eddytor get history (or
get_table_history).
Safe procedure
get_table_history→ identify the last good version number (mind thatOPTIMIZE/VACUUMare versions too).- Optionally
diff_table_versionsto confirm what you're undoing. - Confirm - there's no undo.
rollback_table(table, version=N).profile_table+validate_constraints→ confirm the restored state.
Heads up
You can't roll back past a version whose files
vacuum has pruned (default retention 168h / 7 days).
Rollback vs restore
Use rollback for a known version number; use restore for an approximate timestamp. Both discard later versions - see the comparison.