Logging "search and CRUD operations" in Budibase for each created app

[nosc82]

Objective: Implement a logging mechanism to track search and CRUD (Create, Read, Update, Delete) operations performed on the created Budibase apps.

Description:

CRUD Operations Logging:

Create: Log each creation of a new record, including details such as the timestamp, user ID, and the data of the created record.

Read: Log each read operation, specifying the timestamp, user ID, and details of the record accessed.

Update: Log each update made to an existing record, capturing the timestamp, user ID, original data, and updated data.

Delete: Log each deletion of a record, noting the timestamp, user ID, and details of the deleted record.

Search Operations Logging:

Log every search query executed, including the timestamp, user ID, and the search parameters or keywords used.

Capture the results returned by the search query, recording the number of records found and any relevant details.

External Storage for Logs:

Provide an option to configure an external storage location for logs, such as a cloud storage service (e.g., AWS S3, Azure Blob Storage) or a remote database.

Ensure that the logging mechanism can send log entries to the specified external storage location in addition to or instead of the Budibase database.

[linear]

BUDI-8971 Logging "search and CRUD operations" in Budibase for each created app