# Template: kanban (persistent Next.js + Mongo board)

A real, deployable kanban board. Cards live in the grid-shared MongoDB, so they
survive refresh and are shared across sessions. Same proven shape as
`app-with-data`, adapted to a `cards` domain (title, column, order) with three
columns and move-between-columns.

**Key rules (all proven by the app-with-data end-to-end deploy):**

1. **Service code MUST live under `services/<name>/`, not the repo/template
   root.** `path:` in `cloudgrid.yaml` is the URL mount, NOT the filesystem path.
   The service named `web` → the CLI looks for `services/web/`. App files at the
   root fail with `Error: Service directory not found: …/services/web`.
2. **Read the DB connection string LAZILY (inside the getter), never at module
   top level.** The grid injects it as `DATABASE_MONGODB_URL` (plus the legacy
   `MONGODB_URL` alias) at dev-time and runtime; the app reads
   `process.env.DATABASE_MONGODB_URL || process.env.MONGODB_URL` inside `getDb`.
   A top-level read fails `next build`. Never hardcode a connection string; never
   commit a secret.
3. **Declare the datastore with `needs: { database: true }`.** The deployer
   provisions Mongo and injects the connection string. `requires:` is the
   deprecated v1 alias; don't author new yaml with it, and never set `needs:` and
   `requires:` together (the validator rejects the combination).

## File tree

```
cloudgrid.yaml                         # name + services.web (nextjs) + needs: { database: true }
services/web/package.json              # next, react, react-dom, mongodb driver only
services/web/lib/db.js                 # lazy Mongo client from DATABASE_MONGODB_URL (legacy MONGODB_URL fallback)
services/web/app/layout.js             # root layout + inline CSS
services/web/app/page.js               # server component: reads cards from Mongo
services/web/app/board.js              # client board: POST / PATCH (move column) / DELETE via the API
services/web/app/api/cards/route.js    # GET (list) / POST (add) / PATCH (move) / DELETE (remove)
```

## cloudgrid.yaml

```yaml
# On disk this file is the full-annotated reference (templates/_cloudgrid.yaml.reference) with EVERY
# field present as a comment; only the fields below are uncommented, so it
# deploys to exactly these active fields.
name: my-board
services:
  web:
    type: nextjs
    path: /
needs:
  database: true
```

> **Capability:** this template's need is `database: true`. The deployer
> provisions Mongo and injects `DATABASE_MONGODB_URL` (plus the legacy
> `MONGODB_URL` alias). `requires:` is the deprecated v1 alias — don't mix it with
> `needs:` (the validator rejects the combination). See the capability-map for
> the full injection table.

## The cards collection

Documents: `{ title, column, order, createdAt }` where `column` is one of `todo`
/ `doing` / `done`. The API route on `cards` does GET (list, ordered), POST
(add to `todo`), PATCH (move to another column), DELETE (remove); the page is a
server component that reads the collection and hands it to a client board.

## Adapt it

- Rename the `cards` collection to your data.
- Change the columns (edit the `COLUMNS` array) or add fields (assignee, labels).
- Add drag-and-drop or per-column ordering on top of the `order` field.
- Add `cache: true` to `needs:` only if you actually need Redis.
- Run `grid dev` to test locally, `grid plug` to deploy (async — poll to live).