database
Installation
SKILL.md
Data Persistence (Drift, Preferences, Secure Storage)
When to use
- Drift: large lists/JSON, offline cache, queryable local data.
- SharedPreferences: user settings and small flags (non-sensitive).
- flutter_secure_storage: tokens, credentials, secrets (sensitive).
Steps
1) Drift (SQLite): centralized tables, feature-first DAOs
Tables live in the app database file; DAOs live per feature in data/datasource/.
Table example (caching raw JSON by key):