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 analyze and 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.

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.