Hoshikopi
A concept cafe with order-ahead pickup and a Stars loyalty card.
The full website of an invented cafe: the menu, ordering ahead for a pickup time, Stars, events and a Bar Screen for the baristas. It is a portfolio piece, so the cafe is labelled as a concept and payments run in PayMongo test mode.
- Next.js 16
- TypeScript
- PostgreSQL
- Prisma 7
- Tailwind CSS 4
- Vitest
- Playwright
- Vercel

What it does
- Order ahead: pick a size, milk and add-ons, then a 15-minute pickup window.
- Pickup windows fill up, and two people can never book the last slot.
- Stars loyalty: a Star for every drink, rewards to spend, and a birthday treat.
- Events with seat sign-ups and an add-to-calendar file.
- A Bar Screen for baristas that refreshes on its own as orders move.
- Staff sign in with a second factor, and the manager gets sales reports.
How it is built
- The server prices everything
- Money is whole centavos, never floats. The cart and checkout recompute every price, so a changed number in the browser does nothing.
- One door for order status
- Every status change goes through a single transition function and a table of allowed moves. Payment status only comes from verified webhooks.
- Capacity under a row lock
- Placing an order locks the pickup window's row in Postgres, so the last slot cannot be sold twice.
- Prerendered, refreshed by tag
- Public pages are static and refresh when the menu, hours or content change, using Next.js 16 Cache Components.
- Tested against a real database
- 193 Vitest tests run against a Postgres test database, and 194 Playwright tests drive a real browser. 14 decision records explain the choices.
How it fits together
People who use it
Customers
Browse the menu, order ahead for a pickup time and collect Stars, on a phone or laptop.
Baristas
See new orders on a tablet behind the counter. The screen updates by itself.
Managers
Change the menu, opening hours and events, and see the sales.
The website
The Hoshikopi website
One website that shows the menu, takes the orders and keeps everyone's Stars. Its pages are prepared ahead of time, so they open fast.
Built with Next.js 16 · Vercel
What the website relies on
Database
Keeps the menu, every order, the pickup times and the Stars.
Built with PostgreSQL on Neon
Online payments
Takes payments in test mode, so no real money changes hands.
Built with PayMongo
Email
Sends order updates and sign-in links.
Built with Resend
Photo storage
Holds the photos of drinks, events and news posts.
Built with Vercel Blob
A closer look





On a phone

