[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_211":212,"_213":214},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_107":88,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":125,"_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":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",78,"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","queryDB.ts","latestPath","fileId","ed35234a-4294-11f1-ade9-42b51c65c3df","name","fileType","http","content","import sqlite from \"https://esm.town/v/std/sqlite@14-main/main.ts\";\n\nexport default async function (request: Request) {\n // extract requestec ID from query\n const queryParams = new URL(request.url).searchParams;\n const id = queryParams.get(\"id\");\n\n // retrieve record from db if it exists\n const resultSet = await sqlite.execute('SELECT * FROM \"data\" WHERE id=?', [\n id,\n ]);\n if (resultSet.rows.length > 0) {\n return Response.json(resultSet);\n } else {\n console.log(\"no record\");\n }\n}","import sqlite from \"https://esm.town/v/std/sqlite@14-main/main.ts\";\n\nexport default async function (request: Request) {\n // extract requestec ID from query\n const queryParams = new URL(request.url).searchParams;\n const id = queryParams.get(\"id\");\n\n // retrieve record from db if it exists\n const resultSet = await sqlite.execute(\"SELECT * FROM data WHERE id=?\", [\n id,\n ]);\n // if it exists, return record, else creat new record and return it\n if (resultSet.rows.length > 0) {\n return Response.json(resultSet);\n } else {\n console.log(\"no record\");\n const resultSet = await sqlite.execute(\n 'INSERT INTO data (contents) VALUES (\"\")',\n );\n return Response.json(resultSet);\n }\n}","createdAt",["D",1777340284931],"branchVersion","branchId","35f95a76-07c4-11f1-8afc-42dde27851f2","id","35f8fde2-07c4-11f1-8afc-42dde27851f2","database-demo",["D",1770867472565],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","A demo using the built-in SQLite DB to store unique user data","imageUrl","019b8c31-c867-72d0-a0f3-377b0a71335d","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019b8c31-c867-72d0-a0f3-3af4d1c41815","tursoName","35f8fde207c411f18afc42dde27851f2","tursoHostname","35f8fde207c411f18afc42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789518064818],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",114,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ceculbe","handle","displayName","Cory","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zN294dm1HMFFyZ0NhbWJUNmpBeEN3U0s1QWgifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":206,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":207,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":208,"_82":209,"_84":210,"_86":25},"tree",[185,186,187,188,189],"files",[185,186,187,188,189],"counts",{"_174":61,"_175":176,"_177":176,"_178":179,"_180":181},"contents",[130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":167,"_32":168,"_30":169,"_138":-5,"_41":42,"_40":170,"_140":25,"_38":171,"_13":164,"_33":20,"_35":172,"_24":25,"_143":-5,"_27":173},{"_43":159,"_32":160,"_30":161,"_138":-5,"_41":42,"_40":162,"_140":25,"_38":163,"_13":164,"_33":34,"_35":165,"_24":25,"_143":45,"_27":166},{"_43":154,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":155,"_13":156,"_33":34,"_35":37,"_24":25,"_143":157,"_27":158},{"_43":145,"_32":146,"_30":147,"_138":-5,"_41":42,"_40":148,"_140":25,"_38":149,"_13":150,"_33":151,"_35":152,"_24":25,"_143":-5,"_27":153},{"_43":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":139,"_140":125,"_38":141,"_13":142,"_33":20,"_35":108,"_24":25,"_143":-5,"_27":144},"83c8990a-4299-11f1-b394-42b51c65c3df","style.css","7b42d00c-4299-11f1-862b-42b51c65c3df","parentId",29,"latest",["D",1777336253346],2,"label",[136],"e653a5d0-42a1-11f1-b9e6-42b51c65c3df","script.js","04540ebe-4296-11f1-b045-42b51c65c3df",73,["D",1777339854638],27,"script","const id = localStorage.getItem(\"id\");\ngetUserData(\"4\");\n\nasync function getUserData(id: string) {\n // make an HTTP request to the queryDB endpoint for data matching the ID\n // then extract the json data\n // be sure to change the qdb subdomain to your endpoint's subdomain \n // you can find the subdomain in the HTTP settings for queryDB.ts\n const resp = await fetch(\"https://qdb.val.run/?id=\"+id); \n const data = await resp.json(); \n console.log(data.rows[0]);\n document.getElementById(\"intro\").innerHTML = \"Hi! Your user ID on this website is: \" + data.rows[0][0];\n document.getElementById(\"data\").innerHTML = \"The data we have stored for you is:
\" + data.rows[0][1];\n}",[146],"e6ccf88a-42a2-11f1-b4b8-42b51c65c3df",["D",1777340284931],28,"qdb",[28],"c828650a-4297-11f1-aec6-42b51c65c3df","main.ts","35fc6d4c-07c4-11f1-8afc-42dde27851f2",20,["D",1777335509064],8,"import sqlite from \"https://esm.town/v/std/sqlite@14-main/main.ts\";\nimport { staticHTTPServer } from \"https://esm.town/v/std/utils/index.ts\";\nawait sqlite.execute(\n 'CREATE TABLE IF NOT EXISTS \"data\" (\"id\" INTEGER PRIMARY KEY AUTOINCREMENT, \"contents\" TEXT)',\n);\n//await sqlite.execute( 'INSERT INTO \"data\" (\"contents\") VALUES (\"Hello, world!\")',);\n\nexport default staticHTTPServer(import.meta.url);",[160],"84889644-42a1-11f1-b0ab-42b51c65c3df","index.html","438be3aa-4295-11f1-9a42-42b51c65c3df",69,["D",1777339690574],"\n\n \n Database Demo\n \n \n \n \n \n \n

Database Demo

\n If you would like to store new data instead, type it in the text box and\n click Save New Data\n

\n \n \n \n",[168],"pulls","branches",1,"forks","envVars",{"_182":61,"_184":61},"connections",{"_182":61,"_183":61},"count","unfilledCount","emptyCount",{"_43":167,"_32":168,"_30":169,"_138":-5,"_41":42,"_40":170,"_140":25,"_38":203,"_13":164,"_33":20,"_35":172,"_24":25,"_143":-5,"_191":204,"_27":205},{"_43":159,"_32":160,"_30":161,"_138":-5,"_41":42,"_40":162,"_140":25,"_38":200,"_13":164,"_33":34,"_35":165,"_24":25,"_143":45,"_191":201,"_27":202},{"_43":154,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":25,"_38":197,"_13":156,"_33":34,"_35":37,"_24":25,"_143":157,"_191":198,"_27":199},{"_43":145,"_32":146,"_30":147,"_138":-5,"_41":42,"_40":148,"_140":25,"_38":194,"_13":150,"_33":151,"_35":152,"_24":25,"_143":-5,"_191":195,"_27":196},{"_43":135,"_32":136,"_30":137,"_138":-5,"_41":42,"_40":139,"_140":125,"_38":190,"_13":142,"_33":20,"_35":108,"_24":25,"_143":-5,"_191":192,"_27":193},["D",1777336253346],"children",[],[136],["D",1777339854638],[],[146],["D",1777340284931],[],[28],["D",1777335509064],[],[160],["D",1777339690574],[],[168],["D",1770867472565],["D",1789518064818],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":55,"_103":104,"_105":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_127":244,"_245":246,"_247":248,"_249":25,"_250":25,"_251":25,"_252":125,"_253":-5,"_254":-7,"_255":-7,"_256":61,"_257":25,"_258":25,"_259":-5,"_260":25,"_261":25,"_262":25,"_263":-5},"ENV",{"_215":216,"_217":218,"_219":88,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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 · v78