Case Study 01 . Desktop ERP / School Transport Management System
An offline-first Electron ERP for school transport operations, built to manage drivers, students, routes, fees, attendance, trip logs, and cloud sync through local SQLite and Neon PostgreSQL.
University transport records for drivers, students, routes, trips, and payments were difficult to manage manually, causing delays and data inconsistencies.
Transport staff needed a system that could continue working even without internet, especially for daily fee records, attendance, and driver activity.
Student payments, driver ledgers, assigned routes, and service logs were not connected in one centralized workflow, making reporting slow and error-prone.
BR7 built a desktop ERP using Electron, React, and SQLite so transport operations could run locally without depending on constant internet access.
The platform unified drivers, students, routes, fees, attendance, driver ledgers, and trip logging into one structured dashboard.
Local SQLite records are tracked with sync status and pushed or pulled from Neon PostgreSQL, enabling backup and multi-device/cloud consistency.
Electron main process handles IPC, database operations, file dialogs, printing, and sync triggers.
React frontend communicates through a protected preload bridge using window.electronAPI.
SQLite stores drivers, students, routes, services, payments, attendance, ledgers, users, and sync status.
Pending local records are synced to Neon PostgreSQL, while cloud records are pulled and merged locally.
Role-based routing protects admin functionality through React Router and authentication context.
Core transport operations can continue even when internet access is unavailable.
Drivers, students, routes, fees, attendance, trips, and ledgers are managed from one desktop system.
Database mutations trigger throttled sync, reducing manual backup and update work.
React components do not access the database directly; all operations go through Electron IPC and preload bridge.