elv8dgtl.
Custom SaaS / ERP Architecture / POS Engineering
Heavy fabrication.
Sub-second precision.
Custom offline-first ERP engineering that turns complex dimensional cutting and material scrap into profitable, frictionless operations.
01 / The brief
Star Glass & Aluminium, a premier architectural glass and aluminium fabrication enterprise, needed an industrial-grade ERP to replace manual paperwork and error-prone fractional math. The system required custom dimensional square-foot cut calculators, automated scrap and offcut tracking, multi-unit stock monitoring, and instant GST-compliant thermal and A4 invoicing that functions 100% offline.
The challenge
Standard generic cloud POS platforms cannot calculate sheet optimization or handle dimensional material conversion (sheets to sq. ft. cuts, mm, and kilograms). Offcuts were frequently lost or discarded as scrap without cost tracking. Moreover, factory floor internet outages cannot be allowed to freeze counter checkout or customer billing.
The connective thread / Concept map
Each decision informs the next. Here is how the thinking connects across this project.
A visual map of the approach. Not live performance data.
02 / The strategy
Not just what we made. Why the approach made sense for Star Glass & Aluminium.
Built dynamic fractional conversion algorithms across 8 measurement units (SHEET, SQFT, SQM, MM, KG, RUNNING_FOOT), automatically calculating glass surface area, extrusion weights, and customer rates in real time.
Engineered an intelligent offcut catalog that automatically records usable remnants from master sheets during cutting, making them instantly searchable and reusable for future customer jobs.
Designed a high-throughput local FastAPI backend backed by SQLite with Write-Ahead Logging (WAL) and automated nightly backups, providing zero network latency, bulletproof crash resistance, and sub-second checkout.
03 / The execution
The platform was engineered with FastAPI, SQLite WAL mode, Python, and a lightweight, high-contrast responsive interface designed for fast keyboard-driven navigation on factory counters. Features include UPI QR payment integration, dual thermal/A4 tax invoice printing, double-entry financial accounting with automated trial balances, and role-based permissions.
Managing Director — Star Glass & Aluminium
“The dimensional cut calculator eliminated all billing errors on our counter, and tracking offcuts alone has recovered significant profit that used to be lost in scrap. It is lightning-fast and never goes down even without internet.”
The execution / 01
Engineered for high-volume counter operations with instant sq. ft. calculation, GST breakdown, and thermal receipt printing.
The execution / 02
Real-time tracking of master sheets, aluminium extrusions, and reusable offcuts across 8 measurement axes.
The execution / 03
Integrated Day Book, Journal Vouchers, Trial Balance, and Profit & Loss statements linked directly to daily sales.
System Architecture & Engineering Benchmarks / 2026
Star Glass & Aluminium · Offline Enterprise ERP · Heavy Fabrication
01 / POS Dimensional Cutting Engine
Eliminating manual fractional math with sub-second trigonometric glass & aluminium cut engines.
POS Engine › Dimensional Calculator › Real-Time Benchmarks
Industrial counter billing operational telemetry
Cutting master glass sheets (e.g. 96" × 48" float or laminated glass) into custom window panes previously took counter staff 2 to 4 minutes per line item using pocket calculators. Our POS engine calculates exact square footage, edge wastage indices, GST tax slabs, and thermal invoice line items in under 250 milliseconds.
02 / Local Concurrency & Durability
SQLite Write-Ahead Logging (WAL) engineered for zero shopfloor data corruption.
FastAPI Backend › SQLite WAL Engine › Localhost Cluster
Industrial resilience with zero cloud reliance
Manufacturing clusters in industrial estates experience frequent broadband disconnects. By pairing Python FastAPI with an optimized SQLite WAL database running as a background service, Star Glass operates completely uninhibited during citywide fiber outages.
03 / Manufacturing Loss Prevention
Turning discarded glass and aluminium offcuts into cataloged, reusable inventory.
Counter clerk inputs length, width, thickness, and quantity.
Engine computes kerf loss and identifies usable remnant margins.
Offcut piece is auto-assigned a unique SKU with exact remnant sqft.
Subsequent small-pane orders match offcut inventory before cutting master sheets.
Instead of piling offcuts into factory scrap bins, every remnant above 1 square foot is indexed and prioritized for small jobs, directly increasing gross material margins.
04 / The outcomes
Downtime during network outages
Average invoice checkout speed
Specialized API endpoints
Performance metrics measured across on-premise production deployment and daily counter transaction throughput.
Keep exploring / Next project
A considered digital welcome and tangible brand identity for Kanpur’s premier resort. Custom web experience with a direct reservation flow paired with luxury physical collateral.
Small challenges. Fresh perspectives.
The launch button is the last step, not the first. Assemble a simplified project journey using the clues.
Optional / No timer / No scores saved
