cr-sqlite
cr-sqlite copied to clipboard
vlcn-io
Enable query based replication
Most use cases would likely rather replicate a subset of the database as specified by a query rather than all changes occurring on the database.
Query based replication would replicate only the changes that match some query or set of queries.
If we extend https://github.com/vlcn-io/cr-sqlite/issues/195 to also do efficient primary key and table filtering, this will get us 50% of the way there with little work.
We're pretty close to enabling this with the recent additions of:
- crsql_tracked_peers
- & #195
Looks like we could do this via https://doc.replicache.dev/strategies/row-version
as I've explored here: https://github.com/tantaman/repliear-row-versioning