app_revisions
1 row
This data as json, CSV (advanced)
| Link | app_id | version | actor_id | name | description | html | is_private | sql_databases | stored_queries | csp_origins | changed_fields | created_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01kwjk7289pmy4h2xrkpct13y5,1 | 01kwjk7289pmy4h2xrkpct13y5 | 1 | root | A Candid World | <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>A Candid World: The Declaration at 250</title> <style> :root{ --bg:#FBF7EF; --card:#FFFDF7; --ink:#26251F; --muted:#6E6A5E; --navy:#3C3B6E; --red:#B22234; --tabbar:#F1EADB; --line:rgba(60,59,110,0.16); --line-strong:rgba(60,59,110,0.25); --chip-bg:rgba(60,59,110,0.09); --chip-line:rgba(60,59,110,0.18); --serif:Georgia,'Times New Roman',serif; --sans:system-ui,'Segoe UI',Helvetica,Arial,sans-serif; } html,body{margin:0;padding:0;background:var(--bg);} *{box-sizing:border-box;} body{color:var(--ink);font-family:var(--sans);} input,select,button{font:inherit;} .paper{position:fixed;inset:0;pointer-events:none;z-index:0; background-image:repeating-linear-gradient(0deg, rgba(60,59,110,0.022) 0px, rgba(60,59,110,0.022) 1px, transparent 1px, transparent 4px), repeating-linear-gradient(90deg, rgba(178,34,52,0.012) 0px, rgba(178,34,52,0.012) 1px, transparent 1px, transparent 7px);} .shell{position:relative;z-index:1;max-width:820px;margin:0 auto;padding:40px 20px 72px;} header.hd{text-align:center;display:flex;flex-direction:column;align-items:center;gap:14px;margin-bottom:28px;} .badge{display:inline-flex;align-items:center;gap:8px;background:var(--navy);color:var(--bg); border-radius:999px;padding:6px 16px;font-size:11px;font-weight:600;letter-spacing:.14em;} .badge span.st{color:#fff;font-size:10px;} h1{margin:0;font-family:var(--serif);font-weight:400;font-size:clamp(36px,7vw,52px);line-height:1.05;color:var(--ink);letter-spacing:-.01em;} .gloss{margin:0;max-width:560px;font-family:var(--serif);font-style:italic;font-size:15px;line-height:1.55;color:var(--muted);} .gloss b{font-style:normal;font-weight:700;color:var(--navy);} .subtitle{margin:0;font-size:14px;color:var(--muted);} .rule{display:flex;align-items:center;gap:10px;color:var(--red);font-size:11px;letter-s… | 0 | ["declaration250"] | [] | [] | ["name", "description", "html", "is_private", "sql_databases", "stored_queries", "csp_origins"] | 2026-07-02T23:39:22.249956+00:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE app_revisions (
app_id TEXT NOT NULL REFERENCES apps(id),
version INTEGER NOT NULL,
actor_id TEXT,
name TEXT,
description TEXT,
html TEXT,
is_private INTEGER,
sql_databases TEXT,
stored_queries TEXT,
csp_origins TEXT,
changed_fields TEXT NOT NULL DEFAULT '[]',
created_at TEXT NOT NULL,
PRIMARY KEY (app_id, version),
CHECK (is_private IN (0, 1) OR is_private IS NULL)
);