Skip to content

Adoption: bounded read-only SQLite tables in the workspace observatory #104

Description

@John-Ryan21337

Club Code has an implemented SQLite database view in its workspace observatory. I am preparing a separate incremental adoption draft on current-dev file-observatory PR94 (67d19445cf880298585a31bdcb25cc6c30543920).

The port will preserve Cafe's server-resolved projectId/root and exact relative-path checks, add explicit database/table/row browsing, and use fixed read-only queries with bounded worker lifetime, output, rows and cells. It will not accept arbitrary SQL, load extensions or change provider versions. Database masking will be described as best effort, not as a secret-protection boundary.

The first runnable slice covers SQLite files inside the selected project. Club's global application-state database view requires a separate explicit access policy and will remain a documented gap unless that boundary can be safely included. Synthetic fixtures, independent review, visual evidence and the required full checks/forced desktop build will precede publication. No live database or account will be queried during development.

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