OLAProduction tracking for shipbuilding, from the PDF deck plan to the shop floor, offline.

Three layers, one source of truth.

• Frontend. Vue 3 + Quasar SPA. pdf.js renders the deck plan, Fabric.js draws the cabin squares, pins and lines on top. A PouchDB-shaped client mirrors the project to IndexedDB and queues writes in an outbox.
• API. Node / Express 5, routes → services → repositories on node-postgres. JWT HS256 signed server-side, bcrypt cost 12, project-scope authorisation on every route. Input hardening: UUID asserts, integer parsing, status allow-lists, transactions.
• Data. PostgreSQL, 18 business tables + 2 auth tables + 7 analytical views, 3NF around a projet root (one project = one ship). UUID keys, cascade on the project tree. The API self-heals missing columns and views at boot.
• AI. YOLO cabin detection through Roboflow, key proxied server-side; OCR on the PDF annotations; results cross-checked against the Excel nomenclature.
• Ops. Docker Compose (db · api · frontend · nginx · pgAdmin), Capacitor APK for the tablets, deploy → smoke test → log, 42 times.

// offline outbox · replay on reconnect (simplified)
async function flushOutbox() {
  for (const op of await idb.getAll('outbox')) {
    try {
      await api.send(op);                   // projet:put · tache_session
      await idb.delete('outbox', op.id);
    } catch (e) {
      if (e.status !== 409) throw e;
      const server = await api.get(op.ref);
      op.body = mergeProjetLots(server, op.body); // offline wins per task
      if (op.retries++) await idb.put('dead-letter', op); // double 409
      else await idb.put('outbox', op);
    }
  }
}
window.addEventListener('online', flushOutbox);