Built a PHP and SQLite web app with a Leaflet map plotting referrer practices. Access is device-key gated: a shared link plus a token, no full login system to manage. When a new referral comes in, a Telegram bot pings the principal directly. POPIA shaped the data model from the start. Referral data is stored locally, access is scoped, no third-party analytics touching patient records.
For front-desk prospect management, a separate Electron desktop app handles the workflow that never belonged in the web app. It ingests prospects from four sources: a medical scheme directory, the regulator's registry, OpenStreetMap, and existing spreadsheet data via merge-import. Smart Paste pulls prospect details from copied text without manual re-keying. The local database is PIN-locked.
Principal has real-time visibility into the referral pipeline without opening a spreadsheet. Front desk manages prospects in one place. Replaced a paper-plus-spreadsheet workflow across both sides of the practice.
Stack: PHP, SQLite, Leaflet, Telegram Bot API, Electron, Node.js.