# LastDB

> Build for your happiness. On a foundation you own.
>
> LastDB is a local database you build your own tool stack on
> (Brain, Kanban, Situations, LastSecrets, Search, agent skills, and the apps you write —
> tools on one foundation you own, not SaaS silos). Deliver slices of your
> database to others.
>
> Local use needs no account. Optional cloud backup/sync joins an account for
> multi-device (`lastdb connect`).

Website: https://thelastdb.com
Pages are prerendered at build time so agents and curl can read them without executing JavaScript.

## Install (macOS Apple Silicon)

Needs Homebrew and Bun (https://bun.sh). Apple Silicon only.

Paste-safe for macOS zsh: the bash blocks below have **no `#` comment lines**.
Default interactive zsh has `interactivecomments` off, so pasting `# 0) …`
yields `parse error near ')'` / `command not found: #`. Put notes in markdown
prose, not inside the fence. Skip the Bun line if `bun --version` already works.

```bash
curl -fsSL https://bun.sh/install | bash
export PATH="$HOME/.bun/bin:$HOME/.local/bin:$PATH"

git clone https://github.com/EdgeVector/last-stack ~/.last-stack
~/.last-stack/setup
~/.last-stack/bin/last-stack-install-apps

brew services start lastdb
brain init --grant-consent
kanban init
situations init
lastsecrets init
org init
search init

curl -s --unix-socket ~/.lastdb/data/folddb.sock http://localhost/health
```

Health path is `/health` (not `/api/health`). Expect `{"status":"ok"}`.

Database only:

```bash
brew install edgevector/lastdb/lastdb
brew services start lastdb
```

LastSecrets only (after LastDB is running):

```bash
git clone https://github.com/EdgeVector/lastsecrets && cd lastsecrets
bun install && bun link
lastsecrets init
```

Org only (after LastDB + LastSecrets; share orgs via public-key invite).
After init: `org create friends --name "Friends"`; invite path is
https://github.com/EdgeVector/org/blob/main/docs/INVITE.md
(friend: `org receive` → you: `org invite friends --to 'orgpk1:…' --agent` →
friend: `org join --sealed 'orgseal1:…'`).

```bash
git clone https://github.com/EdgeVector/org && cd org
bun install && bun link
org init
```

Search only (semantic plane for brain/kanban ask/search; after LastDB is running):

```bash
git clone https://github.com/EdgeVector/search && cd search
bun install
ln -snf "$PWD/bin/search" ~/.local/bin/search
search init
```

## Kanban Factory (optional animated board UI)

Local theater for your real Kanban board: cards hop between lanes, routines show
as a crew, heartbeats tick in the factory log. Read-mostly; runs on loopback
only. Needs `kanban` on PATH (from `last-stack-install-apps`) and Node 18+.

`last-stack-install-apps` also clones this under `~/lastdb-apps/kanban-factory`
when the public GitHub repo is reachable.

Standalone (after kanban init works). Serves http://127.0.0.1:4177.

```bash
git clone https://github.com/EdgeVector/kanban-factory.git \
  ~/.local/share/edgevector/kanban-factory
cd ~/.local/share/edgevector/kanban-factory
node server.mjs
```

macOS auto-start on login:

```bash
./scripts/install-launchd.sh install
open http://127.0.0.1:4177
```

Source: https://github.com/EdgeVector/kanban-factory

## Mental model

- **LastDB** — the database (Homebrew service `lastdb`, daemon `lastdbd`)
- **Apps** — tools that talk to it (`brain`, `kanban`, `situations`, `lastsecrets`, `org`, `search`, …)
- **Org** — separate app for shared org membership + named DBs; keys via LastSecrets
- **Kanban Factory** — optional local animated UI over your board (not a second database)
- **The Last Stack** — installer + agent skills (not a second database)

Socket: `~/.lastdb/data/folddb.sock` (Unix socket; TCP :9001 is retired)

## Quick try after install

Semantic ask may lag a few seconds after create; use a term from the body.
`brain get` is immediate. LastSecrets: never put raw secret values on the command line;
list/search always print `value=<redacted>`.

```bash
kanban list
brain concept new hello --title "Hello" --body "my first note"
brain get hello
brain ask "first note"

printf '%s' "$TOKEN" | lastsecrets put my-api-token \
  --label "My API token" \
  --provider example \
  --purpose demo \
  --env dev \
  --value-stdin
lastsecrets ref my-api-token
lastsecrets list

org create friends --name "Friends"
org list
```

`lastsecrets ref` prints a `lastsecrets://…` locator. Org invite path: docs/INVITE.md on the org repo.

## Secrets policy (agents)

- Store with `lastsecrets put <slug> … --value-stdin` (value on stdin only).
- Persist only `lastsecrets://<slug>` locators in Brain, Kanban, docs, CI, and logs.
- Retrieve with `lastsecrets get <slug>` only at the point of use; do not print or re-store the value.
- If LastSecrets is unavailable, stop before handling raw secret material.

## App readiness (ranked high → low; judgment, not SLAs)

Whole stack is product alpha. Stages: Alpha · Dogfood · Early.

| Rank | App | Stage | ~% |
|------|-----|--------|-----|
| 01 | Brain | Alpha | ~75 |
| 02 | LastDB | Alpha | ~70 |
| 03 | Kanban | Alpha | ~70 |
| 04 | Last Stack | Dogfood | ~60 |
| 05 | Situations | Dogfood | ~55 |
| 06 | Search | Dogfood | ~50 |
| 07 | LastSecrets | Dogfood | ~50 |
| 08 | Org | Dogfood | ~50 |
| 09 | Dogfood Graph | Dogfood | ~45 |
| 10 | Kanban Factory | Dogfood | ~45 |
| 11 | Routines | Early | ~35 |
| 12 | LastGit | Early | ~30 |
| 13 | CodeRings | Early | ~25 |
| 14 | Discovery | Early | ~25 |

First try: ranks 01–03; use Search (#06) for semantic ask/search; LastSecrets (#07) for credentials;
Org (#08) for invite/join shared orgs (pubkey seal — no Exemem account required for join).
Optional eye candy after the board works: Kanban Factory (#10).
Full notes: https://thelastdb.com/apps#readiness

## Key pages

- https://thelastdb.com/ — what it is + install
- https://thelastdb.com/apps — what each app does + readiness
- https://thelastdb.com/start — daily loop + agent MCP/skills
- https://thelastdb.com/about — product thesis
- https://thelastdb.com/developer — socket API for builders
- https://thelastdb.com/docs — stable docs index
- https://thelastdb.com/docs/install — install and version checks
- https://thelastdb.com/docs/daily-loop — Brain/Kanban daily loop
- https://thelastdb.com/docs/node-health — node health and socket checks
- https://thelastdb.com/blog — engineering writing
- https://github.com/EdgeVector/lastsecrets — LastSecrets public source
- https://github.com/EdgeVector/org — Org public source (shared org membership + invite/join)
- https://github.com/EdgeVector/org/blob/main/docs/INVITE.md — Org invite handshake
- https://github.com/EdgeVector/search — Search public source (semantic MiniLM plane)
- https://github.com/EdgeVector/kanban-factory — Kanban Factory (animated local board theater)