HennaHub-Full-Stack E-commerce & Booking Platform

The client — a henna art business in Bangladesh — had no digital presence. They were: Taking orders and bookings manually via phone/WhatsApp Unable to showcase artists, designs, and products professionally online Managing everything (inventory, orders, bookings, customers) manually with no system Missing out on customers who search online Had no way to receive instant order alerts when away from a computer

Key features

• Dynamic Homepage
• Full Product Experience
• Complete Purchase Flow
• 4-Step Appointment Booking
• Henna Design Showcase
• Professional Artist Showcase
• Intelligent Customer Assistant
• Public Notice Board
• Business Owner Showcase
• Admin Dashboard

Replaced a completely manual, phone-based operation with a fully automated, SEO-optimized e-commerce and booking platform manageable from a smartphone.

Built to a standard

• TypeScript
• Secure
• Accessible
• Tested
• Responsive
• CI/CD
• SEO optimised
• High performance
• Docker

1. Problem

   Traditional PostgreSQL TCP drivers don't work on Cloudflare Workers (V8 isolates, not Node.js).

   Solution

   Used Neon's serverless HTTP driver with Drizzle ORM, enabling full PostgreSQL queries from the edge without TCP connections.

2. Problem

   Gemini would invent fake prices, fake artist names, and fake packages when the database was empty or sparse.

   Solution

   Built a regex-based intent detection layer that pre-fetches only relevant DB records and injects them as the AI's sole source of truth, with a system prompt that explicitly forbids fabrication.

3. Problem

   On page load, the cart would flash empty then populate, sometimes wiping saved items due to localStorage write triggering before the read completed.

   Solution

   Added a useRef flag to gate the localStorage save effect until after the initial hydration read completed.

4. Problem

   Local machine had Telegram API blocked, making bot development and webhook registration impossible from the terminal.

   Solution

   Exposed a /telegram/setup endpoint on the deployed Cloudflare Worker itself, which registers the webhook from Cloudflare's network (unrestricted) in a single HTTP call.

5. Problem

   Keeping API request/response types in sync between the Hono backend and Next.js frontend without manual duplication.

   Solution

   Used Hono's RPC client (hc<AppType>) with shared Zod schemas in a packages/shared workspace, giving end-to-end TypeScript inference from database to browser.

6. Problem

   Next.js is designed for Node.js but Cloudflare Workers use V8 isolates with no Node.js runtime

   Solution

   Used @opennextjs/cloudflare adapter which transforms Next.js build output into a Cloudflare Workers-compatible format, enabling full SSR and API routes on the edge.