Set up a log system

Wappler General Need Help
1

I would like to set up a log system in which all user changes to the various queries are saved.

Here’s an example
$user changed in area $area [$timestamp]:
$variable1 from value1 to value2
$variable2 from value2 to value4
$variable3 from value3 to value6
$variable4 from value5 to value8

Preferably with just one query.

How can I implement this?

2

No easy way to do this.

Fastest way is to setup a SQL trigger with custom code.

Recently we found system versioning on MariaDB, so you can try that if you are using MariaDB. But we had to create a custom extension to convert the logged data in the format you are expecting. Complex stuff.

Worst way is the add steps just before the update query and check each an every variable’s value and insert into DB if a difference is found.

3

Yep, did exactly that way.

  1. Make a query to get current data
  2. Compare if (for example) from form you have different value
  3. If those two values are not equal - make a change in DB and Write DB Log entry.

For instance I have this tables in my Log Table:

  1. Change timestamp
  2. Who made a change
  3. What was old value
  4. What is new value
  5. Link to ID which was changed
4

Sounds like being able to set up database triggers would be a great addition to Wappler, I remember something like that in bubble

5

Triggers, from what I have read, are not good for performance. It has been a few years since I last used them.
The team would know better, and if it makes sense, then definitely worth adding.

1 Like
6

I’ll probably have to work with queries there.

thank for your tips!