PASADA
Software Engineer
B&V Software Solutions, Inc.
A desktop franchise registry for municipal tricycle permits. It runs offline, prints MTOP certificates, and syncs records between office computers over the local network.
Built for a client. The source is not public, the full story is right here.
Overview
Municipal offices track tricycle franchise permits on paper. They have slow internet, Windows machines, and clerks who need printed certificates. PASADA is built for exactly that environment, and it carries its own document intelligence layer so records become searchable without any cloud service.
Architecture
The app uses the sidecar pattern. A Next.js UI sits inside a Tauri shell with a FastAPI backend that starts alongside it and answers a /health check before the UI loads data. Records live in SQLite through SQLAlchemy, and a self-healing migration layer fixes the schema on upgrade. Certificates are filled into .docx templates and printed to PDF through Word automation. A LAN sync engine finds other computers by UDP broadcast and pulls new records from them, so several machines can share one dataset without a server. Document processing runs locally so text extraction and search stay inside the office network.
Outcomes
- Full permit lifecycle from application to numbering and status tracking
- Automated MTOP certificate printing to PDF
- Works with no internet at all, syncing over LAN between computers
- Upgrades are safe for non-technical staff