Pacy Labs Spade Logo
PACY LABS
Olamilekan David Adegoke • OD
← Back to Systems CatalogCommercial Contract / Dreamwise Computer Enterprise

DreamwiseHUB

Omnichannel Tech Retail POS & Multi-Stage Repair CRM (Commissioned by Dreamwise Computer Enterprise)

Visit Live SystemCommission an Enterprise Build
https://dreamwisehub.com
Production
DreamwiseHUB Production Interface
7-Tier PostgreSQL RLS
Security & Authorization
Dual Retail/Workshop Isolation
Inventory Model
Multi-Stage Technician Lifecycle
CRM State Machine
Nominatim Auto-Geocoding
Location Engine

Executive Architectural Overview

Enterprise operational operating system and storefront commissioned by Dreamwise Computer Enterprise to unify omnichannel Nigerian tech retail with complex repair workflows. Features dual inventory isolation separating retail products from repair parts, 7-tier PostgreSQL RLS, multi-stage technician lifecycle tracking, persistent floating Gemini AI support intercom with staff takeover, customer self-service /track portal, and Nominatim OpenStreetMap auto-geocoding.

Core Architectural Accomplishments

Architected enterprise hardware POS and repair CRM with 7-tier RBAC enforced via PostgreSQL Row Level Security (RLS) and server-side layout proxy guards.
Engineered real-time human-in-the-loop AI support intercom powered by Gemini AI with dynamic FAQ grounding and automated WebSocket escalation to technicians.
Implemented high-concurrency checkout pipelines with atomic PostgreSQL constraints and idempotent Paystack webhook verification to eliminate inventory overselling.
Built dual inventory isolation (retail stock vs. repair parts) to keep financial profit analytics untainted, paired with automated OpenStreetMap Nominatim address geocoding.

Deterministic Guarantees

Concurrency Model
Atomic stock decrement triggers, idempotent Paystack webhook verification, isolated internal inventory tables.
AI & Protocol Layer
Gemini AI support intercom with knowledge base grounding and automated staff handoff.
Database & Infrastructure
Supabase PostgreSQL with 7-tier RLS, real-time ticket state machine (received → diagnosing → completed).
SUBSYSTEMS • ARCHITECTURAL MODULES

Integrated System Components

MODULE 01

7-Tier Hardened RBAC & Automatic Owner Whitelist

Enforces non-negotiable boundaries across Customer, Receptionist, Technician, Accountant, Manager, Owner, and Admin using PostgreSQL RLS and proxy middleware, with automatic owner whitelist triggers.

MODULE 02

Dual Inventory Isolation

Strictly separates retail sales products from internal repair workshop stock (screws, IC chips, thermal paste), safeguarding business gross margin analytics.

MODULE 03

Multi-Stage Technician Repair CRM

End-to-end device servicing lifecycle (received → diagnosing → waiting_on_parts → completed) with customer self-service tracking codes.

MODULE 04

Human-in-the-Loop Gemini Intercom

Floating customer chat grounded in enterprise FAQs with seamless WebSocket escalation to technicians when human expertise is requested.

MODULE 05

Automated Nominatim Geocoding

Converts raw business street addresses into verified latitude/longitude coordinates and generates interactive maps without third-party API bloat.

PRODUCTION STACK • VERIFIED

Technology Architecture Matrix

Frontend & Runtime
  • Next.js 16
  • Tailwind CSS
  • Server-Side Proxy Layout Guards
  • Lucide Icons
  • Real-Time Tracking Timeline
DB & Concurrency
  • Supabase PostgreSQL
  • 7-Tier Row Level Security
  • Atomic Stock Decrement Triggers
  • Isolated Repair Parts DB
  • Customer Lifetime Value RPC (get_customer_metrics)
AI & Realtime
  • Gemini AI Support Intercom
  • Knowledge Base FAQ Grounding
  • WebSocket Staff Escalation
  • Channel Alert Dispatch (needs_attention)
Payments & Protocols
  • Paystack Gateway (NGN ₦)
  • Idempotent Webhook Verification
  • Resend SMTP
  • Nominatim OpenStreetMap Geocoding
  • Multi-Channel Broadcast (Email, SMS, WhatsApp)
Previous Case Study
Joebrown Palace Hotel & Suites
Commission an Enterprise Platform
Next Case Study
Wetaego