FREN

Product case study

Bruno Pizza — Production

A local desktop application that turns an Excel plan into an actionable workshop production flow.

Back to projectsView GitHub repository
Bruno Pizza production dashboard showing quantities by variety and distributor
Status
Active product — Windows 1.1.4 / macOS 1.1.3
Responsibility
Full-stack design and development
Scope
Local desktop application

Context

From production file to workshop use

The need is concrete: distribute pizza production across several distributors, validate imported quantities and then guide preparation variety by variety. A spreadsheet provides the data, but it is not an interface designed for the production workflow.

Solution

A guided local business workflow

The application matches the Excel plan with a business catalogue and organizes work across three complementary areas.

Bruno Pizza production dashboard showing quantities by variety and distributor
Production dashboard
01

Production dashboard

Excel import and validation, header, duplicate, quantity and total checks, followed by distribution by variety and distributor.

02

Workshop flow

Ordered recipe, picture, progress and navigation to guide preparation pizza by pizza.

03

Business settings

Local management of pizzas, ingredients, recipes, pictures and distributors.

Architecture

A full-stack chain packaged with Electron

  1. The Excel file remains the source of the production plan.

  2. React and TypeScript power the interface and presentation rules.

  3. Express exposes a strictly local API bound to 127.0.0.1.

  4. SQLite stores the business catalogue and recipes on the machine.

  5. Electron starts the backend on an available port and provides the desktop application.

Decisions and trade-offs

Make local use reliable before expanding the scope

Local operation

Data, pictures and settings remain on the machine. The server is not designed to be exposed directly to the Internet.

Separated persistence

User data is stored outside installed files so an update can reuse the existing catalogue.

Verifiable delivery

Frontend, backend and desktop checks are grouped before release packages are built. Windows version 1.1.4 was validated in the workshop on a 43-inch screen.

Current limitations

A deliberate scope

  • Excel remains the only production source; Adial integration is not included yet.
  • The application targets trusted local use and does not include the authentication required for network exposure.
  • The Windows and macOS test releases are not signed yet.

Stack

Core technologies

  • React
  • TypeScript
  • Electron
  • Express
  • SQLite
  • Vite