Is there any implementation of Interceptor in sqlite

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!

+5
source share
1 answer

Perhaps this is what you need SQLite callback function for trace request / logging reports

C/++, SQLite API, , sqlite_trace .

+7

All Articles