As far as I can see, VSS uses the rowid field to correlate the index and data in a table.
For lacalfirst applications that use sync and replications of a databases cross devices rowid is not reliable identifier
Also Rowid isn’t stable in SQLite. It’ll change between vacuum calls unless the Rowid is aliased
https://www.sqlite.org/rowidtable.html
To make cross-device and replication sync possible we need some kind of identifier to correlate
As far as I can see, VSS uses the rowid field to correlate the index and data in a table. For lacalfirst applications that use sync and replications of a databases cross devices rowid is not reliable identifier
Also Rowid isn’t stable in SQLite. It’ll change between vacuum calls unless the Rowid is aliased https://www.sqlite.org/rowidtable.html To make cross-device and replication sync possible we need some kind of identifier to correlate