Najeeb Said

Personal project · 2025

OSAC

Self-hosted desktop garage-management platform for auto repair shop front-office staff and service technicians.

form template
recursive renderer
working form
AdonisJS·PostgreSQL·Supabase·Tauri·React

Problem

Auto service centers relied on paper intake sheets and fixed inspection forms that could not adapt to varying shop workflows across vehicles, jobs, fault reports, and inventory items.

Approach

Architected the solution across four repositories using Docker Compose: self-hosted Supabase containers for auth and storage, an AdonisJS REST API with 16 models and 15 migrations, and a Tauri desktop portal for front-office staff.

Built a nested inspection form template engine. Form templates (sections, repeaters, select fields) are authored visually, persisted relationally in PostgreSQL, and rendered by a recursive React component tree.

Delegated authentication to Supabase GoTrue by mapping the application user model directly onto the GoTrue schema.

Technical Decisions

  1. Transactional recursive tree persistence

    Persisted nested form structures within a single database transaction, replacing temporary client IDs with UUIDs while maintaining array position ordering.

  2. Subtree replacement on template updates

    Replaced template subtrees on modification and let cascading foreign keys delete the old rows, removing the need to diff trees at all.

  3. Supabase GoTrue auth integration

    Mapped internal user schemas to Supabase GoTrue tables, inheriting session management, token refresh, and account ban semantics.

Key Achievements

  • Built complete solo platform across 4 repositories deployed via 14 Docker Compose containers.
  • Authored 16 domain models and 15 migrations covering vehicle intake, job tracking, inventory, and fault reporting.
  • Engineered recursive form engine enabling non-technical staff to build and render nested vehicle inspection sheets.
  • Integrated Tauri desktop shell with AdonisJS REST API and Supabase GoTrue authentication.

Outcome

Service centers operate a self-hosted desktop portal where front-office staff manage vehicle intake, track inventory, and compose custom inspection templates.