Project management

Tasks move through todo, doing and done on a board. Teams group the people, number sequences give each task a readable key, and watchers hear about status changes, comments and due dates.

TableCopy Anchor Link

create table public.tasks (
  id uuid primary key default gen_random_uuid(),
  organization_id uuid not null,
  title text not null,
  status text not null default 'todo',
  rank text collate "C" not null default 'V'
);
create index on public.tasks (organization_id, status, rank);
alter table public.tasks enable row level security;

ConfigCopy Anchor Link

The projects preset brings the SaaS blocks (organizations with teams, notifications, the outbox, ...) plus tags, comments, attachments, the state machine, rank, reminders and time tracking. Task keys add number-sequences, and the workflow is the state machine's options:

import { defineConfig } from "better-supabase/config";

export default defineConfig({
  preset: "projects",
  subjects: {
    task: {
      table: "public.tasks",
      idType: "uuid",
      title: "title",
      url: "/tasks/{id}",
      rank: { column: "rank", group: "status" },
    },
  },
  blocks: {
    "number-sequences": {},
    "state-machine": {
      options: {
        machines: {
          task: {
            table: "public.tasks",
            column: "status",
            initial: "todo",
            tenant: "organization_id",
            transitions: {
              todo: ["doing"],
              doing: ["todo", "done"],
              done: ["doing"],
            },
          },
        },
      },
    },
  },
});

Event flowCopy Anchor Link

status.changed carries the previous status in from and the reason, so a notification can say "moved back to todo: blocked". Every change also writes a status_history row. A reminder delivers once per occurrence: a second deliver for the same occurrence returns false and notifies no one.

With ReUICopy Anchor Link

• Kanban for the status board, calling rank.move on drop.
• Data Grid for the task list, with Filters on a defineListQuery.
• Gantt when tasks get dates; rank keys keep the row order.
• Stepper for the workflow on the task page, from the machine's transitions.

ReUI's Tempo template shows a full task product on these components. The Pro blocks are licensed per user, so copy them from reui.io.