SQLite Forum

Hooks invoked when modifications done from another connection?
Login
An option is to poll the data_version pragma

https://www.sqlite.org/pragma.html#pragma_data_version.

This will change for any update by any process, your connection will be able to see these changes and react. But you will need to poll it rather than have your hook triggered. It should be quite easy to implement though.