07 · Tables A→ZI · Version, time-travel & recover
Time-travel: read an earlier state
Inspect what a table looked like at an earlier version - without destroying anything.
"Time-travel" means looking at an earlier state of the table. The key point: inspecting the past is non-destructive - it's rollback and restore that change the table. Reach for those only when you actually want to move the table back.
Inspect a past state safely
- List versions -
get_table_history(CLI:eddytor get history) shows each version, its timestamp, operation, user, and metrics. - See what changed -
diff_table_versionsbetween the old version and now shows the exact row-level differences (INSERT/UPDATE/DELETE, with before/after values). - In the Web UI, open the table's History tab and select a version to view its details.
This tells you what the data was without touching the current table.
Actually going back
If you need the table itself returned to that state, that's a destructive operation:
- Know the version number →
rollback_table. - Know the approximate time →
restore_table.
Both discard the versions after the target - see Rollback vs restore.
Heads up
Vacuum limits how far back you can go.
vacuum deletes data files older than the retention
window (default 168h / 7 days), so time-travel - and rollback/restore - to a
pruned version fails: the entry is still in the history list, but its files
are gone.