CASE STUDY · FULL-STACK OPERATIONS

Event Check-in &
Operations System

A field-ready workflow connecting QR check-in, attendee lookup, live attendance and seating metrics, on-site registration, operational filtering, and CSV export.

Open privacy-safe demo ↗

The production repository and database remain private. The public demo uses synthetic data and exposes no persistent write access.

01 / Verified scope

Product facts are derived from the implemented workflow without exposing production attendees.

30sautomatic admin dashboard refresh
5search, school, department, check-in and seating filters
2registered and on-site attendee sources
CSVexport of the currently filtered operations view

The public demo contains 24 fully synthetic records. That number describes the demo only, not the production event.

02 / User flow

From a QR token to an operations dashboard.

AttendeeQR token, identity and assigned seat
Check-in UIscan, confirmation and status response
Next.js APIattendee routes, admin actions and authorization
D1 + Drizzleattendance, seating and timestamp records

03 / Operations

Live DashboardTotal, checked-in, seated, walk-in and latest check-in metrics.
Field FiltersLocate people by name, ID, institution, department and operational status.
On-site HandlingThe private admin supports walk-in creation, seat changes and seating-state updates.
Operational ExportExport the current filtered view as UTF-8 CSV for handoff and reporting.

04 / Privacy design

Public presentation is separated from production operations.

  • The production repository stays private; attendee tokens, names, institutions, seats and admin credentials are never published.
  • The public demo removes the original event logo, phone number and institutional identity.
  • The public admin view is read-only; scan simulation changes browser memory only and resets on refresh.
  • The portfolio does not connect to the production database or expose writable administration endpoints.

05 / Public demo

An interactive product surface, not only a static screenshot.

Privacy-safe public demo of the event check-in and operations system
Captured during the site build by opening the public demo in Chromium. Every person, organization, seat and token is synthetic.
Try the demo ↗

06 / Takeaway

The value of a full-stack product is the operational workflow.

This project connects attendee and staff experiences with APIs, storage, filters, exception handling and export instead of stopping at a QR component.