Based on Servoy Developer’s User’s Guide, audit trail in Servoy is placed in a different database, log_server. Is it recommended to put all audit trail in a separate database?
Is it possible to use the existing server as the log_server? I don’t want to manage 2 databases just because of Audit Trail.
Erik,
The server that the audit trail is logged in is the one that has the ‘Log Server’ checkbox (see server editor) ticked.
You can either use a dedicated server for this or use an existing server.
Rob
rgansevles:
Erik,The server that the audit trail is logged in is the one that has the ‘Log Server’ checkbox (see server editor) ticked.
You can either use a dedicated server for this or use an existing server.Rob
Thanks, Rob!
Keep in mind that if you enable audit trail estensevily in your solution you can end up with millions of records in the log table, that’s why IMO it’s a good idea to log to a separate server.
It’s also a good idea to think about a strategy to periodically clean up the log table.
Hi!
My tables’ pks use text/uuid generator as type and sequence type respectively. I would like to change the log tables log_id be text/uuid generator as well so all table pks are uniformed. Would the log still work?
Rogel,
Servoy only supports numerical types for the log_id column.
It can be a db-identity value, but if Servoy supplies the value it currently needs to be a number.
If uuid is needed you can consider filing a feature request.
Rob
rgansevles:
Rogel,Servoy only supports numerical types for the log_id column.
It can be a db-identity value, but if Servoy supplies the value it currently needs to be a number.If uuid is needed you can consider filing a feature request.
Rob
No worries. I will just leave it as it is.
Hi, I have created a case for this as we need this in one of our requirements.
The url to the feature request is https://support.servoy.com/browse/SVY-2495.
Thanks!