[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_113":114,"_115":116},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","pikachu","name","Quickstart-Full-Stack","path","frontend/pages/docs/page-sqlite.tsx","project",{"_22":50,"_11":12,"_35":51,"_52":-5,"_53":44,"_54":55,"_56":55,"_57":58,"_59":60,"_61":62,"_63":64,"_65":34,"_66":-5,"_67":-5,"_68":69,"_70":71,"_72":73,"_74":75,"_76":77,"_78":-5,"_79":80,"_81":80,"_82":83,"_84":83,"_85":83,"_86":80,"_87":80,"_88":89,"_90":91,"_92":93,"_94":44},"file",{"_22":23,"_11":24,"_25":26,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_13":46},"permalink","https://www.val.town/x/pikachu/Quickstart-Full-Stack/code/frontend/pages/docs/page-sqlite.tsx","extension","id","b5b72ad2-9b05-4910-b0cd-15eb7721ca14","page-sqlite.tsx","fileId","094c700a-4c96-11f1-a693-ee650bb23af1","parentId","39bb5a9c-a580-11f1-9bc5-1607ee4eb77e","branchId","5a0a7ac8-4895-11f1-80ec-42b51c65c3df","branchVersion",377,"latest",true,"createdAt",["D",1788212991403],"version",15,"fileType","script","content","/** @jsxImportSource https://esm.sh/react@19.2.0 */\n// page-sqlite.tsx — SQLite: live visit table + interactive demos.\n\nimport {\n Badge,\n Banner,\n Button,\n CodeBlock,\n Heading,\n HStack,\n Link,\n Table,\n TableBody,\n TableCell,\n TableHeader,\n TableHeaderCell,\n TableRow,\n Text,\n VStack,\n} from \"../../astryx/components.ts\";\nimport { PageLinks, PageShell, Panel } from \"../kit.tsx\";\nimport type { AppProps, CodeSnippet } from \"../../types.ts\";\n\nconst LINKS = [\n { href: \"https://docs.val.town/reference/std/sqlite/\", label: \"SQLite docs\" },\n { href: \"https://www.val.town/pricing\", label: \"Pricing\" },\n { href: \"https://www.val.town/limits\", label: \"Limits\" },\n];\n\nconst MIGRATE_SNIPPET: CodeSnippet = {\n filename: \"backend/db.ts — migrate()\",\n code: `// Each App gets its own isolated SQLite — no prefix needed.\nlet migrated = false;\n\nasync function migrate(): Promise {\n if (migrated) return; // run once per cold-start\n migrated = true;\n await sqlite.batch([\n \\`CREATE TABLE IF NOT EXISTS visits (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n path TEXT NOT NULL,\n ts TEXT NOT NULL DEFAULT (datetime('now'))\n )\\`,\n ]);\n}`,\n};\n\nconst QUERY_SNIPPET: CodeSnippet = {\n filename: \"backend/db.ts — queries\",\n code: `export async function recordVisit(path: string): Promise {\n await migrate();\n await sqlite.execute({\n sql: \"INSERT INTO visits (path) VALUES (?)\",\n args: [path],\n });\n}\n\nexport async function getRecentVisits(limit = 20) {\n await migrate();\n const { rows } = await sqlite.execute({\n sql: \"SELECT id, path, ts FROM visits ORDER BY ts DESC LIMIT ?\",\n args: [limit],\n });\n return rows.map(r => ({ id: r[0], path: r[1], ts: r[2] }));\n}`,\n};\n\nconst CONCEPT_ROWS: { concept: string; example: string; note: string }[] = [\n { concept: \"App\", example: \"val-town-quickstart\", note: \"One App = one isolated SQLite DB\" },\n {\n concept: \"Service\",\n example: \"index.http.ts, cron.ts, email.ts\",\n note: \"All services share the App's single DB\",\n },\n {\n concept: \"No prefix needed\",\n example: \"visits, cron_runs\",\n note: \"DB is isolated — plain table names are fine\",\n },\n];\n\nconst RULE_ROWS: { rule: string; reason: string }[] = [\n {\n rule: \"Lazy migrate\",\n reason: \"Run schema in first call, not at import — avoids errors off-platform\",\n },\n { rule: \"Parameterised\", reason: \"Always use args: [...] — never interpolate into SQL strings\" },\n {\n rule: \"Schema versioning\",\n reason: \"Rename tables (_v2) when changing columns — no ALTER needed\",\n },\n {\n rule: \"Blob ≠ SQLite\",\n reason: \"Blob is account-scoped (all your Apps share it) — SQLite is App-scoped\",\n },\n];\n\nexport function SqlitePage({ user }: AppProps) {\n return (\n \n \n SQLite\n \n Each App gets its own isolated SQLite database, shared by all its services (HTTP, Cron,\n Email). 10 MB free / 1 GB Pro, backed by Turso. No connection string — import the client\n and query.\n \n \n \n\n \n Admin session\n \n \n \n Pruning is an admin action. Sign in with Val Town and set{\" \"}\n AUTH_ADMIN_USERS to your Val Town username.\n \n \n {user\n ? (\n