Desktop MIS
Healthy Village Tracker
Multi-domain health indicators across hierarchical geographic regions with offline-first synchronization.
This application is part of the MFB MIS Ecosystem — a suite of five cross-platform applications forming a complete data pipeline for health program monitoring.
Overview
Desktop Management Information System for tracking 56 health program indicators across 6 geographic hierarchy levels. Features offline-first incremental sync with timestamp-based differential updates, dynamic SQL view generation for multi-level aggregation, and high-performance charting with complex real-time filtering.
Hard Problems
Challenge
Syncing large hierarchical datasets with minimal bandwidth.
Solution
Timestamp-based differential sync — client sends last update timestamp, server responds with only changed records in compressed ZIP.
Challenge
Aggregating data across 6 hierarchy levels with evolving logic.
Solution
Dynamic SQL view generation with SUBSTR grouping and validation against location tables.
Key Decisions
| Decision | Chose | Over | Because |
|---|---|---|---|
| Sync strategy | Timestamp-based differential | Full dataset sync | Bandwidth efficiency — only changed records transfer. Critical for low-connectivity field offices. |