Altinity / Altinity/altinity-sql-browser

GS: Managed spreadsheet layout and manual refresh route

Open
#401 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

cool feature
Dominant language
TypeScript
Stars
8
Forks
2
Avg merge
1h 34m
Merged PRs (30d)
6

Description

Parent: #398
Depends on: #400

Design:

  • docs/design/google-sheets/architecture.md
  • docs/design/google-sheets/spreadsheet-layout.md
  • docs/design/google-sheets/authentication.md

Scope

Create and attach the managed control/data/state worksheets, developer metadata, refresh hyperlink, focused refresh route, authentication-intent restoration, and destination verification.

Acceptance criteria

  • Linked spreadsheets use stable numeric sheet IDs plus developer metadata.
  • The control sheet exposes refresh/status/source actions without secrets.
  • _ASB_STATE and staging sheets are hidden and validated as untrusted input.
  • Refresh URLs contain only an opaque binding ID in the fragment.
  • Opening the link serves the ordinary SPA and resumes after ClickHouse authentication.
  • Google authorization is requested explicitly and edit access is verified.
  • Renaming or moving a spreadsheet does not break identity.
  • A copied spreadsheet is detected and offers explicit relink/remove/cancel choices.
  • SQL Browser never identifies resources by sheet name alone.

Non-goals

Query upload/publication semantics, scheduled refresh, or inbound Google callbacks.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reading docs/design/google-sheets/architecture.md, docs/design/google-sheets/spreadsheet-layout.md, and docs/design/google-sheets/authentication.md, then review parent #398 and dependency #400. Done means implementing the listed managed-sheet, refresh-route, authentication, identity, and copied-spreadsheet behaviors while meeting every acceptance criterion and excluding the stated non-goals.

Written by the indexing model from the issue text.

Assessment

Tech stack
typescript
Domain
api, authentication, full-stack
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.