You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Query subscriptions — register SQL queries on the replica with subscribe(); receive automatically updated result sets in HandleResult::subscriptions whenever incoming changes affect relevant tables
Result-change detection — subscription results are suppressed when the query output is unchanged (FNV-1a hash comparison), avoiding unnecessary work in downstream consumers
Table dependency discovery — sqlite3_set_authorizer during prepare automatically discovers which tables each subscription query reads from; JOIN queries fire when any referenced table changes
Optimised invalidation — reverse index (table → subscription IDs), cached prepared statements (sqlite3_reset instead of re-prepare), and cached column names for minimal evaluation overhead