Lotti: journaling with audio, habits, and a serious local DB

Most Flutter tutorials stop at CRUD. Lotti is interesting because journaling forces multi-modal entries (text, audio, habits, measurements) and long-term local storage.

Lessons

1. Entry type hierarchies beat one giant nullable row.
2. Audio capture + playback is a platform surface, not a widget.
3. Insights need indexes — design queries before charts.

Pitfalls

Migrations on personal data are sacred; write them carefully. Background recording permissions vary by OS.

Look at Lotti when your “simple notes app” is no longer simple.

---

Originally published on FlutterCook. Read the latest version there — that copy is the one kept up to date.