BIS Data Assistant

The client

The Bureau of Indian Standards is India’s national standards body. Its government laboratory facilities test gold purity, and the measurements they record carry legal and commercial weight. The brief was for a system that connects to the laboratory balances, records every measurement, and makes any manipulation or tampering of that data impossible.

What we built

A Windows desktop application that sits on the bench machine and does exactly that.

• Direct serial-port communication with Radwag balances. Readings arrive from the instrument, not from a keyboard.
• Insert-only database architecture. There is no edit and no delete. A record, once written, is permanent by construction.
• Automated purity calculations - Fineness, Delta and Repeatability - computed by the software so the arithmetic is identical for every sample.
• Role-based access controls for technicians, reviewers and approvers.
• Colour-coded audit logs so a reviewer can see at a glance who did what and when.

How it was built

Electron.js with a Node.js core, SQLite3 as the local store, Tabulator.js for the dense measurement tables, and the Serial Port API for the balance link. Runs fully offline, on-premise, in the lab. Four weeks from requirements to deployment, and in daily use at BIS facilities since. No data-tampering incidents have been reported, and BIS commissioned three further desktop applications afterwards.