Skip to content

Move Audit Log to JSON formatted log file

Summary

Move the audit log from our main SQLite database to a logfile consisting of entries. Currently the amount we write to the audit log can cause issues with database concurrency as we write to it for pretty much every action in Crafty.

Area of the system

  • Audit log page
  • Database
  • Backend controllers

How does this currently work?

We have two methods "add to audit log" and "add to audit log raw". We write to this database table every time an action is performed in the software.

What is the desired way of working?

We should write to a logfile instead as this makes it easier to access and it will allow us to make fewer writes to the database.

*Marking as high priority as this is currently blocking schedule usage in edge-case scenarios.

Priority/Severity

  • High (This will bring a huge increase in performance/productivity/usability)
  • Medium (This will bring a good increase in performance/productivity/usability)
  • Low (anything else e.g., trivial, minor improvements)