ProjectsPhotography AboutContact ResumeHome

Case study

StrataField

An offline borewell record keeper for my family's drilling business, rebuilt from Electron to Tauri and shipped with signed automatic updates.

Tauri 2 · React · TypeScript · Rust · SQLite Released, auto-updating Download Source
StrataField's home screen: water level over the years, the newest borewells and what needs attention
The home screen. Screenshots show made-up borewells.

The problem

A drilling contractor keeps a record of every borewell: the owner and location, the soil layers found at each depth, the pipe assembly, and water levels over time. In practice those records live on paper and in Excel logs written in whatever layout the person in the field preferred, which makes them hard to search and impossible to compare across a city.

StrataField keeps those records on the office computer, offline, in plain language, and then puts them to work: a map of the city coloured by depth to water, cross-sections of the ground between borewells, and the change in water level over the years. It's used day to day by my family's drilling business. The pilot city is Lucknow.

What it does

Decisions

Electron to Tauri 2

The first version was an Electron app with a 134 MB installer, because every Electron app ships its own copy of Chromium and Node. Tauri uses the WebView2 runtime that Windows already has, so the installer is 6.4 MB, with the full user manual bundled inside. I wrote up how the move went.

Native SQLite instead of sql.js

The Electron version used sql.js, SQLite compiled to WebAssembly, which keeps the database in memory and writes it back as one file. The rebuild uses a native SQLite database from Rust, with a schema version and step-by-step migrations. Before an upgrade the old database is backed up; a database from a newer version of the app is refused and left untouched. The older app's data is imported automatically the first time 1.0 starts, and the old file is only ever read.

A thin Rust layer, tested TypeScript

The Rust side only does what needs the computer itself: the database, files and backups. Validation, the Excel reader, the water-depth estimates and the cross-section geometry live in TypeScript in a core package with unit tests, where they're quick to change.

Never make an estimate look measured

A few rules are written into the project plan for anyone changing the code. Layers between borewells are drawn faded and dashed, and clicking one shows which borewells it came from. A gap in the layers is flagged as unknown rather than filled in. Old water readings are never mixed with today's, and the period in use is always stated.

How it ships

Version 1.0.0 was released on 30 September 2026, and 1.0.15 eight days later.

Screens

A borewell's page: details, soil layers, pipe and water level The map, coloured by depth to water A cross-section between borewells: measured columns with estimates between them
All projects Note: Electron to Tauri Source on GitHub