PWAs that have to keep working when the network does not — built for agronomists in the field, not analysts at a desk.
Our deepest body of work here is an East African agricultural data-collection programme where field workers operate around fuelled cell towers and intermittent connectivity. We build the data layer in the browser using sql.js, OPFS and IndexedDB, run mutation queues through service workers, and treat sync as a first-class feature — not an afterthought. The architectural decisions that matter are rarely about frameworks: HDOP filtering on captured GPS, whether to resolve write conflicts via CRDTs or last-write-wins (we have shipped both, depending on whether the field model is additive or supervisory), how aggressively to compress payloads for low-bandwidth uplinks, and how to surface sync state to a user who genuinely cannot tell whether their phone has signal. The deeper write-up of how we approach this is on the offline-first apps page, and the engineering walk-through lives in building offline-first applications.


