Evaluate django-simple-history for history tables

[fyliu]

Overview

We would like to know if django-simple-history can fulfill our needs of keeping history of certain tables. We can potentially save time and developer efforts.
The package automatically keeps track of change history metadata like who made the change.

Details/Requirements

• should be useful for Create Table: event_history #49
  • An event record has a long life with cancellations and overrides, and metadata about who made those changes should be useful
• not useful for Create Table: permission_history #37
  • needs to hold the old permission records that are no longer in effect
  • new permission records are created for each update, so there's no updating each record to keep track of
• should be useful for Create Table: project_status_history #67
  • needs the history of the status field for each project

Action Items

• install plugin into django and test the functionality
• evaluate whether it can fulfil our needs
• document usage if it's useful
• release the dependency on the following issues and if there are no other dependencies, move them from the icebox to the new issue approval column and add the ready for dev lead label.
  • Create Table: event_history #49
  • Create Table: permission_history #37 no longer applicable
  • Create Table: project_status_history #67

Resources/Instructions

• This issue was a part of Create Table: event_history #49
• django-simple-history

[fyliu]

I updated the Details section with information on whether I think the library can help what that table needs. It turns out that information was at the bottom of the issue description.

[fyliu]

I came across other potential solutions that I need to compare with this package. Setting this for dev-lead.

[shmonks]

@fyliu I'm just looking through the Ice Box - since this issue is the sole remaining dependency on #37, I wonder whether it's time to prioritize it?

• Create Table: permission_history #37