Alberto Tuveri

SerSanWorkshop ERPClient system

Maintech OMA

Custom ERP for a heavy-vehicle workshop of about 50 staff, founded from the application scaffold to the first database schema.

All works

Access
no public address

9

roles, default-deny on every table

Nine roles Permissions held in the database, not in tokens.

01 What it is

Foundedfrom the scaffold

A custom ERP for a heavy-vehicle workshop with about 50 staff across mechanics, mechatronics, auto-electrics, bodywork and refrigeration. I founded the system: the application scaffold, the 'Diesel & Safety' design system (design tokens, light and dark themes, a component library) and the first database schema the rest of the product was built on.

Stack

  • Vite
  • React 18
  • TypeScript
  • Supabase (Postgres 17, RLS, Edge Functions)
  • TanStack Query

02 The domain core

Customerto purchase order

The domain core I delivered, from the customer to the order that buys the parts.

  1. 01Customers
  2. 02Vehiclesequipment and inspection deadlines
  3. 03Job ordersrole-gated transitions, safe numbering under concurrency
  4. 04Parts cataloguemulti-supplier price comparison
  5. 05Purchase orders

The domain core The job-order phases are numbered here, not named.

03 Security

What holdsat the database

A database-first security model that cannot be bypassed from the client: default-deny access rules on every table, per-site data segregation, and permissions held in the database rather than in tokens.

  1. 3

    Live defects

    Exposed by the first database test suite written against the model, and fixed before they reached production.

  2. 6

    Phases

    Job orders on a state machine with role-gated transitions and safe numbering under concurrency.

  3. 10

    Trade portals

    A connector console, article-level price comparison and a caching layer that never degrades a good supplier response; and a high-severity privilege escalation closed: it let any user with price access alter where supplier credentials were sent.

04 The record

Studio
SerSanSersan LimitedLondonRemote
Client
A heavy-vehicle workshop, about 50 staff
Role
Founded the system and its architecture
Access
Client system, no public address
Photograph
none

More work

  1. 01SerSan Agent OSSerSan · multi-agent systemOpen
  2. 02SphereNodeSerSan · live at spherenode.comOpen
  3. 03Sphere AISerSan · RAG mentorOpen
  4. 04Maintech OMASerSan · workshop ERPThis case
  5. 05sersan.ioSerSan · Jun – Sep 2026Next
  6. 06Domus TuaSerSan · real-estate brand platformOpen
  7. 07Brand filmSerSan · identity and filmOpen
  8. 08OblaPersonal project · multi-agent systemOpen
  9. 09Badante24hALS MCL Civitanova · freelanceOpen
  10. 10Voice AI AgentDOIT S.r.l · internshipOpen
  11. 11Supply ChainUniversity of CamerinoOpen