Coffee Archive v1.0

Overview

coffee-archive-copilot turns scattered coffee notes into structured archive cards. Each entry can hold bean details, roaster notes, opening notes, what lingered, café or place context, collections, and interpretation fields.

The project is based on a simple idea:

Archive is infrastructure.
Interpretation is the product.
Learning is the outcome.

Capture → Archive → Revisit → Interpret

V1.0 addresses the infrastructure layer by preserving the coffee experience first, then leaving room for interpretation to happen later.

The Problem:

Coffee experiences are surprisingly difficult to keep track of over time:

cafés don't always provide tasting slips or detailed coffee information
notes end up scattered across photos, screenshots, notebooks, and messages
individual coffees are easy to remember, but comparisons across many cups are difficult
the more coffees you try, the harder it becomes to remember what you actually liked and why

So the digital archive gives those experiences a consistent structure that can be searched and revisited later.

What this App does:

captures coffee experiences as structured archive cards
records bean details, roaster notes, opening notes, and what lingered
stores café, place, date, process, origin, and variety metadata
supports entry creation, editing, and detail views
organizes entries through collections
displays collection chips on archive cards
supports search, filtering, and sorting
includes select mode and delete-selected workflow
runs as a private deployed web app

Screenshots:

Archive Homepage

Searchable archive homepage with filters, collection chips, and archive card count.

Entry Detail Page

Structured entry page for reviewing bean details, tasting notes, context, and collections.

Entry Entry Page

Edit form for updating coffee notes, metadata, collections, and interpretation fields.

Future Work

Planned improvements include:

Build v2.0 will add a media layer and tagging workflow.
Build v3.0 will add an interpretation layer on top of the archive.

Current Tech Stack

Built with AI-assisted development using Codex, with a Next.js / TypeScript frontend and PostgreSQL backend accessed through Prisma 7 and the PrismaPg adapter.

Frontend: Next.js, TypeScript, Tailwind CSS
Backend / data: PostgreSQL + Prisma 7
Deployment: Vercel
Access: private web app protected by username/password authentication
Development: AI-assisted coding workflow with Codex

The archive is designed to be used wherever the coffee experience happens. The responsive interface works across desktop and mobile, allowing entries to be created, edited, or deleted from a phone as well as a computer.