I am using SQLite embedded in a .Net Desktop application developed with WPF.
SQLite provides a callback for any write operation performed to the database (within the same connection) ref
In this callback, it provides the following which leads to the records being affected
I like the lightweight LiteDB but couldn't find data changes callback support
I ended up using the Realm Database.
Realm lets register a notification handler on a specific collection. The handler receives a description of changes since the last notification. Specifically, this description consists of three lists of indices:
Another plus point of Realm over SQLite is that these change notifications are NOT limited to changes from the same connection.