Case Study - Turning pickup chaos into calm flow

Overview

The project began with a familiar operational bottleneck: student pickup is simple in theory, but chaotic in practice when multiple campuses, shared car numbers, role-based staff responsibilities, and peak-time traffic all collide at once. The application was clearly shaped to solve that pressure point, replacing ad hoc coordination with a structured flow for allocation, dispatch, and live queue visibility.

The technical approach favors responsiveness over ceremony. Next.js and React power the interface, while Convex handles the backend state, live queries, mutations, and historical records that make the queue feel immediate rather than transactional. Clerk provides authentication, and the permission model is layered enough to support superadmins, principals, operators, allocators, dispatchers, and viewers without fragmenting the experience. On top of that, next-intl gives the product a bilingual surface for teams working in English and Spanish.

One of the most thoughtful implementation details is how operational data is shaped for speed. The active dismissal queue stores denormalized student summaries directly with each car entry, which keeps the live lane view fast and predictable during busy pickup windows. The system also rolls completed pickups into a historical table, validates wait-time quality for analytics, and runs a daily cron job that clears queues at midnight while preserving the operational history. Even small touches, like birthday-aware vehicle cards, show an attention to the human side of school operations.

What we did