[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_180":181,"_182":183},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_106":84,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":119,"_120":121,"_122":25,"_123":124,"_125":25,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":25},"version",2,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","main.tsx","latestPath","fileId","41aa81f0-579f-4e2b-977b-65799679847e","name","fileType","script","content","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\n/**\n * Every Val Town account comes with its own private\n * [SQLite database](https://www.sqlite.org/) that\n * is accessible from any of your vals.\n * ([Docs ↗](https://docs.val.town/std/sqlite))\n */\nexport const sqlite = {\n /**\n * Executes a SQLite statement.\n *\n * @param {InStatement} statement - The SQLite statement to execute.\n * @example String query:\n * `sqlite.execute(\"SELECT 1;\")`\n * @example Query with arguments:\n * `sqlite.execute({sql: \"SELECT * from books WHERE year > ?;\", args: [2020]})`\n */\n execute,\n\n /**\n * Executes a batch of SQLite statements.\n *\n * @param {InStatement[]} statements - An array of SQLite statements to execute.\n * @param {TransactionMode} [mode] - The transaction mode for the batch execution.\n */\n batch,\n};\n\n// ------------\n// Functions\n// ------------\n\nasync function execute(statement: InStatement): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${\n Deno.env.get(\"valtown\") || Deno.env.get(\"VAL_TOWN_API_KEY\")\n }`,\n },\n body: JSON.stringify({ statement }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n return res.json();\n}\n\nasync function batch(\n statements: InStatement[],\n mode?: TransactionMode,\n): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${\n Deno.env.get(\"valtown\") || Deno.env.get(\"VAL_TOWN_API_KEY\")\n }`,\n },\n body: JSON.stringify({ statements, mode }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n return res.json();\n}\n\nfunction createResError(body: string) {\n try {\n const e = zLibsqlError.parse(JSON.parse(body));\n // e.message already contains the code, and LibsqlError adds the\n // code to the beginning, so we remove it here\n const msg = e.message.replace(e.code, \"\").replace(/^:\\s+/, \"\");\n return new LibsqlError(msg, e.code, e.rawCode);\n } catch (_) {\n // Failed to parse libsql error\n }\n return new Error(body);\n}\n\n// ------------\n// Helpers\n// ------------\n\nconst zLibsqlError = z.object({\n message: z.string(),\n code: z.string(),\n rawCode: z.number().optional(),\n});\n\n// We patch these types to only support JSON values\nexport type InValue = null | string | number | boolean;\nexport type InArgs = Array | Record;\nexport type InStatement = {\n /**\n * The SQL statement to execute.\n */\n sql: string;\n\n /**\n * The arguments to bind to the SQL statement.\n */\n args: InArgs;\n} | string;\nexport interface ResultSet {\n /** Names of columns.\n *\n * Names of columns can be defined using the `AS` keyword in SQL:\n *\n * ```sql\n * SELECT author AS author, COUNT(*) AS count FROM books GROUP BY author\n * ```\n */\n columns: Array;\n\n /** Types of columns.\n *\n * The types are currently shown for types declared in a SQL table. For\n * column types of function calls, for example, an empty string is\n * returned.\n */\n columnTypes: Array;\n\n /** Rows produced by the statement. */\n rows: Array>;\n\n /** Number of rows that were affected by an UPDATE, INSERT or DELETE operation.\n *\n * This value is not specified for other SQL statements.\n */\n rowsAffected: number;\n\n /** ROWID of the last inserted row.\n *\n * This value is not specified if the SQL statement was not an INSERT or if the table was not a ROWID\n * table.\n */\n lastInsertRowid: bigint | undefined;\n}","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\n/**\n * Every Val Town account comes with its own private\n * [SQLite database](https://www.sqlite.org/) that\n * is accessible from any of your vals.\n * ([Docs ↗](https://docs.val.town/std/sqlite))\n */\nexport const sqlite = {\n /**\n * Executes a SQLite statement.\n *\n * @param {InStatement} statement - The SQLite statement to execute.\n * @example String query:\n * `sqlite.execute(\"SELECT 1;\")`\n * @example Query with arguments:\n * `sqlite.execute({sql: \"SELECT * from books WHERE year > ?;\", args: [2020]})`\n */\n execute,\n\n /**\n * Executes a batch of SQLite statements.\n *\n * @param {InStatement[]} statements - An array of SQLite statements to execute.\n * @param {TransactionMode} [mode] - The transaction mode for the batch execution.\n */\n batch,\n};\n\n// ------------\n// Functions\n// ------------\n\nasync function execute(statement: InStatement): Promise {\n const res = await fetch(`${API_URL}/v2/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${\n Deno.env.get(\"valtown\") || Deno.env.get(\"VAL_TOWN_API_KEY\")\n }`,\n },\n body: JSON.stringify({ statement }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n return res.json();\n}\n\nasync function batch(\n statements: InStatement[],\n mode?: TransactionMode,\n): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${\n Deno.env.get(\"valtown\") || Deno.env.get(\"VAL_TOWN_API_KEY\")\n }`,\n },\n body: JSON.stringify({ statements, mode }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n return res.json();\n}\n\nfunction createResError(body: string) {\n try {\n const e = zLibsqlError.parse(JSON.parse(body));\n // e.message already contains the code, and LibsqlError adds the\n // code to the beginning, so we remove it here\n const msg = e.message.replace(e.code, \"\").replace(/^:\\s+/, \"\");\n return new LibsqlError(msg, e.code, e.rawCode);\n } catch (_) {\n // Failed to parse libsql error\n }\n return new Error(body);\n}\n\n// ------------\n// Helpers\n// ------------\n\nconst zLibsqlError = z.object({\n message: z.string(),\n code: z.string(),\n rawCode: z.number().optional(),\n});\n\n// We patch these types to only support JSON values\nexport type InValue = null | string | number | boolean;\nexport type InArgs = Array | Record;\nexport type InStatement = {\n /**\n * The SQL statement to execute.\n */\n sql: string;\n\n /**\n * The arguments to bind to the SQL statement.\n */\n args: InArgs;\n} | string;\nexport interface ResultSet {\n /** Names of columns.\n *\n * Names of columns can be defined using the `AS` keyword in SQL:\n *\n * ```sql\n * SELECT author AS author, COUNT(*) AS count FROM books GROUP BY author\n * ```\n */\n columns: Array;\n\n /** Types of columns.\n *\n * The types are currently shown for types declared in a SQL table. For\n * column types of function calls, for example, an empty string is\n * returned.\n */\n columnTypes: Array;\n\n /** Rows produced by the statement. */\n rows: Array>;\n\n /** Number of rows that were affected by an UPDATE, INSERT or DELETE operation.\n *\n * This value is not specified for other SQL statements.\n */\n rowsAffected: number;\n\n /** ROWID of the last inserted row.\n *\n * This value is not specified if the SQL statement was not an INSERT or if the table was not a ROWID\n * table.\n */\n lastInsertRowid: bigint | undefined;\n}","createdAt",["D",1750087419702],"branchVersion","branchId","dc24f868-4ac5-11f0-8873-76b3cceeab13","id","dc21fb40-4ac5-11f0-8873-76b3cceeab13","sqlite2",["D",1750087411044],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","2019e55b-c541-4c51-bef0-008eef10ef88","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":54,"_102":103,"_104":25},"branch",{"_13":83,"_32":84,"_43":42,"_85":44,"_86":87,"_88":89,"_90":50,"_91":92,"_93":94,"_95":45,"_96":97},"isOwned",3,"main","projectId","forkedBranchId","ba8d03f8-25fe-11f0-b0b8-569c3dd06744","forkedBranchVersion",8,"forkedProjectPrivacy","forkedProjectId","ba8cb204-25fe-11f0-b0b8-569c3dd06744","forkedProjectOrgId","c606f87f-4d7e-48c8-9c39-ef5ab94aec49","projectName","userHandle","charmaine","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":176,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":177,"_78":178,"_80":179,"_82":25},"tree",[167,168],"files",[167,168],"counts",{"_157":60,"_158":147,"_159":60,"_160":161,"_162":163},"contents",[141,142],"upstreamProject",{"_43":92,"_32":137,"_52":138,"_53":-5,"_49":50,"_76":139},"upstreamBranch",{"_43":87,"_38":130,"_131":132,"_32":84,"_85":92,"_13":133,"_86":-5,"_88":-5,"_134":135,"_47":-5,"_82":25,"_49":50,"_96":136,"_61":94,"_95":137},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1746043643015],"updatedAt",["D",1789481204080],34,"lockfileKey","1789481204302-esm.town_v_std_sqlite@34-main","std","sqlite","Standard SQLite client for Val Town",{"_98":136,"_105":140},"https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJVaVhpQ1BId3dscVpBbkdZVWlMNjJtcjkxWS5wbmcifQ",{"_43":150,"_32":151,"_30":152,"_144":-5,"_41":42,"_40":147,"_145":153,"_38":154,"_13":60,"_33":20,"_35":155,"_24":25,"_148":-5,"_27":156},{"_43":143,"_32":28,"_30":31,"_144":-5,"_41":42,"_40":14,"_145":25,"_38":146,"_13":147,"_33":34,"_35":37,"_24":25,"_148":-5,"_27":149},"e1486172-4ac5-11f0-8c28-76b3cceeab13","parentId","latest",["D",1750087419702],1,"label",[28],"dc27615c-4ac5-11f0-8873-76b3cceeab13","README.md","af78748f-3314-41a7-bcbb-ce04ee654bf3",true,["D",1750087411044],"# SQLite - [Docs ↗](https://docs.val.town/std/sqlite)\n\n[SQLite](https://www.sqlite.org/) is a lightweight, standard database. Every Val Town account comes with its own private SQLite database that is accessible from any of your vals via [`std/sqlite`](https://www.val.town/v/std/sqlite).\n\nVal Town SQLite is powered by [Turso](https://turso.tech/).\n\n* [Usage](https://docs.val.town/std/sqlite/usage)\n* [Migrations](https://docs.val.town/std/sqlite/migrations)\n* [ORMs](https://docs.val.town/std/sqlite/orms)\n\nWe recommend these admin data viewers for managing your database – viewing or editing data or your database table schema:\n\n* [Outerbase Studio](https://libsqlstudio.com/) **(recommended)** - formely known as LibSQL Studio – see instructions [here](https://libsqlstudio.com/docs/connect-valtown)\n* [SQLite Explorer](https://www.val.town/v/nbbaier/sqliteExplorerApp) (built in Val Town)\n\n## Limits\n\nYou can store 10mb on the free plan and up to 1gb on the paid plan. Contact us if you need more space.\n\n\n[📝 Edit docs](https://github.com/val-town/val-town-docs/edit/main/src/content/docs/std/SQLite/index.mdx)\n\nMigrated from folder: sqlite/sqlite",[151],"pulls","branches","forks","envVars",{"_164":60,"_166":60},"connections",{"_164":60,"_165":60},"count","unfilledCount","emptyCount",{"_43":150,"_32":151,"_30":152,"_144":-5,"_41":42,"_40":147,"_145":153,"_38":173,"_13":60,"_33":20,"_35":155,"_24":25,"_148":-5,"_170":174,"_27":175},{"_43":143,"_32":28,"_30":31,"_144":-5,"_41":42,"_40":14,"_145":25,"_38":169,"_13":147,"_33":34,"_35":37,"_24":25,"_148":-5,"_170":171,"_27":172},["D",1750087419702],"children",[],[28],["D",1750087411044],[],[151],["D",1750087411044],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":54,"_102":103,"_104":25},{"_13":83,"_32":84,"_43":42,"_85":44,"_86":87,"_88":89,"_90":50,"_91":92,"_93":94,"_95":45,"_96":97},"ctx",{"_76":-5,"_127":213,"_214":215,"_216":217,"_218":25,"_219":25,"_220":25,"_221":153,"_222":-5,"_223":-7,"_224":-7,"_225":60,"_226":25,"_227":25,"_228":-5,"_229":25,"_230":25,"_231":25,"_232":-5},"ENV",{"_184":185,"_186":187,"_188":84,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v2