I am wondering if there is a way to intercept DML operations in sqlite? I want to implement something like an audit system to insert inserts and updates in the database and record changes to these events.
I looked at the use of triggers, but that was not enough, because there was no way (what I know) to define a global trigger, and manual control of triggers for more than 100 tables does not seem like a good idea ... longterm!
I am open to any suggestions, so please shoot!
source
share