Offline Data Support

Peer mentors frequently perform activities in locations with poor or no network connectivity - home visits, community centers, or remote areas. Without offline support the entire activity registration workflow fails, causing underreporting and frustration. The offline-first architecture ensures the app remains fully functional regardless of connectivity, directly addressing the highest-priority need identified across all four organizations. Encrypting the local database with SQLCipher ensures GDPR compliance when sensitive personal data (contacts, assignments) is cached on user devices. This is a foundational prerequisite for all data-entry features and a hard requirement for MVP launch.

Built on Drift (a type-safe SQLite abstraction for Flutter) with SQLCipher for at-rest encryption. The mutation outbox pattern records every write operation locally before attempting server synchronization, enabling true offline-first behavior. Offline-created entities receive temporary local IDs that are remapped to server-assigned IDs upon sync. Conflict resolution handles concurrent edits with a last-writer-wins strategy by default, with hooks for domain-specific merge logic. Optimistic mutations apply changes immediately to local state and roll back automatically if the server rejects the operation, preserving data integrity across all supported device platforms.