Web Apps
QuestArchive
A local-first quest board and scrapbook journal that works with no account and no network, with optional sync through Supabase.

- Role
- Solo designer and developer
- Timeframe
- Oct 2026 - Nov 2026
- 333 KB to 268 KBStartup JS (gzip)
- 46e2e specs
- 22Supabase migrations
- 26Pages Functions
- ~46,500Source lines
- 255Commits
Problem
Quest and journal apps usually need an account and a connection, and a bad update can lose what you wrote. I wanted one that works with no network and never loses a row or a photo.
Approach
- Keep all data in IndexedDB through Dexie, so the app is fully usable offline and without signing in.
- Add optional sync to Supabase Postgres under row-level security, and put AI, link unfurling and email on Cloudflare Pages Functions.
- Prove the risky paths with tests, including a build-swap upgrade check and a two-device sync round trip.
Result
A live PWA on Cloudflare Pages with 46 e2e specs, and startup JavaScript cut from 333 KB to 268 KB gzipped.
- Browser (IndexedDB)
- Optional sync
- Supabase under RLS; Pages Functions
- AI, unfurl, email
Problem
QuestArchive is a quest board and scrapbook journal. The aim was an app that works with no account and no network, and that keeps every entry and photo through updates. It is a solo project: design and code are mine.
Approach and decisions
Data is local first. Everything is stored in the browser’s IndexedDB through Dexie, and the app has no analytics or third-party runtime hosts. Signing in is optional: sync goes to Supabase Postgres under row-level security, with 22 migrations. Features that need a server (AI, link unfurling, posts and email) run as 26 Cloudflare Pages Functions. The front end is React 19, TypeScript, Vite and Tailwind 4, with zod for validation. It is dark by default with a light toggle.
What broke and how it was fixed
- Updates risking data. An upgrade-survives e2e now proves every IndexedDB row and photo survives a swap from one build to the next (f445a0b).
- Sync correctness. A two-device sync round trip is tested against an in-memory fake Supabase (83ef297).
- Slow first load. zod, the palette, the canvas and Brain Dump are lazy-loaded (5d4723e), and startup JS dropped from 333 KB to 268 KB gzipped.
- workerd “Illegal invocation”. Fixed by binding fetch (5608232).
- Blurry wall after zoom. Caused by an always-on
will-change; removed (02b8288). - Phone drag snapping. Dragging a quest that has steps snapped to the checkbox; fixed (c13cc44).
Results
The app is live at questarchive.pages.dev. Over 255 commits between 2026-10-09 and 2026-11-06 it grew to about 46,500 source lines in roughly 496 files, covered by 46 e2e specs.
Limits and what’s next
The repository is private and the author’s instance is not open for public use, so the live site is a demonstration of the app rather than a service for others. I have no user numbers to report and make no claims about adoption.
