I'm looking for a way to make SQLite "reactive" so when one record in a query is updated it reflects in the current binding without having to rerun the entire query.
For example:
<div dmx-repeat:threads="Emails.data.query">
I'm pulling a bunch of records and may change one field in one record, so I would like for the UI to reflect the change without having to rerun the Emails.data.query
.
I'm not sure if there is a way to integrate the SQLite update_hook
.
https://www.sqlite.org/c3ref/update_hook.html
I am seeing some third-party solutions, but not sure if there is a Wappler way of accomplishing this.