Skip to content
olsonjjPublic

About

A test of GLM5.3 flash to see if it can one-shot a Kanban board tool

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

2 Commits

Folders and files

Repository files navigation

like-trello

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
Board view — lists, cards, due-date badges, checklist progress
Boards dashboard
Boards dashboard

Features

  • 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)

Run it

npm install
npm run dev        # → http://localhost:3000

The database is created and seeded automatically at .data/trello.db on first start.

Production build

npm run build      # vite build → dist/client + dist/server
npm run start      # serves the built app via srvx

Tests

npm test          # vitest, single run
npm run test:watch
  • src/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.

Stack

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)

Project layout

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

Data model

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().

About

A test of GLM5.3 flash to see if it can one-shot a Kanban board tool

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages