Learn

Source Index

This topic was written from the existing /plan-learn output and targeted /learn discovery. No repos were cloned, no packages were installed, and _repos/ was not mutated.

Primary Plan Sources

SourceUse
_docs/_plan-learn/local-first-data-offline-sync/learn-plan.mdscope, path, content plan, research questions
_docs/_plan-learn/local-first-data-offline-sync/research/findings-summary.mdsynthesized findings, scope, blockers
_docs/_plan-learn/local-first-data-offline-sync/research/web.mdofficial docs summaries for Room, SQLite, MDN, Dexie, Replicache, Electric, Tauri, Electron
_docs/_plan-learn/local-first-data-offline-sync/research/context7.mdresolved Context7 libraries and prior API findings
_docs/_plan-learn/local-first-data-offline-sync/research/prior-lab.mdfinance app and local AI app prior research
_docs/_plan-learn/local-first-data-offline-sync/research/repos.mdexisting repo inventory and read-only policy

MCP Calls In This Learn Run

ToolQueryResult
local-docslist_repos152 indexed repos, many queued/stale; relevant repos present
local-docs"SQLite FTS5" in localgpt-app-localgptLocalGPT memory uses Markdown plus SQLite FTS5 and sqlite-vec
local-docs"backup" AND "SQLite" in benbjohnson-litestreamno results
local-docs"export" AND "import" AND "SQLite" in block-gooseno results
local-docs"Tauri" AND "SQLite" in janhq-janno results
Context7/androidx/androidx Room migration queryMigrationTestHelper and destructive migration API references
Context7/websites/sqlite_docs SQLite backup/WAL queryhot backup, WAL, PRAGMA, integrity references
Context7/websites/dexie Dexie migration/export queryupgrade, export/import, worker, synced migration caveats

Repo And File Reads

SourceUse
_repos/benbjohnson-litestream/docs/ARCHITECTURE.mdWAL monitoring and replication architecture grounding
_repos/benbjohnson-litestream/docs/SQLITE_INTERNALS.mdWAL file structure, checkpoints, and lock page grounding
_repos/benbjohnson-litestream/docs/TESTING_GUIDE.mdrestore integrity and edge-case testing patterns
_repos/localgpt-app-localgpt/website/docs/memory-system.mdMarkdown source plus SQLite FTS5/vector derived index example
ai-research/sources/goose/README.mdSQLite session persistence and export/import note
ai-research/sources/jan/README.mdTauri desktop and file-backed JSON/JSONL state note

Blockers And Follow-Ups

  • SQLCipher official docs were blocked during planning, so full-database encryption remains source-to-verify.
  • Automerge docs were blocked or moved during planning, so CRDT implementation guidance stays conceptual.
  • PowerSync architecture URL returned 404 during planning, so it is not included as a current source.
  • Android platform backup, Storage Access Framework, and Auto Backup deserve a focused follow-up before writing a deeper Android backup page.