Investigate offline support with TanStack SQLite persistence and offline transactions
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 35/100
- Issue type
- Feature
- Clarity
- Mostly clear
- Activity status
- Active
- Tech stack
- sqlite, supabase, typescript
Research direction
Start with the Supabase collection adapter, TanStack browser SQLite persistence, and the TanStack offline transactions example. Evaluate persisted collections and offline inserts, updates, and deletes, then produce a working example or explain why it is not possible; document Auth, RLS, Realtime, retry, conflict, session-expiry, and multi-tab limitations and recommend adapter follow-ups.
Written by the indexing model from the issue text.
Description
What to build
Investigate the best supported path for using the Supabase collection adapter in offline-capable TanStack DB apps. This should use TanStack browser SQLite persistence and the TanStack offline transactions example as reference points.
The investigation should determine which pieces compose cleanly with this adapter today, which pieces need adapter changes, and which behaviors are constrained by Supabase Auth, RLS, PostgREST, or Realtime. The goal is not necessarily to deliver complete offline sync in one pass, but to produce examples or a clear design conclusion that users and maintainers can trust.
The completed issue should show the current best path for persisted collection data and offline mutation behavior. It should also document known limitations around queued writes, retry behavior, conflict handling, auth/session expiry, Realtime gaps, and multi-tab behavior.
Acceptance criteria
- Evaluate TanStack browser SQLite persistence with Supabase-backed collections.
- Evaluate TanStack offline transaction patterns with Supabase inserts, updates, and deletes.
- Produce a working example or document exactly why one is not currently possible.
- Document limitations around Auth, RLS, Realtime, conflicts, retries, and multi-tab behavior.
- Recommend follow-up adapter changes if needed.
Blocked by
None - can start immediately.
- Dominant language
- TypeScript
- Stars
- 57
- Forks
- 5
- Avg merge
- 5d 22h
- Merged PRs (30d)
- 7
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from supabase/tanstack-db
-
enhancement ready-for-agent
Difficulty 5/5 Over a week Newbie friendliness 35/100
supabase/tanstack-db#12 ·
-
enhancement ready-for-agent
Difficulty 5/5 Over a week Newbie friendliness 35/100
supabase/tanstack-db#11 ·
-
enhancement ready-for-agent
Difficulty 4/5 3-5 days Newbie friendliness 56/100
supabase/tanstack-db#9 · 1 comment ·
-
enhancement ready-for-agent
Difficulty 4/5 3-5 days Newbie friendliness 64/100
supabase/tanstack-db#8 ·
All issues in supabase/tanstack-db
Similar issues
-
comp/desktop P3 type/bug
Difficulty 1/5 Under an hour Newbie friendliness 92/100
NousResearch/hermes-agent#118866 ·
-
Browser Waiting for: Product Owner
Difficulty 2/5 1-3 hours Newbie friendliness 85/100
getsentry/sentry-javascript#24577 · 1 comment ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
agilepathway/label-checker#640 ·
-
Plugin stuck at "loading" on DSH 0.1.6-alpha.2 — turnTail list slot registration missing options.id Open
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
chrisparsons83/flexspotff#153 ·