[{"_1":2,"_402":-5,"_403":-5},"loaderData",{"_3":4,"_92":93,"_180":181,"_401":-5},"root",{"_5":6,"_33":34,"_59":60,"_90":91},"ctx",{"_7":8,"_18":19,"_20":-5,"_21":22,"_23":24,"_25":26,"_27":26,"_28":26,"_29":30,"_31":32},"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_selection_ai","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","3c31150dafe09c885efd1ad349c1e23d5ba90676","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","c7de7de11d2fa3884730f0fa9fd384f8","clerkState",{"_61":62},"__internal_clerk_state",{"_63":64,"_65":44,"_66":67,"_68":67,"_69":26,"_70":67,"_71":67,"_72":67,"_73":67,"_74":67,"_75":67,"_76":67,"_77":67,"_78":79,"_88":26,"_89":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",{"_80":26,"_81":67,"_82":83,"_84":67,"_85":44,"_86":26,"_87":67},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.v.$handle.$name",{"_94":95,"_96":97,"_95":98,"_175":-5,"_176":-5,"_177":178,"_136":141,"_134":147,"_101":102,"_99":100,"_120":-7,"_51":52,"_179":26},"type","val","author","c9143560-63b6-444f-8f9f-e2647fabe09f",{"_99":100,"_96":97,"_101":102,"_103":104,"_105":-5,"_106":107,"_108":109,"_110":111,"_112":113,"_114":26,"_115":113,"_116":117,"_118":119,"_120":121,"_122":26,"_123":32,"_124":125,"_126":127,"_128":91,"_129":32,"_130":32,"_131":132,"_20":140,"_143":-5,"_144":-7,"_145":146,"_134":147,"_148":149},"name","sqlite","valNameId","5bf17b14-2a78-4951-b4f2-e361000a640a","parentFolderId","609574e7-9268-43da-9a3a-6157cab799a9","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","56c849ee-f1f8-11ee-9b87-cab58f78796a","legacyPrivate","id","code","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 ${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}","createdAt",["D",1712175940519],"version",6,"currentUserHasLiked","likeCount","forkCount",9,"referenceCount",2217,"dependencyCount","commentCount","prCount","mergedPr",{"_115":133,"_134":135,"_136":137,"_138":139},"1be29210-eaf7-11ee-921f-8aad37b30b4b","description","Update JSDocs","handle","andreterron","profileImageUrl","https://avatars.githubusercontent.com/u/1753594?v=4",{"_136":141,"_138":142},"std","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJVaVhpQ1BId3dscVpBbkdZVWlMNjJtcjkxWS5wbmcifQ","forkedVal","interval","slug","std/sqlite","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",[150,153,157,161,165,168,172],{"_120":121,"_151":133,"_118":152,"_115":113},"prId",["D",1712175940519],{"_120":154,"_151":-5,"_118":155,"_115":156},5,["D",1710276658820],"3aabf686-e0b2-11ee-a26f-8aad37b30b4b",{"_120":158,"_151":-5,"_118":159,"_115":160},4,["D",1700233073835],"0c83614f-06ff-4ab7-b4e1-18533c33b767",{"_120":162,"_151":-5,"_118":163,"_115":164},3,["D",1700183628954],"a5aa302d-527b-4107-a2df-e06b478624c5",{"_120":91,"_151":-5,"_118":166,"_115":167},["D",1700160476497],"4d7ca811-0102-449f-83ec-a56c2f764e0b",{"_120":169,"_151":-5,"_118":170,"_115":171},1,["D",1700160339221],"a7ff37b2-f552-4b55-875a-80a8df0bcf9a",{"_120":32,"_151":-5,"_118":173,"_115":174},["D",1700160325624],"a24a4998-ed57-4723-af2c-b9be7bc465c8","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.forks",{"_182":183,"_397":125,"_398":146,"_399":32,"_95":400},"forksList",[184,222,236,250,267,281,297,344,377],{"_101":185,"_186":187},"184239a0-f12f-11ef-aac2-e6cdfca9ef9f","initialData",{"_99":100,"_96":188,"_101":185,"_103":-5,"_105":-5,"_106":107,"_108":109,"_110":111,"_112":189,"_114":26,"_115":189,"_116":190,"_118":191,"_120":121,"_122":26,"_123":32,"_126":32,"_128":32,"_129":32,"_124":32,"_130":32,"_131":-5,"_20":192,"_143":195,"_144":-7,"_134":147,"_197":-5,"_145":198,"_148":199},"7c0d1cad-83fd-4c0e-b722-56e2dba6627c","9d47e6e2-f132-11ef-9d02-e6cdfca9ef9f","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}",["D",1740238516095],{"_136":193,"_138":194},"justbe","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2F2YXRhcnMuZ2l0aHVidXNlcmNvbnRlbnQuY29tL3UvMzA4NzIyNT92PTQiLCJzIjoiODRqbjJSZG5jOWkyNUgrUXJIU0dRUWZnQmRrQ01LY2NxUTBUMm5nTEVQOCJ9",{"_115":113,"_136":141,"_99":100,"_120":121,"_196":-5},"prDisabledHint","latestEvaluation","justbe/sqlite",[200,204,207,210,213,216,219],{"_118":201,"_120":121,"_202":203},["D",1740238516095],"n","1",{"_118":205,"_120":154,"_202":206},["D",1740237992025],"2",{"_118":208,"_120":158,"_202":209},["D",1740237936232],"3",{"_118":211,"_120":162,"_202":212},["D",1740237840525],"4",{"_118":214,"_120":91,"_202":215},["D",1740237717927],"5",{"_118":217,"_120":169,"_202":218},["D",1740237246714],"6",{"_118":220,"_120":32,"_202":221},["D",1740237004439],"7",{"_101":223,"_186":224},"e0703c1a-ed47-11ef-b175-e6cdfca9ef9f",{"_99":100,"_96":225,"_101":223,"_103":-5,"_105":-5,"_106":107,"_108":109,"_110":111,"_112":226,"_114":26,"_115":226,"_116":117,"_118":227,"_120":32,"_122":26,"_123":32,"_126":32,"_128":169,"_129":32,"_124":32,"_130":32,"_131":-5,"_20":228,"_143":231,"_144":-7,"_134":147,"_197":-5,"_145":232,"_148":233},"2fb41e80-ecf9-11ef-af12-67b5d5b0b458","e09b6b2e-ed47-11ef-b175-e6cdfca9ef9f",["D",1739807843554],{"_136":229,"_138":230},"Sm202020","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ydDlwRG5KQnB2QzNEZ3R2bEtVRTlhbXFKZ3QifQ",{"_115":113,"_136":141,"_99":100,"_120":121,"_196":-5},"Sm202020/sqlite",[234],{"_118":235,"_120":32,"_202":203},["D",1739807843554],{"_101":237,"_186":238},"9e9f382e-e002-11ef-bcaa-e6cdfca9ef9f",{"_99":100,"_96":239,"_101":237,"_103":-5,"_105":-5,"_106":107,"_108":109,"_110":111,"_112":240,"_114":26,"_115":240,"_116":117,"_118":241,"_120":32,"_122":26,"_123":32,"_126":32,"_128":169,"_129":32,"_124":32,"_130":32,"_131":-5,"_20":242,"_143":245,"_144":-7,"_134":147,"_197":-5,"_145":246,"_148":247},"2f6612a3-739c-45fe-9278-fee14e69db17","9ec795bc-e002-11ef-bcaa-e6cdfca9ef9f",["D",1738348732749],{"_136":243,"_138":244},"awhitter","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycW1ieUViTzZocW1rQ0VIa1I3MENCM1hSem8ifQ",{"_115":113,"_136":141,"_99":100,"_120":121,"_196":-5},"awhitter/sqlite",[248],{"_118":249,"_120":32,"_202":203},["D",1738348732749],{"_101":251,"_186":252},"8671df62-ac32-11ef-8902-e6cdfca9ef9f",{"_99":253,"_96":97,"_101":251,"_103":-5,"_105":-5,"_106":107,"_108":254,"_110":111,"_112":255,"_114":26,"_115":255,"_116":256,"_118":257,"_120":169,"_122":26,"_123":32,"_126":91,"_128":32,"_129":32,"_124":32,"_130":32,"_131":-5,"_20":258,"_143":259,"_144":-7,"_134":260,"_197":-5,"_145":261,"_148":262},"sqlite2","# SQLite2 - [Docs ↗](https://docs.val.town/std/sqlite)\n\n_This is our second generation SQLite client: it exposes a different API than [std/sqlite](https://www.val.town/v/std/sqlite).\nSpecifically, this will support the full [@libsql/client interface](https://docs.turso.tech/sdk/ts/reference#simple-query)._\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## New in sqlite2\n\n- Support for inserting and retreiving values from `BLOB` columns.\n- Improved performance\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)","a21c9e3c-ac32-11ef-8902-e6cdfca9ef9f","import { createClient } from \"https://esm.sh/@libsql/client@0.6.0/web\";\n\nexport const sqlite = createClient({\n url: \"https://api.val.town/v2/sqlite/\",\n authToken: Deno.env.get(\"VAL_TOWN_API_KEY\"),\n});",["D",1732651893980],{"_136":141,"_138":142},{"_115":113,"_136":141,"_99":100,"_120":121,"_196":-5},"SQLite2 - Docs ↗ This is our second generation SQLite client: it exposes a different API than std/sqlite .\nSpecifically, this will support the full @libsql/client interface . 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) New in sqlite2 Support for inserting and retreiving values from BLOB columns. Improved performance 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","std/sqlite2",[263,265],{"_118":264,"_120":169,"_202":203},["D",1732651893980],{"_118":266,"_120":32,"_202":206},["D",1732651847461],{"_101":268,"_186":269},"111a5e0e-a955-11ef-9710-e6cdfca9ef9f",{"_99":100,"_96":270,"_101":268,"_103":-5,"_105":-5,"_106":107,"_108":109,"_110":111,"_112":271,"_114":26,"_115":271,"_116":117,"_118":272,"_120":32,"_122":26,"_123":32,"_126":32,"_128":169,"_129":32,"_124":32,"_130":32,"_131":-5,"_20":273,"_143":276,"_144":-7,"_134":147,"_197":-5,"_145":277,"_148":278},"4f6acec8-020a-4824-92fc-10fab4964b90","11425dfa-a955-11ef-9710-e6cdfca9ef9f",["D",1732336829590],{"_136":274,"_138":275},"dkinzer222","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycDNaVmdpMERldU0wQ0g3eklEUkcxVldheTcifQ",{"_115":113,"_136":141,"_99":100,"_120":121,"_196":-5},"dkinzer222/sqlite",[279],{"_118":280,"_120":32,"_202":203},["D",1732336829590],{"_101":282,"_186":283},"ebec78cc-5b45-11ef-a410-de64eea55b61",{"_99":100,"_96":284,"_101":282,"_103":-5,"_105":-5,"_106":107,"_108":285,"_110":111,"_112":286,"_114":26,"_115":286,"_116":117,"_118":287,"_120":32,"_122":26,"_123":32,"_126":32,"_128":169,"_129":32,"_124":32,"_130":32,"_131":-5,"_20":288,"_143":291,"_144":-7,"_134":292,"_197":-5,"_145":293,"_148":294},"418c1e39-eb48-4f2f-8c97-122ece94631c","# 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\nYou may find these admin viewers helpful managing your database:\n\n* [SQLite Explorer](https://www.val.town/v/nbbaier/sqliteExplorerApp) (built in Val Town)\n* [LibSQL Studio](https://libsqlstudio.com/)\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)","ec226392-5b45-11ef-a410-de64eea55b61",["D",1723754134429],{"_136":289,"_138":290},"maxm","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJnTEtkSHlOMWxWZm1GRHdKYUVTNklYM3FpdiJ9",{"_115":113,"_136":141,"_99":100,"_120":121,"_196":-5},"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 You may find these admin viewers helpful managing your database: SQLite Explorer (built in Val Town) LibSQL Studio 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","maxm/sqlite",[295],{"_118":296,"_120":32,"_202":203},["D",1723754134429],{"_101":298,"_186":299},"08f95904-3584-11ef-8995-0e10024e3b32",{"_99":100,"_96":300,"_101":298,"_103":301,"_105":-5,"_106":107,"_108":302,"_110":111,"_112":303,"_114":26,"_115":303,"_116":304,"_118":305,"_120":306,"_122":26,"_123":306,"_126":307,"_128":169,"_129":169,"_124":308,"_130":32,"_131":-5,"_20":309,"_143":312,"_144":-7,"_134":313,"_197":-5,"_145":314,"_148":315},"a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","76a8911e-393e-11ef-8e71-de64eea55b61","# LLM-Safe Fork of @std/sqlite\n\nWe found that LLMs have trouble with the inputs and outputs of our @std/sqlite method.\n\n1. It expects the input to be `(sql: string, args: any[])` but it's `{ sql: string, args: any[] }`\n2. It expects the output to be objects, but they are arrays\n\nInstead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. \n\nThis val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","5631f2d0-dcb9-11ef-80ec-e6cdfca9ef9f","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type ResultSet, type Row, 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, args?: InArgs): Promise {\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: normalizeStatement(statement, args) }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSet = await res.json();\n return upgradeResultSet(resultSet);\n}\n\nasync function batch(statements: InStatement[], mode?: TransactionMode): Promise {\n if (mode && ![\"write\", \"read\", \"deferred\"].includes(mode)) {\n throw new Error(\"Invalid transaction mode provided to sqlite.batch. Must be 'write', 'read', or 'deferred.\");\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: statements.map(s => normalizeStatement(s)), mode }),\n });\n if (!res.ok) {\n throw createResError(await res.text());\n }\n const resultSets = await res.json();\n return resultSets.map(upgradeResultSet);\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/* Val Town's Turso Proxy returns rows as an array of values\n * Yet the LibSQL API has a Row type which behave as an array or object,\n * ie you can access it via numerical index or string\n */\ninterface ImpoverishedResultSet extends ResultSet {\n rows: any[];\n}\n\nfunction normalizeStatement(statement: InStatement, args?: InArgs) {\n if (Array.isArray(statement)) {\n // for the case of an array of arrays\n return normalizeStatement(statement[0], statement[1]);\n }\n if (typeof statement === \"string\") {\n if (args) {\n return { sql: statement, args };\n } else return statement;\n }\n else if (typeof statement === \"object\") {\n if (statement.args) {\n return statement;\n }\n if (args) {\n return { sql: statement.sql, args };\n }\n return statement.sql;\n }\n else throw new Error(\"Error normalizing sql input\");\n}\n\nfunction upgradeResultSet(results: ImpoverishedResultSet): ResultSet {\n return {\n ...results,\n rows: results.rows.map(row => rowFromSql(row, results.columns)),\n };\n}\n\n// adapted from\n// https://github.com/tursodatabase/libsql-client-ts/blob/17dd996b840c950dd22b871adfe4ba0eb4a5ead3/packages/libsql-client/src/sqlite3.ts#L314C1-L337C2\nfunction rowFromSql(\n sqlRow: Array,\n columns: Array,\n): Row {\n const row = {};\n // make sure that the \"length\" property is not enumerable\n Object.defineProperty(row, \"length\", { value: sqlRow.length });\n for (let i = 0; i < sqlRow.length; ++i) {\n const value = sqlRow[i];\n Object.defineProperty(row, i, { value });\n\n const column = columns[i];\n if (!Object.hasOwn(row, column)) {\n Object.defineProperty(row, column, {\n value,\n enumerable: true,\n configurable: true,\n writable: true,\n });\n }\n }\n return row as Row;\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;",["D",1737987404484],13,19547,21,{"_136":310,"_138":311},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg",{"_115":113,"_136":141,"_99":100,"_120":121,"_196":-5},"LLM-Safe Fork of @std/sqlite We found that LLMs have trouble with the inputs and outputs of our @std/sqlite method. It expects the input to be (sql: string, args: any[]) but it's { sql: string, args: any[] } It expects the output to be objects, but they are arrays Instead of struggling to teach it, we built this val to be a wrapper around @std/sqlite that adheres to what the LLMs expect. This val is also backwards-compatible with @std/sqlite, so we're considering merging it in.","stevekrouse/sqlite",[316,318,321,324,327,329,332,335,338,341],{"_118":317,"_120":306,"_202":203},["D",1737987404484],{"_118":319,"_120":320,"_202":206},["D",1724087412304],12,{"_118":322,"_120":323,"_202":209},["D",1724087404512],11,{"_118":325,"_120":326,"_202":212},["D",1723494410142],10,{"_118":328,"_120":125,"_202":215},["D",1723494389876],{"_118":330,"_120":331,"_202":218},["D",1723494345363],8,{"_118":333,"_120":334,"_202":221},["D",1723494323065],7,{"_118":336,"_120":121,"_202":337},["D",1719604370206],"8",{"_118":339,"_120":154,"_202":340},["D",1719604260994],"9",{"_118":342,"_120":158,"_202":343},["D",1719604144103],"10",{"_101":345,"_186":346},"b3442c6a-eaf5-11ee-92d4-8aad37b30b4b",{"_99":347,"_96":348,"_101":345,"_103":-5,"_105":-5,"_106":107,"_108":349,"_110":111,"_112":350,"_114":26,"_115":350,"_116":117,"_118":351,"_120":320,"_122":26,"_123":32,"_126":169,"_128":169,"_129":162,"_124":32,"_130":32,"_131":-5,"_20":352,"_143":353,"_144":-7,"_134":354,"_197":-5,"_145":355,"_148":356},"sqlite_docs","ec6d37b4-1291-4ea3-93b7-d7972929dc8b","# Val Town SQLite - https://docs.val.town/std/sqlite","fce55714-f1f7-11ee-ae9a-cab58f78796a",["D",1712175789715],{"_136":137,"_138":139},{"_115":156,"_136":141,"_99":100,"_120":154,"_196":-5},"Val Town SQLite - https://docs.val.town/std/sqlite","andreterron/sqlite_docs",[357,359,361,363,365,367,369,371,373,375],{"_118":358,"_120":320,"_202":203},["D",1712175789715],{"_118":360,"_120":323,"_202":206},["D",1712175237935],{"_118":362,"_120":326,"_202":209},["D",1712175214281],{"_118":364,"_120":125,"_202":212},["D",1712175178181],{"_118":366,"_120":331,"_202":215},["D",1712175152107],{"_118":368,"_120":334,"_202":218},["D",1712175122176],{"_118":370,"_120":121,"_202":221},["D",1712174879755],{"_118":372,"_120":154,"_202":337},["D",1711494600051],{"_118":374,"_120":158,"_202":340},["D",1711494549002],{"_118":376,"_120":162,"_202":343},["D",1711405715930],{"_101":378,"_186":379},"f0d53786-40a7-485b-bc98-0653f5a2103a",{"_99":380,"_96":381,"_101":378,"_103":-5,"_105":-5,"_106":107,"_108":382,"_110":111,"_112":383,"_114":26,"_115":383,"_116":384,"_118":385,"_120":169,"_122":26,"_123":32,"_126":32,"_128":169,"_129":32,"_124":32,"_130":32,"_131":-5,"_20":386,"_143":389,"_144":-7,"_134":390,"_197":-5,"_145":391,"_148":392},"untitled_aquaQuail","c2457fb2-0ade-4dbe-a720-5cbc601e18fa","# Val Town SQLite\n\nDocs: https://docs.val.town/std/sqlite/","3ce61db0-2773-4c54-ada1-adb8f76050df","import { API_URL } from \"https://esm.town/v/std/API_URL\";\nimport { LibsqlError, type ResultSet, type TransactionMode } from \"npm:@libsql/client\";\nimport { z } from \"npm:zod\";\n\nexport const sqlite = {\n execute,\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 ${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 sql: string;\n args: InArgs;\n} | string;",["D",1702376978973],{"_136":387,"_138":388},"liflovs","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yWlJGNEhqU1NQODhvb1k1c044aUQ3dXM2dWgifQ",{"_115":160,"_136":141,"_99":100,"_120":158,"_196":-5},"Val Town SQLite Docs: https://docs.val.town/std/sqlite/","liflovs/untitled_aquaQuail",[393,395],{"_118":394,"_120":169,"_202":203},["D",1702376978973],{"_118":396,"_120":32,"_202":206},["D",1702376976176],"forksCount","valname","page",{"_115":113,"_99":100,"_136":141,"_11":97,"_120":121,"_101":102,"_116":117,"_106":107,"_114":26,"_145":146},"routes/_app","actionData","errors"]