Is there a way to make SQLite reactive?

Wappler General Need Help
1

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.

2

This is a Wappler design issue/choice, it's unlikely you'll find a solution in the foreseeable future