[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_538":539,"_540":541},"routes/_app.x.$handle.$name",{"_102":101,"_32":46,"_111":92,"_27":112,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_20":-5,"_123":-5,"_124":-5,"_125":25,"_126":127,"_128":61,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",377,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","frontend/pages/docs/page-sqlite.tsx","latestPath","fileId","094c700a-4c96-11f1-a693-ee650bb23af1","name","page-sqlite.tsx","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 Section,\n Table,\n TableBody,\n TableCell,\n TableHeader,\n TableHeaderCell,\n TableRow,\n Text,\n VStack,\n} from \"../../astryx/components.ts\";\nimport { PageLinks } 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

\n \n\n \n Visit log — live from SQLite\n

\n \n \n

\n \n\n \n App → service → SQLite\n \n \n \n Concept\n Example\n Note\n \n \n \n {CONCEPT_ROWS.map((r) => (\n \n \n \n \n \n {r.example}\n \n {r.note}\n \n ))}\n \n

\n \n\n \n Rules\n \n \n \n Rule\n Reason\n \n \n \n {RULE_ROWS.map((r) => (\n \n \n \n \n {r.reason}\n \n ))}\n \n

\n \n\n \n \n \n \n );\n}\n","/** @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

Diff · v377