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
- Entry type hierarchies beat one giant nullable row.
- Audio capture + playback is a platform surface, not a widget.
- 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.