Improved Audit Trail
Since the Audit Trail system has been improved to store data in JSON format, I would like to know why data updates still store the same data. Would it be better if it were stored in JSON format as well?
That might be more consistent with Insert/Delete operations, but you’ll lose the key information — what was actually inserted, updated, or deleted. If those are also saved as JSON, you’ll need to compare the old and new JSON values to determine what has changed.
JSON data structures can be easily converted to a single row for comparison. However, if the data is new or old, a complex system must be developed to convert the old data into the new JSON format for further use.
This is because audit trails are typically used to examine the data in detail.
In my personal opinion, the data should be in the same format, there should not be any mix of formats. There may be options to configure the type of data recorded.