Collection version history¶

(draft)

Background: desired API features (see #13109, #13494)

• Get current + previous versions of a collection with a single API call
• Search all current + previous versions of collections with a single API call
• Stable small numeric "version number" for each version of a given collection

Implementation

• Store all versions in the collection table (much easier to do paging)
• New database column indicates current version's UUID
• New database column indicates user-friendly version number (starting at 1) -- can be assigned safely after locking "current" row for update
• Flag for "list" API to include old versions (otherwise, filter on current_version_uuid=uuid -- might need to adjust indexes to maintain performance)
• Flag in site configuration to enable preserving old versions in database