Coffee Roastery Dashboard

Build a full-stack dashboard for managing coffee bean inventory, roast profiles, and orders with CRUD operations, filtering, and data visualization.

Overview

Create a data management application with a real database. Users can browse coffee beans, filter by origin/roast level, view detailed profiles, and manage inventory. This project tests your full-stack fundamentals: database schema design, API routes, and interactive table UI.

The Coffee Roastery Dashboard is a domain-rich CRUD application that goes beyond the typical todo app or blog. The coffee domain provides natural complexity: beans have origins, varieties, altitude, processing methods, and flavor note arrays. Roast profiles track temperature curves over time. Orders have a status lifecycle from pending through shipped to delivered. This richness tests your ability to model real-world data accurately.

On the technical side, this project exercises every layer of the full-stack: PostgreSQL schema design with proper relationships and constraints, type-safe API routes using Drizzle ORM, server-side pagination and filtering via query parameters, interactive data tables with sorting and column-specific filters, and Docker containerization for reproducible setup. These are the exact skills that evaluators test in take-home assignments.

What makes this project particularly strong for interviews is the data modeling conversation it enables. You can discuss why TEXT[] arrays are appropriate for flavor notes, when to use composite indexes, how to prevent overselling with atomic SQL updates, and the trade-offs between offset and cursor-based pagination. These are senior-level database topics that demonstrate depth beyond basic CRUD.

Interview questions

  • What should the database schema look like?
  • How do I build the interactive table?
  • What makes a take-home submission stand out?
  • How should I structure the Next.js routes?
  • How do I handle concurrent stock updates safely?
  • Why use Drizzle ORM instead of Prisma?

Sign up free to read the full topic

More Projects topics

Start free on Cariara · Coding problems · System design studio