🍺 Brewing Journal

Personal homebrewing journal: recipes, brew sessions, problems and lessons learned — so each batch learns from the last one. See PLAN.md for the full product plan.

Phases 1–3 are implemented:

• Ingredients — type-specific specs (color/potential, alpha acid, attenuation), search, archive instead of delete once used
• Equipment profiles — boil-off, losses, efficiency; drives the estimated pre-boil volume
• Recipes — ingredient list with stages and addition times, multi-step mash, water, targets (OG/FG/IBU/SRM/CO2, ABV calculated). Editing a recipe that has been brewed creates a new version, and each version snapshots ingredient specs, so old brews never change
• Brew sessions — "Brew Again" from a recipe or "Clone this brew"; target vs actual, status, planned vs actual ingredient amounts and substitutions
• 7 brew steps — targets pulled from the recipe, quick-entry readings, custom measurements, notes, problems, complete/reopen, and the same step from the previous batch side by side
• Fermentation daily log, packaging method
• Problems & lessons — cause/action/impact, lessons linked to a problem or standalone, search across everything
• Validation — FG must be below OG; warnings when OG/FG, mash temp or pH drift from target, with one-tap "Log as problem"
• Fermentation charts — gravity (with target FG), temperature and pH by day, overlaid with the previous batch; hover/keyboard tooltips and a data-table fallback
• pH through the brew — every pH reading from water prep to fermentation, flagged against the target mash pH
• Compare brews — up to 4 batches side by side: overview, every step reading, ingredient amounts, problems, and overlaid fermentation curves; "only differences" toggle
• Recipe scaling — preview a new batch size, then save as a new version or a new recipe
• Search across problems, lessons and notes — every word must match, "quoted phrases", highlights, works for Thai
• Calculators — estimated OG/FG/ABV (grain potential × efficiency; kettle sugars and unfermentable lactose handled), IBU (Tinseth), SRM (Morey), water ions in ppm from brewing salts, actual brewhouse efficiency, priming sugar. Live in the recipe editor too
• Inventory & cost — stock ledger per ingredient (purchases, stock counts, brew deductions with undo), weighted-average cost, batch cost and cost per litre, "enough in stock?" check on every recipe
• Photos on any brew step — resized in the browser, stored in Postgres (no external storage)
• Export — CSV of all brews or one brew's full record (Excel-friendly UTF-8), and a printable report you can save as PDF (renders Thai correctly)
• Recipe sheet export — a print-ready A4 recipe sheet (malts, yeast, hop totals, water and strike temperature, mash & boil schedule, fermentation plan, kegging guide and serving-pressure table) with a live preview: pick the version, scale the batch, Thai + English / Thai / English, a brew-day style with checkboxes and blanks for readings, and real dates from a brew date. Also downloads a recipe file (.json) and shares it to LINE on phones. Options are remembered
• Recipe import — drop a PDF, a recipe file or paste text (Thai or English). Sheets exported by this app carry a recipe code (and a QR code that opens the import screen), so they import exactly; other PDFs and text are parsed and every guess (ranges, alternatives, hop totals that don't add up, OG/IBU that don't match the ingredients) is listed for review in the normal editor. Re-importing a recipe you already have can save as its next version
• New ingredients popup — saving any recipe that would create ingredients first lists them: fix the name, pick a similar existing ingredient instead, and record how much you already have. Also shows what's short in stock
• Fermentation plan — steps per recipe version (primary, dry hop, cold crash…) with quick-add buttons; shown on the recipe, the brew's fermentation step and the printed sheet
• Brew-day equipment checklist — ten steps from sanitising to kegging; tap an item to cycle have it ✓ / missing ! / not used –, with a sticky progress bar, a "get these first" list you can copy, and "start a new batch" to clear the ticks. Items can carry an amount needed (e.g. 3 bottles); a missing one asks how many are short and the shopping list shows it. Each section's "all here" button turns into "uncheck all" once everything in it is ticked. Sections fold away with a tap on their heading (or all at once), remembered across devices; a folded section still shows how many of its items are missing. A second tab adds, edits, deletes and reorders sections and items (moving an item past its section's edge moves it to the next section), and backs up or imports the list as JSON
• Thai / English UI — ไทย/EN switch in the top bar (remembered in a cookie; first visit follows the browser language). Dates show in the Thai calendar in Thai. Brewing abbreviations (OG, FG, ABV, IBU, SRM, pH) and units stay as they are
• Mobile bottom nav, installable web app manifest

Stack

Next.js 16 (App Router, Server Actions) · React 19 · TypeScript · Tailwind CSS 4 · PostgreSQL · Prisma 7 · Vitest

Getting started

cp .env.example .env
docker compose up -d          # Postgres on localhost:5432 (or point DATABASE_URL at your own)
npm install                   # also runs `prisma generate`
npm run db:migrate            # create tables
npm run db:seed               # optional: Sweet Stout recipe + brew #001 + starter ingredients
npm run dev                   # http://localhost:3000

Script
npm run dev / build / start	Next.js
npm run typecheck	Route type generation + tsc
npm run lint	ESLint
npm test	Unit tests (brewing math, calculators, inventory, CSV, scaling, search)
npm run db:migrate	Create/apply a migration in development
npm run db:deploy	Apply migrations in production
npm run db:seed	Seed sample data (skipped if the DB already has data)

Starter ingredients (166 malts, hops, yeasts, water salts and additives from the Thai shops WAS Homebrew and Craft Components) live in src/lib/catalog-data.ts. The seed adds them, and on an existing database the Ingredients page offers an Add them button that adds only the ones you don't have yet.

Deploying

There is no login (single-user): anyone who has the app's address can see and change everything. Keep the address private, or put it behind your host's own access protection (e.g. Vercel Deployment Protection).

Vercel + Supabase:

Vercel env var	Value
DATABASE_URL	Supabase transaction pooler URL (port 6543) — used by the app
DIRECT_URL	Supabase session pooler URL (port 5432) — used by migrations

If you connect Supabase through Vercel's Supabase integration instead, nothing needs copying: the app also reads the integration's POSTGRES_PRISMA_URL / POSTGRES_URL (app) and POSTGRES_URL_NON_POOLING (migrations), and treats their sslmode=require as "encrypted, certificate not verified" like psql does.

Supabase's direct host (db.<ref>.supabase.co) is IPv6-only and unreachable from Vercel. When the migration URL points there, migrations use the session pooler instead (the pooled URL's host and user on port 5432), so a P1001 "Can't reach database server at db.….supabase.co" no longer happens.

Set the Build Command to prisma migrate deploy && next build so each deploy applies new migrations first (a failed migration fails the deploy and the previous version stays live). Set the function region to Singapore (sin1) to sit next to the database, and turn off Supabase's Data API — the app doesn't use it.

Layout

prisma/schema.prisma        data model (see PLAN.md §25)
src/lib/brewing.ts          step definitions, formatting, ABV/volume math, validation
src/app/ingredients         ingredient master
src/app/equipment           equipment profiles
src/app/recipes             recipe list/detail/editor + versioning actions
src/app/brews               sessions, steps, problems, lessons (actions.ts has all mutations)
src/app/compare             side-by-side brew comparison
src/app/lessons             knowledge-base search (problems, lessons, notes)
src/components/line-chart   dependency-free SVG line chart
src/lib/search.ts           query parsing, filters, highlighting
src/lib/calc.ts             IBU/SRM/OG/FG, water profile, efficiency, priming sugar
src/lib/inventory.ts        stock ledger math and costing
src/lib/i18n                translations: English text is the key, th.ts has the Thai;
                            getI18n() on the server, useI18n() in client components
src/app/inventory           inventory page, stock card, inventory actions

Adding text

Wrap UI text in t("…") (server: const { t } = await getI18n(), client: useI18n()), with {placeholders} for values, and add the Thai to src/lib/i18n/th.ts. npm test fails if a string in the source has no Thai translation or a translation drops a placeholder.