A simple fullstack form that collects email addresses for the NYU workshop. Built with Hono + Hono JSX on the server, Twind for styling, and Val Town SQLite for storage.

• GET / — renders the email collection form
• POST /submit — validates the email and inserts it into SQLite
• GET /count — returns { count } of total stored emails (JSON)
• GET /source — redirects to the val source on Val Town

Rendering mermaid diagram...

• main.tsx — HTTP entrypoint, re-exports app.fetch
• server/app.tsx — Hono app with all routes, uses Hono JSX to render pages
• database/migrations.ts — creates the workshop_emails_v1 table
• database/queries.ts — addEmail() and getEmailCount() helpers
• frontend/Layout.tsx — shared HTML shell (Twind + catch script)
• frontend/EmailForm.tsx — the form UI with optional error state
• frontend/SuccessPage.tsx — confirmation page after submit

CREATE TABLE workshop_emails_v1 (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  email TEXT NOT NULL UNIQUE,
  created_at TEXT NOT NULL DEFAULT (datetime('now'))
);

Emails are normalized to lowercase and trimmed before being stored. Duplicate submissions are silently treated as success thanks to the UNIQUE constraint.