Skip to content

id: design: Turso/libsql HTTP adapter (from #5672) #5806

Open

Description

@dezren39

Summary

Follow-on design ticket from #5672 — its decomposition sketch names this as a separate design, and the parent's acceptance requires these tickets to be filed and linked. Filed in the 2026-11-04 gap pass (WS-F) so the design work exists and can be prioritised on its own merits; implementation timing is a separate decision, possibly months out.

What this design must settle

The Turso/libsql HTTP adapter: ID data over libsql's HTTP surface, type mapping, and the lossy corners stated.

Context from the parent

The parent design fixes the selective-sharing grants model, the existence-privacy rule, and the foreign data-store adapter contract. The parent issue carries the surrounding decisions this ticket must not re-decide; where this ticket's answer would change a parent decision, record that explicitly rather than silently forking it.

Decision record expected

Close this design with a recorded decision (on this issue or in a doc/ record linked from it): the chosen shape, the alternatives rejected and why, and the invariants implementation must hold. If the design splits further, file the splits and link them here rather than growing this issue.

Relations

Parent: #5672. Programme: epic #2056. Filed by WS-F (2026-11-04 ID design gap & expansion pass).

Activity

  1. added
    app/idPackage/app: id (pkgs/ or apps/ in this repo)
    on Nov 5, 2026
  2. developing-today commented on Nov 5, 2026

    @developing-today
    Contributor
  3. added
    queue/queuedHas a queued task in the Supabase agent queue
    task/triageQueue packet kind: verify, reproduce, and route this item
    on Nov 5, 2026
  4. added
    queue/claimedQueue worker lifecycle state
    work/assignedQueue worker lifecycle state
    and removed
    queue/queuedHas a queued task in the Supabase agent queue
    on Nov 5, 2026
  5. developing-today commented on Nov 5, 2026

    @developing-today
    Contributor

    🤖 Agent note · handed off

  6. added
    status/parkedDeliberately paused with a recorded resume condition
    queue/parkedQueue task is parked (waiting on CI, time, or an event)
    and removed
    queue/claimedQueue worker lifecycle state
    on Nov 5, 2026
  7. developing-today commented on Nov 5, 2026

    @developing-today
    Contributor

    🤖 Agent note · handed off / parked

    • Agent: queue worker (repo-worker-code), lane code-l
    • Session / ID: queue task 10209
    • Found via: atomic queue claim (lane code-l); execution-lane assignment returned opencode, so per runbook §1b this task is handed off to the laptop opencode claimant — not worked directly by this lane.
    • Task: triage id: design: Turso/libsql HTTP adapter (from #5672) #5806 — id: design: Turso/libsql HTTP adapter (from id: design: ID selective sharing and foreign data-store adapters v1 #5672)
    • Revalidation (fresh, 2026-11-05T14:07:53Z, via developing.today GitHub App token): issue OPEN, no hard-stop labels (state/labels: OPEN task/triage,status/parked,queue/parked,app/id,work/assigned).
    • Action: task 10209 parked as handed off; the claimant launches the bound opencode session to do the work.
  8. 5 remaining items

  9. dezren39 commented on Nov 5, 2026

    @dezren39
    MemberAuthor

    🤖 Agent note · handed off

  10. added
    queue/parkedQueue task is parked (waiting on CI, time, or an event)
    status/parkedDeliberately paused with a recorded resume condition
    and removed
    queue/claimedQueue worker lifecycle state
    on Nov 5, 2026
  11. dezren39 commented on Nov 5, 2026

    @dezren39
    MemberAuthor

    🤖 Agent note · state: handed off

  12. added
    queue/claimedQueue worker lifecycle state
    and removed
    status/parkedDeliberately paused with a recorded resume condition
    queue/parkedQueue task is parked (waiting on CI, time, or an event)
    on Nov 5, 2026
  13. dezren39 commented on Nov 5, 2026

    @dezren39
    MemberAuthor

    🤖 Agent note · picked up

  14. dezren39 commented on Nov 5, 2026

    @dezren39
    MemberAuthor

    🤖 Agent note · done

    • Agent: queue worker (repo-worker-code), lane 1a180ae5-384f-4e71-8d77-08f7b1652c75
    • Session / ID: repo-health-code-pilot task 10209
    • Revalidation: id: design: Turso/libsql HTTP adapter (from #5672) #5806 is OPEN; parent id: design: ID selective sharing and foreign data-store adapters v1 #5672 is OPEN. No hard-stop labels or matching open PR were found. Issue labels now have no queue/status/work in-flight markers.
    • Current-main evidence: laptop main is at 6a06a926a0a0e1f3a1aac661fa65c5bab2b4aacb. pkgs/id/src and pkgs/id/Cargo.toml contain no remote Turso/libsql HTTP adapter; the only source grep hits are unrelated SQLite-dependency test strings in store_traits.rs. The October Turso spike in doc/2026-10-11T11-08-42Z_design_remaining_work/research-round2/turso/RESULTS.md addresses embedded/local storage replacement, not the remote HTTP adapter in this issue; keep those decisions distinct.
    • Triage / route: this is a design/research item, not a reproducible code defect. Keep scope to the remote libsql/Turso HTTP adapter: protocol/API choice, type mapping, auth-token handling, batch/transaction semantics, live vs. materialized/cached behavior, credential references, and timeout/error behavior. Follow the general adapter contract and selective-sharing/existence-privacy constraints in id: design: ID selective sharing and foreign data-store adapters v1 #5672; record any proposed change to those parent decisions there first. Exclude the embedded pkgs/id local-storage migration and unrelated event-store work.
    • Ordering / follow-up: id: design: Turso/libsql HTTP adapter (from #5672) #5806 itself is the scoped follow-on design work item; no code-fix queue task or duplicate design ticket was created. Do not implement until its decision record selects the adapter shape and invariants. No code tests or PR apply to this triage-only outcome.
    • Links: id: design: Turso/libsql HTTP adapter (from #5672) #5806 · parent id: design: ID selective sharing and foreign data-store adapters v1 #5672
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

app/idPackage/app: id (pkgs/ or apps/ in this repo)task/triageQueue packet kind: verify, reproduce, and route this item

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions