apps

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ external name description path source metadata actor_id is_private stored_queries current_version deleted_at deleted_actor_id created_at updated_at
01kwjk7289pmy4h2xrkpct13y5 0 A Candid World   /-/apps/01kwjk7289pmy4h2xrkpct13y5 datasette-apps {} root 0 [] 1     2026-07-02T23:39:22.249956+00:00 2026-07-02T23:39:22.249956+00:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE apps (
    id TEXT PRIMARY KEY,
    external INTEGER NOT NULL DEFAULT 0,
    name TEXT NOT NULL,
    description TEXT NOT NULL DEFAULT '',
    path TEXT NOT NULL,
    source TEXT NOT NULL DEFAULT '',
    metadata TEXT NOT NULL DEFAULT '{}',
    actor_id TEXT,
    is_private INTEGER NOT NULL DEFAULT 1,
    stored_queries TEXT NOT NULL DEFAULT '[]',
    current_version INTEGER,
    deleted_at TEXT,
    deleted_actor_id TEXT,
    created_at TEXT NOT NULL,
    updated_at TEXT NOT NULL,
    CHECK (external IN (0, 1)),
    CHECK (is_private IN (0, 1))
);
CREATE INDEX idx_apps_updated ON apps(updated_at DESC, id);
CREATE INDEX idx_apps_external_updated ON apps(external, updated_at DESC, id);
CREATE INDEX idx_apps_source ON apps(source);