2025Desktop

BusTrack CRM

A desktop CRM for a transport fleet that works with no network.

Context: Managing a passenger transport fleet: buses, routes, drivers, customers.
Problem: Tracking happened in a spreadsheet: no integrity constraints, no reliable history, duplicates piling up. The target workstation has no guaranteed network connection, which ruled out a web application.
Approach: A Java desktop application rather than a web app, so it runs offline. Embedded SQLite: no server to administer, the database is a file. A Swing interface skinned with FlatLaf, because the default look gives the toolkit's age away. Maven build for a reproducible deliverable.
Outcome: A single executable, installable with no infrastructure, backed by a relational schema that blocks the inconsistencies the spreadsheet used to let through.