Every offline app I start rebuilds the same plumbing: a local database, a way to seed it with starter content, search, favorites, and eventually backup. I got tired of rewriting it, so I extracted the working stack from my own app — a magic index app I've been building all year — into a starter kit called Footings.
The core idea: two databases, not one
Most offline tutorials use a single database. Footings uses two:
- A bundled read-only seed DB that ships with the app. This is your starter content.
- A writable user DB for everything the user creates, plus favorites.
The split matters when you ship an update. New seed content replaces the bundled DB; the user's data is never touched. The user DB migrates itself — v1 to v2 adds an images table and an ocr_text column — so existing users keep everything.
What's in the free lite version
The lite version is MIT-licensed and on GitHub:
- Word-start search, category browsing, favorites, full CRUD
- The two-database setup, with a seed DB you replace with your own content
- A clean
flutter analyzeand passing tests
What the full version adds
Three features, and each one taught me something:
Google Drive backup/restore. The app's data lives in Drive's app-data folder, with silent auto-backup and change detection, plus export/import through the share sheet. Buyers plug in their own OAuth client ID — nothing of mine ships in the kit. One gotcha: google_sign_in is pinned at ^6.3.0, because the v7 API changes the auth flow and the extension_google_sign_in_as_googleapis_auth bridge expects the v6 shape.
On-device OCR scan-to-create. Take a photo of a page, and ML Kit reads the text. The text is kept for reference and search — but nothing is ever auto-filled. I learned that the hard way: my first version auto-filled the title from OCR and put a "$20" price sticker in the Title field. Manual entry after the photo, every time.
Per-item photos from camera or gallery, backed up along with the rest.
Pricing
The lite version is free on GitHub. The full version is $49 at launch (going to $99), one-time, unlimited personal and commercial projects.
- Free lite: https://github.com/Majician13/flutter-offline-starter
- Full version: https://4308559011616.gumroad.com/l/footings
If you're building an offline-first Flutter app, I'd love to hear what your data layer looks like — and what you'd want a starter kit to do that this one doesn't.
