mvsqlite icon indicating copy to clipboard operation
mvsqlite copied to clipboard

Change notification for queries

Open losfair opened this issue 3 years ago • 1 comments

The current primitives provided by mvstore/mvsqlite is enough to implement efficient change notification for queries: notify the app when the result of running a query may change.

The mechanisms involved are read_set and the interval field provided by the /stat endpoint. Pages read by a transaction can be recorded, and later checked against /stat response.

However, exposing this would either need modification to SQLite itself, or the use of thread-local state.

losfair avatar Aug 19 '22 16:08 losfair

Cool use case

gedw99 avatar Aug 25 '23 07:08 gedw99