EddytorDocs & API
07 · Tables A→ZI · Version, time-travel & recover

Diff two versions

Compare two table versions row-by-row - like git diff for your data.

diff_table_versions compares two versions row-by-row - git diff for table data. Use it to see exactly what a write changed before deciding whether to roll back.

Diff

eddytor diff table eddytor sales orders --from 2 --to 4
diff_table_versions(table="eddytor.cfg_xxx.<uuid>_orders", from_version=2, to_version=4)

Returns, per changed row:

  • changeType - INSERT, DELETE, or UPDATE.
  • current / previous - the row values on each side.
  • changedColumns - for updates, which columns differ.

Requirements & behaviour

Heads up

Diff requires at least one primary-key column - it's how rows are matched across versions. It handles schema evolution by comparing only the columns present in both versions.

Find the version numbers first with get_table_history (CLI: eddytor get history).

The investigate-then-revert flow

  1. get_table_history → spot the suspicious version.
  2. diff_table_versions → confirm what actually changed.
  3. Decide: rollback_table to undo, or a targeted merge_rows fix.

Next

Read table history

List every version of a table - timestamps, operations, and who made each change.

Time-travel: read an earlier state

Inspect what a table looked like at an earlier version - without destroying anything.

On this page

DiffRequirements & behaviourThe investigate-then-revert flowNext