[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_176":177,"_178":179},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_107":85,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_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":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",6,"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","70bc641e-2822-11f0-af78-569c3dd06744","name","fileType","script","content","import { runValAPIAuth } from \"https://esm.town/v/stevekrouse/runValAPIAuth\";\n\n// grab the types off turso's client without importing it\nlet tursoImport = () => import(\"https://esm.sh/@libsql/client/web\");\ntype createClient = Awaited>[\"createClient\"];\n\nexport function turso(keys, handle?) {\n let val = \"@std.tursoAPI\";\n let f = (method) => (...args) =>\n runValAPIAuth({\n val,\n args: [method, args],\n keys,\n handle,\n });\n return {\n execute: f(\"execute\") as ReturnType[\"execute\"],\n batch: f(\"batch\") as ReturnType[\"batch\"],\n transaction: f(\"transaction\") as ReturnType[\"transaction\"],\n };\n}\n\nexport const test = turso();","import { runValAPIAuth } from \"https://esm.town/v/stevekrouse/runValAPIAuth\";\n\n// grab the types off turso's client without importing it\nlet tursoImport = () => import(\"https://esm.sh/@libsql/client/web\");\ntype createClient = Awaited>[\"createClient\"];\n\nexport function turso(keys, handle?) {\n let val = \"@std.tursoAPI\";\n let f = (method) => (...args) =>\n runValAPIAuth({\n val,\n args: [method, args],\n keys,\n handle,\n });\n return {\n execute: f(\"execute\") as ReturnType[\"execute\"],\n batch: f(\"batch\") as ReturnType[\"batch\"],\n transaction: f(\"transaction\") as ReturnType[\"transaction\"],\n };\n}\n\nconst test = turso();","createdAt",["D",1701804881705],"branchVersion","branchId","70ba412a-2822-11f0-af78-569c3dd06744","id","70b9f986-2822-11f0-af78-569c3dd06744","untitled_blackBee",["D",1746278883370],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","f48e9547-27bd-4117-9554-682f2eb67a4b","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","4f5bd3a8-17ca-44d2-b569-1c9fcdb094b9","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":54,"_103":104,"_105":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":88,"_89":61,"_90":91,"_92":93,"_94":95,"_96":45,"_97":98},"isOwned",11,"main","projectId","forkedBranchId","bbec6a86-25fe-11f0-b0b8-569c3dd06744","forkedBranchVersion","forkedProjectPrivacy","unlisted","forkedProjectId","bbec2940-25fe-11f0-b0b8-569c3dd06744","forkedProjectOrgId","c606f87f-4d7e-48c8-9c39-ef5ab94aec49","projectName","userHandle","boucher","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJObXh1eU1FSEZMMTNaWFM1Rm5rYXBrd0pBRyIsImluaXRpYWxzIjoiUkIifQ","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":172,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":173,"_79":174,"_81":175,"_83":25},"tree",[163,164],"files",[163,164],"counts",{"_153":61,"_154":149,"_155":61,"_156":157,"_158":159},"contents",[137,138],"upstreamProject","upstreamBranch",{"_43":88,"_38":130,"_131":132,"_32":85,"_86":93,"_13":133,"_87":-5,"_89":-5,"_134":-5,"_47":-5,"_83":25,"_49":91,"_97":135,"_62":95,"_96":136},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1746043645320],"updatedAt",["D",1698773684374],12,"lockfileKey","std","turso",{"_43":146,"_32":147,"_30":148,"_140":-5,"_41":42,"_40":149,"_141":57,"_38":150,"_13":61,"_33":20,"_35":151,"_24":25,"_144":-5,"_27":152},{"_43":139,"_32":28,"_30":31,"_140":-5,"_41":42,"_40":14,"_141":25,"_38":142,"_13":143,"_33":34,"_35":37,"_24":25,"_144":-5,"_27":145},"70da5c62-2822-11f0-af78-569c3dd06744","parentId","latest",["D",1701804881705],5,"label",[28],"70bc6888-2822-11f0-af78-569c3dd06744","README.md","70bc6914-2822-11f0-af78-569c3dd06744",1,["D",1701804813242],"# Deprecated in favor of [`std/sqlite`](https://www.val.town/v/std/sqlite) (also powered by Turso)\n\n`std/turso` was the initial version of our integration with Turso. It was so popular, we rebuilt it to be faster and easier to use: [`std/sqlite`](https://www.val.town/v/std/sqlite).\n\n![turso (2).png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/f35e1afe-a51e-4dd2-d4f9-63369afb0300/public)\n\n[Turso](https://turso.tech/) is a serverless SQLite platform designed for the edge. It runs [libSQL](https://github.com/libsql/libsql), their open contribution fork of SQLite.\n\nEvery Val Town user automatically gets their own Turso SQLite database! It's great for >100kb data (ie bigger than a val) or when you need SQL: relations, ACID transactions, etc.\n\nStorage used in Turso will count against your Val Town total storage (10mb for free users; 1gb for Pro users). Contact us if you'd need more – it should be no problem!\n\n## Getting started\n\nThis val uses [our public key auth scheme](https://blog.val.town/public-key-auth-val-town-users-can-be-your-users).\n\n1. [Generate your keypair](https://www.val.town/embed/new?code=import+%7B+set+%7D+from+%22https%3A%2F%2Fesm.town%2Fv%2Fstd%2Fset%22%3B%0Aimport+%7B+generateKeys+%7D+from+%22https%3A%2F%2Fesm.town%2Fv%2Fstevekrouse%2FgenerateKeys%22%3B%0A%0Alet+keys+%3D+await+generateKeys%28%29%0A%0Aexport+let+exportedKeySetter+%3D+Promise.all%28%5B%0A++set%28%22exportedKeys%22%2C+keys%29%2C%0A++set%28%22publicKey%22%2C+keys.publicKey%29%0A%5D%29)\n2. On [your publicKey](https://www.val.town/v/me/publicKey) click the lock icon🔒 to change the permissions to `Unlisted`.\n3. [Fork this helper function](https://www.val.town/v/stevekrouse.turso/fork) replacing `stevekrouse` with your own username\n4. [Try out some queries!](https://www.val.town/v/stevekrouse.tursoExamples/fork)\n\n## Usage\n\nThis val returns a [Turso SDK's Client](https://docs.turso.tech/reference/client-access/javascript-typescript-sdk), which supports `execute`, `batch`, and `transaction`.\n\n```js\nawait @me.turso().execute(`create table blobs(\n key text unique, \n value text\n)`)\n```\n\n[More example usage](https://www.val.town/v/stevekrouse.tursoExamples)\n\n## Architecture\n\nThis @std.turso function is the client or SDK to @std.tursoAPI, which acts as a \"proxy\" to Turso. It handles authentication, creates databases, and forwards on your SQL queries. You can get lower latency (~200ms vs ~800ms), more storage, databases, CLI & API access by having your own Turso account.",[147],"pulls","branches","forks","envVars",{"_160":61,"_162":61},"connections",{"_160":61,"_161":61},"count","unfilledCount","emptyCount",{"_43":146,"_32":147,"_30":148,"_140":-5,"_41":42,"_40":149,"_141":57,"_38":169,"_13":61,"_33":20,"_35":151,"_24":25,"_144":-5,"_166":170,"_27":171},{"_43":139,"_32":28,"_30":31,"_140":-5,"_41":42,"_40":14,"_141":25,"_38":165,"_13":143,"_33":34,"_35":37,"_24":25,"_144":-5,"_166":167,"_27":168},["D",1701804881705],"children",[],[28],["D",1701804813242],[],[147],["D",1746278883370],{"_99":98,"_106":102},{"_99":98,"_100":-5,"_101":102,"_18":54,"_103":104,"_105":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":88,"_89":61,"_90":91,"_92":93,"_94":95,"_96":45,"_97":98},"ctx",{"_77":-5,"_127":209,"_210":211,"_212":213,"_214":25,"_215":25,"_216":25,"_217":57,"_218":-5,"_219":-7,"_220":-7,"_221":61,"_222":25,"_223":25,"_224":-5,"_225":25,"_226":25,"_227":25,"_228":-5},"ENV",{"_180":181,"_182":183,"_184":85,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","c73f21da490985bff19c279eb0e09db24d688e4f","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 · v6