A Trello-style kanban app built with TanStack Start (React 19 + Vite + SSR) and a local SQLite database (Node's built-in node:sqlite — zero native dependencies).
| Board view — lists, cards, due-date badges, checklist progress |
| Boards dashboard |
- Boards — create, rename, delete, pick a background color/gradient
- Lists — add, rename (click the title), delete, and drag to reorder
- Cards — add via composer, drag between lists and reorder within a list
- Card details modal — click any card:
- title editing
- description (with save button / ⌘+Enter)
- due date with color-coded badges (overdue = red, due soon = yellow, complete = green)
- checklist with progress bar, add / toggle / rename / delete items
- mark card complete (strikethrough)
- delete card
- Inline click-to-edit text everywhere (board title, list titles, checklist items)
npm install
npm run dev # → http://localhost:3000The database is created and seeded automatically at .data/trello.db on first start.
npm run build # vite build → dist/client + dist/server
npm run start # serves the built app via srvxnpm test # vitest, single run
npm run test:watchsrc/lib/position.test.ts— fractional ordering math (the core of drag & drop)src/lib/dates.test.ts— due-date badges, incl. timezone-invariance (hydration safety)src/server/store.test.ts— persistence contract: cascades, field updates, and a randomized 50-round drag simulation asserting positions never collide
Tests run against throwaway SQLite databases in the OS temp dir (TRELLO_DB_DIR),
never the real .data/trello.db.
| Layer | Tech |
|---|---|
| Framework | TanStack Start (@tanstack/react-start) |
| Routing | TanStack Router (file-based) |
| Data | Server functions (createServerFn) → store.ts |
| Database | node:sqlite (DatabaseSync), WAL mode |
| Testing | Vitest (unit + persistence) |
| Drag & drop | @dnd-kit/core + @dnd-kit/sortable |
| Styling | Plain CSS (src/styles.css) |
src/
├── routes/
│ ├── __root.tsx # HTML shell + styles
│ ├── index.tsx # boards dashboard
│ └── boards.$boardId.tsx # board view
├── components/
│ ├── BoardsHome.tsx # dashboard UI
│ ├── BoardView.tsx # board + DnD context + optimistic state
│ ├── ListColumn.tsx # sortable list column + card composer
│ ├── CardTile.tsx # sortable card tile + badges
│ ├── CardModal.tsx # card details (desc, due, checklist)
│ └── EditableText.tsx # click-to-edit text
├── server/
│ ├── db.ts # schema + seed (server-only)
│ └── api.ts # all server functions
├── lib/
│ ├── types.ts # shared types + board backgrounds
│ └── dates.ts # due-date badge logic
└── styles.css
boards → lists → cards → checklist_items, ordered with fractional REAL
positions (midpoint insertion), so reordering only ever touches one row.
All mutations go through typed server functions; the client applies optimistic
updates and reconciles via router.invalidate().