Instead of storing the entire diff contents in a JSONB blob (and an array for moves), this PR introduces a new table to the database that stores individual diff/move items. Apart from easier querying and general management of the data, one notable improvement is the evaluation of CR traces, which can now search through the indexed number columns of the new table instead of linearly scanning through all previous diffs. The trace functionality itself has been mostly replaced from a pure Python implementation into a single recursive Postgres query.
Instead of storing the entire diff contents in a JSONB blob (and an array for moves), this PR introduces a new table to the database that stores individual diff/move items. Apart from easier querying and general management of the data, one notable improvement is the evaluation of CR traces, which can now search through the indexed number columns of the new table instead of linearly scanning through all previous diffs. The trace functionality itself has been mostly replaced from a pure Python implementation into a single recursive Postgres query.