Repository navigation
id: design: Turso/libSQL journal fit (design + spike) (from #5681) #5865
Description
Summary
Follow-on design ticket from #5681 — 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
libSQL embedded replicas and primary replication composed with #806, with a small proof of concept.
Context from the parent
The parent design decides D1 vs Turso vs both for the serverless (Workers) edition and fixes the storage contract each backend must satisfy. 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: #5681. Programme: epic #2056. Filed by WS-F (2026-11-04 ID design gap & expansion pass).
Activity
developing-today commentedon Nov 5, 2026
CODE-1548
dezren39 commentedon Nov 5, 2026
agent-note:v1
Triage 2026-11-05 (task 10267): well-scoped follow-on design+spike ticket from #5681, verified open with no hard-stop labels and no decision record yet (only comment is the Kaneo link).
Verified ordering context, fresh reads:
idon Cloudflare Workers #5681 (D1 vs Turso vs both for the serverless edition; storage contract per backend) is OPEN. This ticket composes libSQL embedded replicas / primary replication with id: F12.13 journal replication (read replicas over a signed stream) #806 under that contract, and must not re-decide it — so the spike can be built and measured now, but the closing decision record is ordered after design(id): serverless edition storage — D1 vs Turso vs both foridon Cloudflare Workers #5681's backend decision, or must explicitly record which parent draft it was taken against.kind/designto match sibling tickets. Programme: epic epic: ID platform expansion — apps, comms, currency, hosting, boards (2026-10-28 directive, LIST 6–15) #2056.Routing: no blocker on Drew. The spike (small proof of concept) is the evidence-producing step and is independently actionable; implementation timing beyond the spike is a separate later decision per the filing note.
39 remaining items
dezren39 commentedon Nov 9, 2026
🤖 Agent note · handed off
opencode(lane row 5154, no session bound), so this lane handed it off per runbook §1b and did not work it itself.handed_offand parked task 13663 for 1200s.dezren39 commentedon Nov 9, 2026
🤖 Agent note · handed off