audit_utility icon indicating copy to clipboard operation
audit_utility copied to clipboard

Move to immutable/blockchain tables

Open faggion opened this issue 3 years ago • 1 comments

Hi, Connor

Thank you for this great tool.

Considering that the audit tables shouldn't be updated, I wonder if it would be a good improvement to change the tables to "immutable" (blockchain maybe?) with "don't drop until" / "don't delete until" options in the generator.

faggion avatar Nov 16 '21 19:11 faggion

Valid point, but two things

  1. its pretty selective because it limits the usage to 19.10 or greater
  2. that does introduce the potential of performance overheads because we don't know if people will use the audit facility for OLTP versus batch style operations.
    But I'll look at factoring it in as an option.

connormcd avatar Nov 17 '21 01:11 connormcd