Skip to content
Hoshinfo
All projects

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
Hoshikopi home page in the Night palette
Home after 6 PM Manila time, in the Night palette.

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

  1. 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.

  2. 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

  3. 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

Hoshikopi home page in the Day palette
The same home page by day: the palette follows the cafe's clock.
Coffee section of the Hoshikopi menu
The menu, with prices from the server and Barista Pick badges.
Hoshi Latte with size, milk, sugar and ice choices
Build a drink: every choice and its price change is checked again at checkout.
Hoshikopi events page
Events with sign-ups, plus the weekly ones that need no booking.
Hoshikopi visit page with hours and amenities
Hours, directions and amenities for planning a visit.

On a phone

Hoshi Latte page on a phone
A drink page on a phone.
Hoshikopi home page on a phone
Home on a phone.
Next projectHoshimono