WHONET SQLite Viewer

High-performance, open-source utility for inspecting, deduplicating, sorting, and analyzing WHONET SQLite databases.

whonet-sqlite-viewer.vercel.app

---

Important

All data is processed locally — nothing is uploaded to any cloud server. Verify all generated figures before submitting to any surveillance body.

Features

• Deduplication — Identify and resolve duplicate isolates clustered by SPEC_NUM (Specimen #) or PATIENT_ID with batch selection and deletion.
• Natural Column Sorting — Interactive click-to-sort headers with intelligent alphanumeric ordering for specimen numbers (e.g. CSR-1, CSR-2, CSR-10, CSR-151, -1/-2, -A/-B suffixes) across Isolates, Duplicates, and SQL Workspace.
• Customizable Clinical Tables — Patient Full Name display, combined Age/Sex formatting (19/f), locale-aware dates, compact action icons, and user-configurable resistance phenotype columns (ESBL, Carbapenem, MRSA) with browser persistence.
• Monthly AMR Surveillance Report (SAPCAR-G) — Standard Gujarat State Action Plan for Containment of Antimicrobial Resistance (SAPCAR-G) Culture & Sensitivity (C&S) reporting data (OPD / IPD / ICU × specimen types) with instant TSV clipboard copy and CSV export.
• Interactive Visual Analytics — Real-time Chart.js distribution charts (Organisms, Specimen Types, Wards, Age Groups, Gender, AMR Phenotypes) with dynamic date range filtering and single/dual view toggles.
• In-Place Record Corrections — Clean, inline field editing and full-record correction modals with immediate database sync.
• Bulk Data Cleansing — One-click uppercase specimen normalization and whitespace sanitation.
• Intelligent SQL Console — Built-in query editor with schema-aware autocomplete, keyboard shortcuts, and instant result table sorting.
• Dual Runtime Architecture — Runs either completely client-side in the browser via the In-Browser Engine (sql.js), or locally via Node.js native DatabaseSync (node:sqlite).

---

Usage

Web / PWA App (In-Browser Engine (Client-side))

Open whonet-sqlite-viewer.vercel.app in Chrome or Edge (or click the browser address bar icon to install as a desktop/mobile app):

• Direct Folder Access: Connect your local data folder once (C:\WHONET\Data) → the browser remembers the link and saves changes straight to disk.
• Preloaded Sample Data: Test immediately with bundled sample databases (WHO-TST-2020-01.sqlite, etc.).
• 100% Private On-Device Processing: The database engine runs directly inside your browser; zero patient data is uploaded to any cloud server.

Local SQLite Server (Node.js) Mode

1. Install Node.js LTS (v22+ recommended)
2. Run start.bat or use the command line:

   npm start              # run local Node server on http://localhost:7890 (with auto-restart)

3. Browser automatically opens at http://localhost:7890.
4. Reads .sqlite files directly from C:\WHONET\Data. Mutations save straight to disk with on-demand connection locking.

Web / PWA Mode (Vercel)

For client-side Vite testing and building:

npm run web:dev        # launch in-browser WASM dev server
npm run web:build      # compile production bundle for Vercel (/dist)
npm run web:preview    # preview production build locally

---

Project Structure & Modular Schema

The codebase is organized into a dual-runtime architecture supporting both local desktop execution and cloud-deployed PWA builds:

├── docs/
│   └── modular-schema.md   # Architectural specification & schema guide
├── public/                 # Static assets & PWA files
│   ├── manifest.json       # Web App Manifest for PWA installation
│   ├── sw.js               # Zero-cache Service Worker for instant updates
│   ├── favicon.ico / .png  # Official WHONET icons & touch assets
│   └── vendor/             # sql.js WebAssembly engine & binaries
├── src/                    # Application source code
│   ├── index.html          # Application UI layout & modals
│   ├── styles.css          # Design system, themes & responsive layouts
│   ├── organisms.js        # WHONET organism dictionary
│   ├── sample-data/        # Bundled sample SQLite databases
│   └── js/                 # Modular ES Module architecture
│       ├── main.js         # ES Module entry point & global event bridge
│       ├── state/store.js  # Reactive application state
│       ├── api/            # Local Node REST dispatcher & live-reload client
│       ├── db/             # WebAssembly database & File System Access API
│       ├── ui/             # Table rendering, modals, and toasts
│       ├── utils/          # Natural sort, formatters, and organism badges
│       └── pages/          # Dashboard, Isolates, Duplicates, AMR, SQL, Fixes
├── server.js               # Local Node.js server (native node:sqlite & auto-sync)
├── start.bat               # Windows 1-click launcher for lab machines
├── vite.config.js          # Vite configuration for production builds
├── vercel.json             # Vercel deployment routing & static build config
└── package.json            # Project dependencies & operational scripts

For complete technical specifications, module contracts, and database table diagrams, refer to docs/modular-schema.md.

---

Disclaimer

WHONET is the intellectual property of the WHO Collaborating Centre for Surveillance of Antimicrobial Resistance (Brigham and Women's Hospital). whonet.org

This project is an independent open-source utility by Dr. Darshit Mistry and is not affiliated with, endorsed by, or sponsored by WHONET.