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.