in-DB logging - Githubissues

wergstatt / pprkrkn

0 stars 0 forks source link

in-DB logging #10

Closed wergstatt closed 5 years ago

wergstatt commented 5 years ago

In order to track the specified cron jobs, add triggers after each insert into the LZ Tables. Seems to be a reasonable way to track the execution of the cron jobs.

wergstatt commented 5 years ago

A simple implementation is done.

Probably, it would be reasonable to track all types of actions, i.e. insert, update and delete. Additionally, it would be favorable to establish a procedure that automatically builds missing triggers and functions insert of the current copy & paste crap.

[ ] Track all actions.
[ ] Build generating procedure.

wergstatt commented 5 years ago

From #6 the following task is inherited:

[ ] Track the current number of rows for each table in an additional column.

In this spirit, we should es with a proper time-series of table sizes.