← Back to Case Studies

MiniMRP

A compact material requirements planning system for electronics-focused small businesses, covering products, BOMs, inventory, production, purchasing, and a dual-runtime path for both cloud and desktop use.

Background: MiniMRP was built as a focused internal tool for electronics-oriented small businesses that need practical manufacturing and purchasing workflows without the overhead of a full ERP.

Problem: The main problem was modeling real operational workflows clearly enough to be useful day to day while keeping the application compact, understandable, and maintainable.

Solution: I designed the system around direct domain concepts such as products, versions, BOM references, inventory, production entries, and purchasing requirements, with a structure that maps closely to how the workflow actually runs.

Process: The project combined product modeling, Supabase-backed web flows, a SQLite desktop runtime direction, import/export workflows, and a runtime architecture that keeps the shared app stable across both cloud and offline use cases.

Results: The result is a practical MRP application that supports core manufacturing workflows, keeps the domain model intentionally compact, and creates room for both web and desktop usage without splitting the application into separate products.

What I learned: I learned a lot about designing internal tools around business reality instead of abstract systems, and about separating runtime concerns cleanly enough that one app can support both cloud and offline desktop execution.

Tags:

#Next.js #TypeScript #Supabase #SQLite #MRP #Inventory Systems

Links

GitHub repository