Self-hosted, Self-Improving, Federated Everything App — dev management, agent orchestration, persistent mind, digital twin, second brain, and creative pipeline from a single dashboard over Tailscale to port the user into the OS
JavaScript ai-agentsdashboarddeveloper-toolsdigital-twinquantified-selfsecond-brainself-hostedtailscale
// Decks (#decks): playing-card / tarot deck design projects. A deck row carries
// the style guide + sample references + render pins in `definition`; each card
// is its own row so a completed render attaches to ONE card without a
// read-modify-write of the whole deck. Rendered bytes live in the shared
// gallery (`data/images/`) and are referenced by filename from the card row.
//
// Decks FEDERATE (record kind `deck`, sync category `decks`) — the deck and its
// full card roster ride one push as a whole-record LWW unit, so a deck designed
// on one machine reaches the peers subscribed to it. The install-capability
// pins (`imageMode` / `imageModelId` / `promptLlm`) and each card's in-flight
// `render` job state stay machine-local (stripped by syncWire's `deck` case).
// Because a delete must propagate, the deck row carries the soft-delete
// tombstone pair the LWW merge needs — a hard delete never reaches a peer.
export const decksDdl = [
`CREATE TABLE IF NOT EXISTS decks (
id UUID PRIMARY KEY,
name TEXT NOT NULL,
kind TEXT NOT NULL CHECK (kind IN ('playing', 'tarot')),
universe_id TEXT,
definition JSONB NOT NULL DEFAULT '{}'::jsonb,
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
deleted BOOLEAN NOT NULL DEFAULT FALSE,
deleted_at TIMESTAMPTZ
)`,
// Idempotent upgrade for installs whose decks table predates federation.
`ALTER TABLE decks ADD COLUMN IF NOT EXISTS deleted BOOLEAN NOT NULL DEFAULT FALSE`,
`ALTER TABLE decks ADD COLUMN IF NOT EXISTS deleted_at TIMESTAMPTZ`,
`CREATE TABLE IF NOT EXISTS deck_cards (
id UUID PRIMARY KEY,
deck_id UUID NOT NULL REFERENCES decks (id) ON DELETE CASCADE,
position INTEGER NOT NULL,
key TEXT NOT NULL,
definition JSONB NOT NULL DEFAULT '{}'::jsonb,
updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
UNIQUE (deck_id, key)
)`,
`CREATE INDEX IF NOT EXISTS idx_deck_cards_deck ON deck_cards (deck_id, position)`,
`CREATE INDEX IF NOT EXISTS idx_decks_deleted ON decks (deleted, updated_at DESC)`,
];