Skip to content

Workspace SQLite previews: explicit refresh and primary-key snapshot comparisons #106

Description

@John-Ryan21337

Club's database observatory can compare row snapshots using primary-key metadata. I am preparing a separate incremental adoption draft on project previews #114, independent of discovery issue #105.

The proposed port retains the existing fixed read-only snapshot worker, size/deadline/path and connection guards. It will return bounded typed primary-key identifiers only when complete, visible key values are safe to match. The UI compares successive explicit refreshes and can offer a separately explicit bounded refresh toggle. Truncated, masked, missing-key or ambiguous snapshots must not be presented as proven row changes. Differences describe observed snapshots, not a database audit log or proof of insert/delete operations.

No arbitrary SQL, global application-state database access, provider changes or user database testing. Synthetic SQLite and browser regressions, fresh independent review and final media/gates will accompany the fork draft.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions