DGTOOHL Canvas OOH Platform

Delivered scope

• Covers inventory, bookings, approvals, finance, clients, publishers, media, reports, alerts, audit, and settings.
• Supports MariaDB production persistence, local fallback storage, live API access, and server-side email notifications.
• Uses TanStack Router/Start with dashboard charts, maps, command palette, role checks, and secure upload handling.

Technology

System approach

• Framework: TanStack Start, Vite, React 19, TanStack Router, React Query, and Tailwind CSS 4.
• Persistence: VPS MariaDB with a local JSON fallback for development and structured SQL migrations.
• Operations: Inventory, bookings, approvals, alerts, finance, media, users, publishers, reports, and audit modules.
• Integrations: Resend email outbox, upload storage, live API keys, and secure server middleware.

Challenges

• Keeping live inventory, booking status, approvals, and finance views synchronized across many routes.
• Providing production persistence while keeping local development simple.
• Securing auth, uploads, email sends, API access, and mutating actions in a client-facing platform.

Solutions

• Created shared live-data and inventory-sync layers used by dashboards, tables, charts, and maps.
• Backed server actions with MariaDB repositories, Zod schemas, parameterized SQL, and a deployable migration file.
• Added route guards, role permissions, session cookies, CSP/security headers, rate limits, audit logs, and email outbox handling.

Key outcomes