DataBase record and save all activity

[dreamquartz]

Hello All,

Due to expanding the User base of a HSQLDB, the Client would like to be able to record and save all activity per session.
I know there is the DataBase log file, that does the job perfectly, but that is removed when the DataBase shuts down.

We had a discussion with Villeroy, a long time ago, during the development and implementation of the DataBase viewtopic.php?t=71054&hilit=update+timestamp, but that did not really work out.
The Client wanted all activity, and would mean a lot of TRIGGERS, slowing down the DataBase.

Now that the issue became relevant again, we decided to look at the log file.
This is not really what we are looking for. It does not provide a TimeStamp for every activity

Question: Is there a way to save a type of activity logfile with a TimeStamp per activity, before the shutdown of the DataBase.

Thanks in advance,

Dream

[Sliderule]

Question: Is there a way to save a type of activity logfile with a TimeStamp per activity, before the shutdown of the DataBase.

Since you are using HSQL as the database backend, perhaps something you might consider and has been available with HSQL since Version 2.5.0 ( 2019-07-01 ) is:

Temporal System-Versioned Tables and SYSTEM_TIME Period

which can be found in the HSQL documentation ( https://www.hsqldb.org/doc/2.0/guide/da ... ned_tables ).

Additionally, reviewing HSQL documentation for Table Creation might be helpful ( emphasis on WITH SYSTEM VERSIONING ): https://www.hsqldb.org/doc/2.0/guide/da ... e_creation .

Reading and understanding the documentation might help, but, it is up to you to test it and determine if it would meet your needs.

Sliderule

Thanks to add [Solved] in your 1st post Subject (edit button top right) if this issue has been resolved.

[dreamquartz]

@Sliderule,

Thank you so much.
the results look promising.
Will keep you posted.

Dream