Isar Database

• Use Isar as the primary local database for structured data persistence
• Define collections using @collection annotation with Id field
• Place collection definitions in the data/local/ directory of the relevant feature
• Run dart run build_runner build --delete-conflicting-outputs after modifying collections

Schema Design

• Keep collections focused — one collection per domain entity
• Use @Index annotations for fields queried frequently
• Use @enumerated for enum fields
• Use Links and Backlinks for relationships between collections
• NEVER store derived/computed values — compute them in the domain layer

Migrations