Another option not mentioned here is event sourcing (or just using events in general to track changes)