[{"_1":2,"_188":-5,"_189":-5},"loaderData",{"_3":4,"_91":92,"_175":176,"_187":-5},"root",{"_5":6,"_32":33,"_58":59,"_89":90},"ctx",{"_7":8,"_18":19,"_20":-5,"_21":22,"_23":24,"_25":26,"_27":26,"_28":29,"_30":31},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"sessionClaims","sessionId","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","2f1ccb131a13aa73adf80ad81406989cf85fa22f","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","WORKER_FINGERPRINT","d0746fd0512e0614e3f717607f0da4cd","clerkState",{"_60":61},"__internal_clerk_state",{"_62":63,"_64":43,"_65":66,"_67":66,"_68":26,"_69":66,"_70":66,"_71":66,"_72":66,"_73":66,"_74":66,"_75":66,"_76":66,"_77":78,"_87":26,"_88":26},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_79":26,"_80":66,"_81":82,"_83":66,"_84":43,"_85":26,"_86":66},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.v.$handle.$name",{"_93":94,"_95":96,"_94":97,"_170":-5,"_171":-5,"_172":173,"_129":130,"_141":142,"_100":101,"_98":99,"_118":-7,"_50":51,"_174":26},"type","val","author","7c0d1cad-83fd-4c0e-b722-56e2dba6627c",{"_98":99,"_95":96,"_100":101,"_102":-5,"_103":-5,"_104":105,"_106":107,"_108":109,"_110":111,"_112":26,"_113":111,"_114":115,"_116":117,"_118":119,"_120":26,"_121":31,"_122":31,"_123":31,"_124":31,"_125":31,"_126":31,"_127":-5,"_20":128,"_133":134,"_138":-7,"_139":140,"_141":142,"_143":144},"name","sqlite","valNameId","184239a0-f12f-11ef-aac2-e6cdfca9ef9f","parentFolderId","isOwned","privacy","public","readme","# 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)","valType","script","currentVersion","9d47e6e2-f132-11ef-9d02-e6cdfca9ef9f","legacyPrivate","id","code","import { createClient, LibsqlError, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\nconst isValtown = !!Deno.env.get(\"valtown\");\n\nconst client = isValtown ? null : createClient({ url: Deno.env.get(\"db\") || \"file:local.db\" });\nconst API_URL = isValtown ? Deno.env.get(\"VALTOWN_API_URL\") : null;\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 if (!isValtown) {\n return client!.execute(statement);\n }\n\n const res = await fetch(`${API_URL}/v1/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\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(statements: InStatement[], mode?: TransactionMode): Promise {\n if (!isValtown) {\n return client!.batch(statements, mode);\n }\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\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",1740238516095],"version",6,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_129":130,"_131":132},"handle","justbe","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2F2YXRhcnMuZ2l0aHVidXNlcmNvbnRlbnQuY29tL3UvMzA4NzIyNT92PTQiLCJzIjoiODRqbjJSZG5jOWkyNUgrUXJIU0dRUWZnQmRrQ01LY2NxUTBUMm5nTEVQOCJ9","forkedVal",{"_113":135,"_129":136,"_98":99,"_118":119,"_137":-5},"56c849ee-f1f8-11ee-9b87-cab58f78796a","std","prDisabledHint","interval","slug","justbe/sqlite","description","SQLite - Docs ↗ SQLite 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 . Val Town SQLite is powered by Turso . Usage Migrations ORMs We recommend these admin data viewers for managing your database – viewing or editing data or your database table schema: Outerbase Studio (recommended) - formely known as LibSQL Studio – see instructions here SQLite Explorer (built in Val Town) Limits You can store 10mb on the free plan and up to 1gb on the paid plan. Contact us if you need more space. 📝 Edit docs","versions",[145,148,152,156,160,163,167],{"_118":119,"_146":-5,"_116":147,"_113":111},"prId",["D",1740238516095],{"_118":149,"_146":-5,"_116":150,"_113":151},5,["D",1740237992025],"64e94198-f131-11ef-8ec7-e6cdfca9ef9f",{"_118":153,"_146":-5,"_116":154,"_113":155},4,["D",1740237936232],"43a7946c-f131-11ef-bea7-e6cdfca9ef9f",{"_118":157,"_146":-5,"_116":158,"_113":159},3,["D",1740237840525],"0a9d1df4-f131-11ef-8dce-e6cdfca9ef9f",{"_118":90,"_146":-5,"_116":161,"_113":162},["D",1740237717927],"c1892d4c-f130-11ef-8994-e6cdfca9ef9f",{"_118":164,"_146":-5,"_116":165,"_113":166},1,["D",1740237246714],"a8ab9838-f12f-11ef-b4c9-e6cdfca9ef9f",{"_118":31,"_146":-5,"_116":168,"_113":169},["D",1740237004439],"187067d0-f12f-11ef-aac2-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":177,"_178":179,"_94":180},"single","redirect","/v/justbe/sqlite/versions",{"_113":159,"_114":181,"_118":157,"_116":182,"_183":99,"_100":101,"_108":109,"_129":130,"_11":96,"_184":-5,"_185":-5,"_186":-5,"_174":26,"_139":140},"import { createClient, LibsqlError, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\nconst isValtown = !!Deno.env.get(\"valtown\");\n\nconst client = isValtown ? null : createClient({ url: Deno.env.get(\"db\") || \"file:local.db\" });\nconst API_URL = isValtown ? Deno.env.get(\"VALTOWN_API_URL\") : null;\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 if (!isValtown) {\n return client!.execute(statement);\n }\n\n const res = await fetch(`${API_URL}/v1/sqlite/execute`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\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(statements: InStatement[], mode?: TransactionMode): Promise {\n const res = await fetch(`${API_URL}/v1/sqlite/batch`, {\n method: \"POST\",\n headers: {\n Authorization: `Bearer ${Deno.env.get(\"valtown\")}`,\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}",["D",1740237840525],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

sqlite

Version 3